| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help filtering for unique records - urgent :)
I can't find my org post, so reposting..sorry.
I have a worksheet that has multiple columns, with multiple dates.. Acct Nu Assign Dt Date 1 Date 2 Date 3 Date 4 Date 5 1234567 10/10/09 10/13/09 10/16/09 10/19/09 10/22/09 10/25/09 2345678 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 10/30/09 3456789 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 4567890 10/11/09 10/14/09 10/17/09 10/20/09 10/23/09 10/26/09 5678901 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 6789012 10/17/09 10/20/09 10/23/09 10/26/09 10/29/09 10/12/09 I need to filter for all acct #s with a follow up date of 10/24/09 (or whatever date I need). I have tried all versions of advanced filter, but it does not allow you to search by multiople date across columns. Please help! -- crazidazi3 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help filtering for unique records - urgent :)
--In the next available column say J. Enter the query date in cell J1
--In J2 enter the below formula and copy/drag down =IF(COUNTIF(B2:I2,$J$1),"Found","") --Now filter by that column If this post helps click Yes --------------- Jacob Skaria "crazidazi3" wrote: I can't find my org post, so reposting..sorry. I have a worksheet that has multiple columns, with multiple dates.. Acct Nu Assign Dt Date 1 Date 2 Date 3 Date 4 Date 5 1234567 10/10/09 10/13/09 10/16/09 10/19/09 10/22/09 10/25/09 2345678 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 10/30/09 3456789 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 4567890 10/11/09 10/14/09 10/17/09 10/20/09 10/23/09 10/26/09 5678901 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 6789012 10/17/09 10/20/09 10/23/09 10/26/09 10/29/09 10/12/09 I need to filter for all acct #s with a follow up date of 10/24/09 (or whatever date I need). I have tried all versions of advanced filter, but it does not allow you to search by multiople date across columns. Please help! -- crazidazi3 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help filtering for unique records - urgent :)
Let's say the date you want to find is in cell A1. Create an additional
helper column with formula: =ISNUMBER(MATCH($A$1,C2:G2,0)) (where C2:G2 contains the dates you want to check) copied down you can then filter on your helper column for a value of TRUE. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "crazidazi3" wrote: I can't find my org post, so reposting..sorry. I have a worksheet that has multiple columns, with multiple dates.. Acct Nu Assign Dt Date 1 Date 2 Date 3 Date 4 Date 5 1234567 10/10/09 10/13/09 10/16/09 10/19/09 10/22/09 10/25/09 2345678 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 10/30/09 3456789 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 4567890 10/11/09 10/14/09 10/17/09 10/20/09 10/23/09 10/26/09 5678901 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 6789012 10/17/09 10/20/09 10/23/09 10/26/09 10/29/09 10/12/09 I need to filter for all acct #s with a follow up date of 10/24/09 (or whatever date I need). I have tried all versions of advanced filter, but it does not allow you to search by multiople date across columns. Please help! -- crazidazi3 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help filtering for unique records - urgent :)
Hi,
Assume that your data is in range B4:H10 (including the header row). In A14, type the date. In cell B14, enter =COUNTIF(C5:H5,$A$14)0. In cell B13, type condition1 and in B17, type Acct Nu (the same heading as in the source range). Now go to DataFilterAdvanced FilterCopy to another location. In the list range, select A4:H10. In the criteria range, select B13:B14. In the copy to box, select B17. Click on OK. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "crazidazi3" wrote in message ... I can't find my org post, so reposting..sorry. I have a worksheet that has multiple columns, with multiple dates.. Acct Nu Assign Dt Date 1 Date 2 Date 3 Date 4 Date 5 1234567 10/10/09 10/13/09 10/16/09 10/19/09 10/22/09 10/25/09 2345678 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 10/30/09 3456789 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 4567890 10/11/09 10/14/09 10/17/09 10/20/09 10/23/09 10/26/09 5678901 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 6789012 10/17/09 10/20/09 10/23/09 10/26/09 10/29/09 10/12/09 I need to filter for all acct #s with a follow up date of 10/24/09 (or whatever date I need). I have tried all versions of advanced filter, but it does not allow you to search by multiople date across columns. Please help! -- crazidazi3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering for Unique Records | Excel Discussion (Misc queries) | |||
| Flitering for unique records in Col B based on filtering in Col A | Excel Discussion (Misc queries) | |||
| filtering unique records ajit | Excel Discussion (Misc queries) | |||
| Filtering for Unique Records with multiple-column criteria | Excel Discussion (Misc queries) | |||
| filtering for unique records | Excel Discussion (Misc queries) | |||
Hybrid Mode
