Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary of list with multi length numbers
Hi,
I have a list with numbers. 9411007816009306000 9411007816009306001 9411007816009306002 9411007816009306003 9411007816009306004 000123556790 000123556792 000123556796 000123556797 000123556794 000123556799 09459001890 09449001799 09469001790 09455001890 09456001890 ----------------------------------------- Result: Head Count 816 4 0944 1 0945 3 0946 1 For any 19 digits I would like to count 816 using mid xl function. For any 12 digits no count. For any 11 digits I would like to count 0945, 0944, 0946 using left xl function. Thx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi YTD Summary | Excel Worksheet Functions | |||
Summary of data - multi sheets | Excel Worksheet Functions | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Extract values from a multi-select multi-column list-box | Excel Programming |