Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting reoccuring dates.
Hi,
Hope this isn't a double post, previous try ended in "server too busy". I have an Excelsheet with columns "ReceivingDate", "Type" and "Customer" (and some other columns that don't matter). I need three lists that show me every date that's in "RecevingDate" with the number of times it showed up in the list in the next column. Same with "Type" and "Customer". So endresult should look like this: Column1.....Column2.....Column3.....Column4.....Co lumn5.....etc. 6/13/2006...2...............ModelX.......4............. ...Hainz.........etc 4/28/2006...1...............ModelY.......2......etc. etc. Column 3 and 4 and Column 5 and 6 can be on a different Tab because I will copy and paste the results in another report anyway. Thanks, R-P |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Dates | Excel Worksheet Functions | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Counting Dates #2 | Excel Discussion (Misc queries) | |||
Counting Dates | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |