M
Mildred
have a spreadsheet with several columns -- some data, some dates.
Does anyone know how I can create a formula to 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.
Does anyone know how I can create a formula to 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.