Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hi all,
What should be the syntax if I have a list of first letters of my entries (looking something like A A B C C C C E J P P P S S T V and I wanted to programmatically assign a number to each entry on this list, restaring the numbering at each letter (e.g., first A would appear as A1, second as A2, first C as C1, fifth C as C5, etc.)? I know how to compile the resulting letter with its corresponding numeral, I'm just not sure how/if to use the MATCH function to count the compounding occurence of each letter on the list. Thank you in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I assign a letter value to a range of data? | Excel Discussion (Misc queries) | |||
How do i set up a list that sorts as Number/letter/number in orde | Excel Discussion (Misc queries) | |||
List of Dates- Assign Week Number?? | Excel Discussion (Misc queries) | |||
How can I assign a number value to a letter grade in Excel? | Excel Worksheet Functions | |||
compounding of a number in excel? | Excel Worksheet Functions |