Data in columns. Which formula will identify last completed colu.

P

Piet

If I have monthly data, from left to right in columns, and I need to extraxt
the LATEST months data to a particular cell (I.e. current you only have May
2009 data followed by 7 columns with nothing in it - which formula should I
use.
 
M

Mike H

Hi,

This returns the value frim the last filled cell in the range A1 - L1

=LOOKUP(2,1/(A1:L1<>""),A1:L1)

Mike
 
F

fake_be

Hi,

I would use the HLOOKUP formula.

Type the month you need in A1

=HLOOKUP(A1;select the series;type the number of the row you want)

To search the info type the month (or something else) in the A1.

Good luck

Type the following formule in the
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate last 4 data points in a column (with sometimes blank rows) 7
Formula to choose from the last column of a given row 2
YTD SUMIF based on current date 3
identify which years are contained within a range of dates 2
Two columns : Continuous two columns vs Parallel two Column 1
Date 2
Unhide column difficulty 3
Need formulas for searching for a value in a table and returning row/column name 7

Top