Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced function to remove specific rows
Hi -
I am looking for a function (or at least a push in the right direction) to help me achieve the following. I have a spreadsheet which has several columns of data. The three columns I care about all involve dates, but they are not stored as dates, but as strings in this format: Jun Wk 1 Jun Wk 2 Jul Wk 1 Jul Wk 2 July Wk 5 Aug Wk 1 Etc... What I need to be able to do is (IF the "date" in the column, ie Jun Wk 1, is before today's date, delete that row) so that today the column would read: July Wk 2 (and the following dates) since that would be the most recent date. Can anyone help with this? Thanks in advance, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Sum function which ignores hidden rows | Excel Worksheet Functions | |||
How do you ignore hidden rows in a countif() function | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
How do i keep the colors applied to the specific rows when sor | Excel Discussion (Misc queries) |