| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and return a value
I have a spreadsheet consisting of 6 worksheets named for each manager. On
the 7th worksheet, I have to return the rightmost value of a row which is greater than 0 (cells generally have 3 or 4 digit numbers, followed by any number of cells with "0" in them). The problem is that the data is never consistently in the same row and rows are never consistently the same length, but the data I need from every worksheet is in a row where the heading is "No. of People". ie. worksheet "John" No. of people 123 234 345 456 256 0 0 0 0 How do I return the value of 256 to a cell on the 7th worksheet? Thanks, Mrs. Robinson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Return | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Find a value, return the value of another cell | Excel Discussion (Misc queries) | |||
| find & return value | Excel Discussion (Misc queries) | |||
| find formula and return value | Excel Discussion (Misc queries) | |||
Threaded Mode
