Data Categorization

[cyberuser]

Hello !

I'm trying to categorize a column showing "seconds" based on range that they fall.
For Example :

Please Login or Register  to view this content.

Basically it would have 5 categories.
From 0 to 5
From 5 to 10
From 10 to 50
From 50 to 100
Above 100


How can i setup column B to automatically populate the category ?

[Tony Valko]

From 0 to 5
From 5 to 10
From 10 to 50
From 50 to 100
Above 100

You need to better define the categories.

If the duration was 5 which category would that fall into?

Would it be from 0 to 5 or from 5 to 10?

[cyberuser]

Understand, thanks for the heads up... in this case..
From 0 to 4.99
From 5 to 9.99
From 10 to 49.99
From 50 to 99.99
Above 100

thanks for your help !

[Tony Valko]

Create the table in D1:E6.

Data Range

	A	B	C	D	E
1	DURATION	CATEGORY	------	DURATION	CATEGORY
2	0.4	From 0 to 4.99		0	From 0 to 4.99
3	0.9	From 0 to 4.99		5	From 5 to 9.99
4	3.89	From 0 to 4.99		10	From 10 to 49.99
5	0.3	From 0 to 4.99		50	From 50 to 99.99
6	200.20	Above 100		100	Above 100
7	42.10	From 10 to 49.99

Then, this formula entered in B2 and copied down:

=LOOKUP(A2,D$2:E$6)

[cyberuser]

i think i found a similar way.... but with using the aux table into the formula

would be somthing like this, just adjusting the text now...
=LOOKUP(l2,{0;3;10;30;60},{"From 0 to 3 Sec";"From 3 to 10 Sec";"From 10 to 30 Sec";"From 30 to 60 Sec";"Above 60 Sec"})

thanks a lot for your attention and help !!!

[Tony Valko]

Yeah, that'll work.

Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.