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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced function to remove specific rows
How are your weeks defined? Are they always 7 days, do they always begin on
Sunday (or Monday), do you use ISO week numbers, etc. For example, July 2006 began on a Saturday. Is that a 1-day Week 1? I can almost certainly write this function for you, but I must know how to figure out which days are in Week 1 vs. Week2 for any month. Hutch "nemadrias" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced function to remove specific rows
Tom -
Thanks for your reply, I was actually able to figure this out. I simply assigned an integer to each week of each month, and then compared that to an integer assigned to the current month. If x < y kind of a thing, and it seems to work fine. Thanks anyways, Steve Tom Hutchins wrote: How are your weeks defined? Are they always 7 days, do they always begin on Sunday (or Monday), do you use ISO week numbers, etc. For example, July 2006 began on a Saturday. Is that a 1-day Week 1? I can almost certainly write this function for you, but I must know how to figure out which days are in Week 1 vs. Week2 for any month. Hutch "nemadrias" wrote: 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 |
Reply |
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) |