| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel, two text fields equal the number 1 per occurance
I am in need of help with an excel function. Here is some sample data.
Don coffee James coffee Joe tea Sally coffee Don tea Sally tea Sally tea Don coffee I need these two columns to be conditional in that If Don drinks tea that equals one occurance. The data I need would show that Don drinks tea "1", Don drinks coffee "2". Sally drinks tea "2", Sally drinks coffee "1". Can anyone please help me? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make text in a cell equal a number | Excel Discussion (Misc queries) | |||
| Is there formulas which set text to equal a number? | Excel Worksheet Functions | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| How do I get text to equal a number so I can sum a column? | Excel Discussion (Misc queries) | |||
| First occurance greater than or equal to a specified value | Excel Worksheet Functions | |||
Threaded Mode
