Search results

Hi. Thanks to everyone who responded! I ended up using the formula Somendra provided as it seemed to be easiest to apply. It works great. Thanks again! Glen

I would like to create a formula in one cell that would look at a defined column area in the worksheet (only one column with multiple rows) and display the last entry on the row within that column regardless of whether the number is greater or less than the other numbers in that column. Thanks...

Good read. Thanks shrivallabha!

Excellent! Works great! For my information, what do the ZZZZZZ's represent? And, THANK YOU!

Hello. Is there a formula I can use in a given cell that will evaluate a column I specify and look from top to bottom to return the last (bottom) value in the column? Thanks!

Thanks shrivallabha! Good to know. Copied them and pasted them in the spreadsheet just to try them out and they both worked perfectly.

Hi everyone. I'm happy to share what I found that worked for me. First a little explanation on what I'm doing. This is a budget spreadsheet. Each column represents a pay period - two per month. As time goes on and I move from pay period to pay period, I move the check book balance figure to...

Thanks everyone. With your help I figured it out and it is working like a charm! Your help has been wonderful!

Thanks Sajan! I copied and pasted your formula above and changed Sheet1 to the actual name of the sheet. It looks like this: =LOOKUP(9999, IF(Budget!A46:Z46+0>0, Budget!A46:Z46+0)) But, it returns: #VALUE! Don't know why.

Hi, thanks for the replies. If I use the lookup formula, how do I reverence going to sheet 1 and looking in a46:z46? Also, what I am looking for is a value >0. Thanks.

I have a row that spans several columns. In that row, there will only be one numerical amount in one of the multiple columns. On another sheet (sheet 2), how can I create a formula that spans the row of columns (on sheet 1) to find and display the single numerical amount regardless of which...