| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find previous row for an item
Hi,
I'm looking for a method to find the previous row for an item, eg: ! A ! B -----+-----+------------------ 1 ! 0 ! Kurt 2 ! 0 ! Jan 3 ! 1 ! Kurt 4 ! 0 ! Peter 5 ! 2 ! Jan 6 ! 3 ! Kurt 7 ! 4 ! Peter etc Is this possible with a formule? Ifnot can i write a macro to perform this operation? thx Hedwig |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the Find tool in EXCEL | Excel Worksheet Functions | |||
| How do I find data from a list (or table) and insert it in a row? | Excel Discussion (Misc queries) | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Threaded Mode
