Excel Formula To Find The Last Data In Range

Microsoft Excel 97 upgrade
February 1, 2011 at 08:46:41
Specs: Windows XP
Hello,

I am looking for a formula that will allow me to look across 4 tabs (INV,INV2,INV3,INV4) within the same cell range (D74:X74) and simply return the last numerical value within the range. These cells will be populated every day, but I simply want it to return the last cell with a numerical value (i.e. one that isn't blank). I have tried LOOKUP, but can't get the syntax right for it to look across multiple tabs. Any help would be greatly appreciated. Thanks in advance.


See More: Excel Formula To Find The Last Data In Range

Report •


#1
February 1, 2011 at 09:45:30
I'm not quite sure what you are asking for.

Are you asking for the value in the last cell in each sheet or the last value across all sheets?

In other words, if one of the sheets has a value in, for example, T74, all the other sheets will have values in S74 and below and you only want the value from the sheet with something in T74.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 3, 2011 at 16:30:52
Hello,

I am looking for the last cell across all sheets. The sheets are all the same format, but contain numerical entries according to date, so as time goes by, more and more entries are necessary. I only want say, T34, even though T1-T33 contain entries. Also, the entries are in no order (lowest to highest, etc). I only want the last numerical value across ALL sheets. Thank you in advance.


Report •

#3
February 3, 2011 at 21:37:16
Maybe it's me, but I'm still not sure if you want 4 values (one from each sheet) or just 1.

In your OP you asked for the last cell in the range D74:X74, which is a horizontal range in the same row, but now you are asking for the last value in T1:T33, which is a vertical range in column T.

I, for one, am confused as to what you want.

Perhaps you should post some examples of your data and the desired output based on that data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question