Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I need a formula to count the number of times an Item is repeated in
consecutive days from a list. For example: A B C ******************* 1 * Date Item Repeated 2 * 1-jun Item1 1 3 * 1-jun Item2 1 4 * 2-jun Item1 2 5 * 2-jun Item3 1 6 * 3-jun Item1 3 7 * 3-jun Item3 2 8 * 3-jun Item4 1 ..... ... .. NOTES: - My list contains consecutive days including weekends. - Each Item is not repeated in the same day. - Each day, the number of Items appeared could be different. - My list is ordered by date from the older to the newest. Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding totals in a column, not counting repetitions in another col | Excel Discussion (Misc queries) | |||
consecutive | Excel Worksheet Functions | |||
Why do I get repetitions of characters in my cells? | Excel Discussion (Misc queries) | |||
consecutive numbering | Excel Discussion (Misc queries) | |||
consecutive numbers | Excel Worksheet Functions |