|
|
|
|
New Member
|
|
Jun 23, 2006, 02:49 AM
|
|
Several Criteria Classification on Excel
Quick question...
I'd like to do the following:
If the value in Column A is between 1-50 or 200-250 or 400-450, or 600-650 etc etc I want it to be classified as "people" in Column B. If it does not fall in those number ranges, I want it to be classified as "monkey" in Column B.
This seems straight forward enough to me, but I can't figure out how to use the IF function (or anything else... ) to get it to work.
Any help would be greatly appreciated.
Emily
|
|
|
Computer Expert and Renaissance Man
|
|
Jun 23, 2006, 05:59 AM
|
|
Probably best to use a VLookup. Create a table like:
1... People
51... Monkey
200... People
251... Monkey
etc.
Then use a VLookup in Column B
|
|
|
Senior Member
|
|
Jun 23, 2006, 08:24 AM
|
|
A1 = value, doesn't matter how many digits
B1 = convert this value to text, right most 2 digits
C1 = convert B1 back to a number
D1 = Your answer
A1 = 1021
B1 = 21 =Right(A1,2)
C1 = 21 =Value(B1)
D1 = People =If(C1>50.01,"Monkey","People")
Hope this helps
Colin
|
|
|
Computer Expert and Renaissance Man
|
|
Jun 23, 2006, 08:48 AM
|
|
I see what Colin is doing, but he's making an assumption that may not be valid. For example is the value is 160, his solution will still return Monkey. Using a lookup table allows you to fine tune the ranges.
|
|
|
Senior Member
|
|
Jun 26, 2006, 12:36 AM
|
|
Hi Scott,
Is that not what is required?
Col
|
|
|
Computer Expert and Renaissance Man
|
|
Jun 26, 2006, 06:09 AM
|
|
Originally Posted by colbtech
Hi Scott,
Is that not what is required?
Col
Not from my read. Look at the ranges. Its not consistently distributed.
|
|
|
Senior Member
|
|
Jun 26, 2006, 07:26 AM
|
|
Got it now. That will teach me to read the question a little closer!
|
|
|
Computer Expert and Renaissance Man
|
|
Jun 26, 2006, 07:56 AM
|
|
Originally Posted by colbtech
Got it now. That will teach me to read the question a little closer!
Your solution was a neat idea, if the pattern was more consistent.
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Fruit classification
[ 3 Answers ]
I would like to understand how works the classification of fruits in stone fruit, nut and all these other kinds of fruits. What are the criterions which make i.e. the litchi a nut an the walnut a stone fruit ? If somebody could help me to understand the hole system (maybe the are explaining texts...
Racial Classification
[ 4 Answers ]
Who exactly are considered as "white" people? Is it all of Europe, inclluding Armenia and Georgia? Or just Northern Europeans? Please help, I am writing a report about this.
Counting Cells If several criteria are true
[ 1 Answers ]
Another question.
I'd like to count the number of cells in column C that have "incorrect" in them, if the corresponding cells in column A have "people" in it, and column B has "intact" in it.
So if A = people and B = intact, count all C that = incorrect.
Thanks!
Excel: 2 criteria - 1 answer
[ 9 Answers ]
GMorning Ladies/Gentlemen!
Here's a small question:
Is it possible to have two criteria which are filled in by a user, and in a third box an answer appears? I have put an example attached in zip format.
Many thanks,
Srecak
View more questions
Search
|