Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
I have a spreadsheet with several columns -- some data, some dates.
Does anyone know how I can do the equivalent of filtering on three different columns with a different date for each column filtered? For example I have four columns of information but only want to extract a certain criteria where as Date A is greater than a specific date, Date B = another date and Date C = yet another date. Date A Date B Date C Data 2/12/2001 2/23/2006 3/31/2006 Apples 2/23/2006 1/1/1900 Pears 3/16/2004 2/23/2006 3/31/2006 Peaches 6/15/2005 2/23/2006 6/30/2006 Grapes For example, I'd like to be able to extract all records where Date A 1/1/1900 and Date B = 2/23/2006, and Date C = 3/31/2006. I have Excel 2003 Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
Have a look at the Data Filter AutoFilter feature.......you will probably
need the "custom" selection......... hth Vaya con Dios, Chuck, CABGx3 "Mildred" wrote: I have a spreadsheet with several columns -- some data, some dates. Does anyone know how I can do the equivalent of filtering on three different columns with a different date for each column filtered? For example I have four columns of information but only want to extract a certain criteria where as Date A is greater than a specific date, Date B = another date and Date C = yet another date. Date A Date B Date C Data 2/12/2001 2/23/2006 3/31/2006 Apples 2/23/2006 1/1/1900 Pears 3/16/2004 2/23/2006 3/31/2006 Peaches 6/15/2005 2/23/2006 6/30/2006 Grapes For example, I'd like to be able to extract all records where Date A 1/1/1900 and Date B = 2/23/2006, and Date C = 3/31/2006. I have Excel 2003 Any help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
Actually, I intended to state that I would like to be able to do this
using a formula. I know how to do it using Data, Filter. If any one can help I'd be most appreciative. Thanks, Mildred |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
Why can't you use the normal filter options? Set autofilter on for all
columns, then for Date A select Custom from the pull-down and choose greater than 1/1/1900 (are you sure you want this date? - it has the same value as 1), for Date B select 2/23/2006 from the pull-down and for Date C select 3/31/2006 from the pull-down - obviously, you can only select the latter two if there are any of these dates following the first filtering. Whatever is displayed now matches all three criteria. If you want to extract these records and copy them somewhere else, then highlight the displayed items, click <copy, then move to somewhere else (another sheet?) and press <enter - only the filtered records will be copied. Hope this helps. Pete |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
Ah! You must have been posting just before I did!
Pete |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
Check the answers you received in the excel group.
Please don't multi-post. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mildred" wrote in message ups.com... Actually, I intended to state that I would like to be able to do this using a formula. I know how to do it using Data, Filter. If any one can help I'd be most appreciative. Thanks, Mildred |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
Sorry. This was my very first post. Once I did it, I realized that I
was in the miscellaneous category and thought I'd get a better response if I went directly to Excel. Today is my first day navigating around this forum. But thanks for the feedback. Mildred |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract data based on critera from three columns
Hi Pete,
Thanks for the response. I am trying to automate this functionality rather than manually do it by filtering. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
extract data from a range of cells in rows or columns when a date. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |