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? |
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? |
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? |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com