| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
find dates between in excel
hi anne,
by using filters u could do this.You can find the filter option in DataFilterAuto Filter. By clicking this you could find dropdowns come in the first row.There u cold go for custom where u could give two dates and thus could filter the range of datas to clear the filter click on the dropdown and give all values. Regards Arun "MDI Anne" wrote: I have 2 columns of data: one is name, the other is dates. BOB 5/1/2007 STEVE 4/19/2007 JOHN 3/22/2007 MARY 7/21/2006 KATHY 5/4/2007 BOB 10/7/2006 STEVE 5/22/2007 MARY 5/14/2007 MARY 3/7/2007 MARY 5/30/2007 KATHY 1/5/2007 JOHN 5/15/2007 BOB 5/25/2007 STEVE 5/13/2007 BOB 5/1/2007 STEVE 4/19/2007 JOHN 3/22/2007 MARY 7/21/2006 KATHY 5/4/2007 BOB 10/7/2006 STEVE 5/22/2007 MARY 5/14/2007 MARY 5/30/2007 KATHY 1/5/2007 JOHN 5/15/2007 BOB 5/25/2007 STEVE 5/13/2007 I'd like to know how many times each name shows up in the month of May (or whatever month I'm looking for). So, if I need a "findbetween" or some other formula, I would love some help. Thanks all, in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find future dates | Excel Discussion (Misc queries) | |||
| How do I find the earliest dates in a range of dates? | Excel Worksheet Functions | |||
| Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
| to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
| Find a "date" in a column of dates in Excel 2000 | Excel Worksheet Functions | |||
Threaded Mode
