| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find value every time it appears and display cell above
I have a workbook, where on Sheet 1 there is data from B5:E (the number of
rows may be different on different workbooks). The word 'Status' appears numerous times within Column B. I would like to have a formula on Sheet 2 that looks for every instance of the word 'Status' and lists the value of the cell immediately above it. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW? Find and display the last cell in a column with a value 0 | Excel Discussion (Misc queries) | |||
| display and count the number of times a value appears | Excel Worksheet Functions | |||
| How do I find how often a number appears within a worksheet | Excel Discussion (Misc queries) | |||
| trying to find how to display worksheet name in cell | Excel Discussion (Misc queries) | |||
| Text data appears as 0 in my Pivot table - how do I display as tex | Excel Worksheet Functions | |||
Threaded Mode
