Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to assign companies to one of four different numbers depending on
where they fall in the alphabet, for example I need to assign a company "care homes ltd" as 01. Any ideas on the formula? 01 A GR 02 GS SA 03 SB THEC 04 THED Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
assigning numbers to text and count them | Excel Discussion (Misc queries) | |||
Assigning a point value to a range of numbers | Excel Discussion (Misc queries) | |||
Assigning a value to a set of numbers | Excel Worksheet Functions | |||
Assigning numbers to names | Excel Discussion (Misc queries) | |||
assigning numbers to text entries | Excel Discussion (Misc queries) |