| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Last Value
I have many entries describing sales events, and one of the columns in every
entry is quarter. I'd like to find where one quarter starts and where one ends without doing any filtering or deleting. For example, i have ___K___ 1|Q1 2|Q1 3|Q1 4|Q1 5|Q1 6|Q2 7|Q2 I'd like to use a code that, in this example, would return row 5 as the last Q1 value. Is this possible? thanks in advance comparini3000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
| find and delete text, find a 10-digit number and put it in a textbox | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Threaded Mode
