| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Analyzing non numerical data in an excel spread sheet
Can i use excel to analyze non numerical data in a spread sheet?
I want to use functions to work out operator results using two or more criteria based on daily results. is this possible? colum one is date collum 2 is ref word for his result which has 4 different variables collum 3 is operater but the operators initial will appear on more than one occasion on a set date with different results each time. what i want to do is look up the date, the operator and the number of times each variable appears for that operator? how is this possible |
|
#2
|
|||
|
|||
|
You've got a couple of responses at your first post
-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "luckyou_854" wrote: Can i use excel to analyze non numerical data in a spread sheet? I want to use functions to work out operator results using two or more criteria based on daily results. is this possible? colum one is date collum 2 is ref word for his result which has 4 different variables collum 3 is operater but the operators initial will appear on more than one occasion on a set date with different results each time. what i want to do is look up the date, the operator and the number of times each variable appears for that operator? how is this possible |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I export excel spread sheet to my Palm T3? | Excel Discussion (Misc queries) | |||
| Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions | |||
| Getting specific data from a word document into an excel sheet | Excel Worksheet Functions | |||
| How do I get rid of spare lines in an excel spread sheet? | Excel Worksheet Functions | |||
| Automatioc spill over data to a new Excel sheet from Xml source? | Excel Discussion (Misc queries) | |||
Linear Mode
