Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function to search a row of data.
Greetings
I am looking for a formula that will search a row of data until it finds the last data in the range i.e. a non-blank cell. I have a report that is generated from data that is updated monthly into a worksheet however, I want the report to update automatically after the new-data is entered each month. Any ideas? |
#2
|
|||
|
|||
One way:
=LOOKUP(2,1/(1-ISBLANK(A1:Z1)),A1:Z1) "cwade23" wrote in message ... Greetings I am looking for a formula that will search a row of data until it finds the last data in the range i.e. a non-blank cell. I have a report that is generated from data that is updated monthly into a worksheet however, I want the report to update automatically after the new-data is entered each month. Any ideas? |
#3
|
|||
|
|||
Thanks for this however, the data is on a different worksheet then the one
where this formula resides. Where do I reference "sheet2"? "RagDyer" wrote: One way: =LOOKUP(2,1/(1-ISBLANK(A1:Z1)),A1:Z1) "cwade23" wrote in message ... Greetings I am looking for a formula that will search a row of data until it finds the last data in the range i.e. a non-blank cell. I have a report that is generated from data that is updated monthly into a worksheet however, I want the report to update automatically after the new-data is entered each month. Any ideas? |
#4
|
|||
|
|||
Try this:
=LOOKUP(2,1/(1-ISBLANK(Sheet2!A1:Z1)),Sheet2!A1:Z1) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "cwade23" wrote in message ... Thanks for this however, the data is on a different worksheet then the one where this formula resides. Where do I reference "sheet2"? "RagDyer" wrote: One way: =LOOKUP(2,1/(1-ISBLANK(A1:Z1)),A1:Z1) "cwade23" wrote in message ... Greetings I am looking for a formula that will search a row of data until it finds the last data in the range i.e. a non-blank cell. I have a report that is generated from data that is updated monthly into a worksheet however, I want the report to update automatically after the new-data is entered each month. Any ideas? |
#5
|
|||
|
|||
This works perfect!
Thanks for your help, you are awesome! "RagDyer" wrote: Try this: =LOOKUP(2,1/(1-ISBLANK(Sheet2!A1:Z1)),Sheet2!A1:Z1) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "cwade23" wrote in message ... Thanks for this however, the data is on a different worksheet then the one where this formula resides. Where do I reference "sheet2"? "RagDyer" wrote: One way: =LOOKUP(2,1/(1-ISBLANK(A1:Z1)),A1:Z1) "cwade23" wrote in message ... Greetings I am looking for a formula that will search a row of data until it finds the last data in the range i.e. a non-blank cell. I have a report that is generated from data that is updated monthly into a worksheet however, I want the report to update automatically after the new-data is entered each month. Any ideas? |
#6
|
|||
|
|||
cwade23 wrote:
Greetings I am looking for a formula that will search a row of data until it finds the last data in the range i.e. a non-blank cell. I have a report that is generated from data that is updated monthly into a worksheet however, I want the report to update automatically after the new-data is entered each month. Any ideas? What kind of data - numbers, dates, times, or just text? |
#7
|
|||
|
|||
Appreciate the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "cwade23" wrote in message ... This works perfect! Thanks for your help, you are awesome! "RagDyer" wrote: Try this: =LOOKUP(2,1/(1-ISBLANK(Sheet2!A1:Z1)),Sheet2!A1:Z1) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "cwade23" wrote in message ... Thanks for this however, the data is on a different worksheet then the one where this formula resides. Where do I reference "sheet2"? "RagDyer" wrote: One way: =LOOKUP(2,1/(1-ISBLANK(A1:Z1)),A1:Z1) "cwade23" wrote in message ... Greetings I am looking for a formula that will search a row of data until it finds the last data in the range i.e. a non-blank cell. I have a report that is generated from data that is updated monthly into a worksheet however, I want the report to update automatically after the new-data is entered each month. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a search function | Excel Worksheet Functions | |||
Using INDIRECT function to specify source data | Charts and Charting in Excel | |||
Search function | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) |