Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following situation:
10000 11000 12000 13000 11100 11200 11300 12100 12200 12300 20000 21000 22000 23000 21100 21200 21300 What i need is formula to scroll through this records and count: A) Number of records starting with 1 (10000) B) Number of record starting with two digits, and first one is 1, and rest are zero (11000,12000,13000) C) Number of record starting with two digits, and first one is 2, and rest are zero (21000,22000,23000) D) Number of record starting with three digits, and first one is 1, and rest are zero (12100, 122000, 123000) E) Number of record starting with three digits, and first one is 2, and rest are zero (21100, 212000, 213000) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting unique records | Excel Worksheet Functions | |||
Counting records within a month | New Users to Excel | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions |