User Posts: Naimul Hasan Arif
0
How to Calculate Discounted Cash Flow in Excel (with Easy Steps)
0

The core economic tenet that people invest in future anticipated gains rather than now consumption is adhered to by the discounted cash flow model. The present ...

0
How to Make Journal Entries in Excel (with Easy Steps)
0

Every business industry is built on some investments and planning. In order to observe its growth of it, we like to have recorded every investment in the ...

0
[Fixed!] Table Border Not Showing in Print Preview (2 Solutions)
0

In order to decorate our data while working with Microsoft Excel, we often use tables. Normally, the data are organized in different rows and columns in a ...

0
How to Keep Gridlines When Copy and Paste in Excel (2 Ways)
0

Instead of writing the same thing again and again, we often use Copy and Paste command. It saves both time and hustle. In Microsoft Excel, we can copy the ...

0
How to Hide Columns Without Right Click in Excel (3 Ways)
0

In terms of using Microsoft Excel, we can keep unnecessary or confidential data hidden. We can even hide the entire data. While hiding the entire column or ...

0
How to Add a Comma Between City and State in Excel (6 Ways)
0

We like decorating our things, even in case of a dataset. Adding comma between city and state will help us to differentiate those two quite easily. It will ...

0
How to Add Double Quotes in Excel (5 Smart Ways)
0

We like to highlight the important part of our writings. We even like to highlight it with double quotes too. In terms of working in Excel, double quotes can ...

0
How to Save Image from Excel as JPG (4 Simple Ways)
0

In times of working with Microsoft Excel, we sometimes fall into the necessity of taking images. We can save the image from Excel in any format according to my ...

0
How to Print Full Page of Excel Sheet in A4 Size (5 Simple Ways)
0

Microsoft Excel is an amazing software which importance can’t be explained in words. It is very essential part of almost every institutions. To have the work ...

0
How to Change Accounting Format in Excel (4 Simple Ways)
0

There are a lot of variations in currencies. Throughout the whole wide world, every country maintains a fixed currency. Sometimes, we face the necessity of ...

0
How to Convert Text with Spaces to Number in Excel (4 Ways)
0

We often need values in number format to apply them in various formulas and do other stuff too. In that case, if they are in text format, we will face some ...

0
How to Create a Stacked Pareto Chart in Excel (2 Smart Ways)
0

In order to summarize values with bars and lines in descending order, it is best to use a Pareto Chart. It can visualize the dataset with elegance and ...

0
How to Perform Numbering in One Cell in Excel (3 Smart Ways)
0

Sometimes we need to organize a set of data in a single cell to decorate our data. Numbering in Excel in One cell may be a very effective skill to beautify and ...

0
How to Create Month to Month Comparison Chart in Excel
0

People like to keep their records for the future. In business, it is a must to keep records and make a comparison to find out the business growth. It could be ...

0
How to Make Doughnut Chart with Total in Middle in Excel
0

Doughnut Chart is an amazing feature in Excel. It helps to visualize any statistical difference quite magnificently. We can also add the total value in the ...

Browsing All Comments By: Naimul Hasan Arif
  1. Reply
    Naimul Hasan Arif Jul 19, 2022 at 3:59 PM

    Hello MARIA, thanks for the comment and sorry for my late reply.
    In the LOOKUP function, the first argument is Lookup_value. I have typed 2 just to signify the NUMBER format. You can type any number. It will work just fine.

  2. Reply
    Naimul Hasan Arif Jul 19, 2022 at 1:12 PM

    Sorry DIEGO for my late response.
    There needs to make some changes in the formula in case of finding the second last non blank cell.
    I have used the following formula using LOOKUP function in cells D5 to D15 that is the chemistry marks in the dataset to find the second last non-blank cell.
    =LOOKUP(2,1/((D5:D15<>D15)*(D5:D15<>“”)),D5:D15)

    My dataset is given below:

    Second Last Non Blank Value

    Name Physics Chemistry
    Green 164 110 (D5)
    Jack 185 165
    Joey 178 132
    Mark 183 137
    Austin 165 112
    Marvin 173 119
    Mason 186 170
    Mount 170
    Martin 177 160
    Freeman 164
    Federer 163 111 (D15)

    Second Last Non Blank Value 160

    For me it worked perfectly. I hope it will work the same way for you too.

ExcelDemy
Logo