Group list of data into 3 groups
Group list of data into 3 groups
(OP)
I have a list of data I'd like to group into 3 groups, top third, middle third and lower third. Can someone give me some help on how to do this?
Thanks...
Thanks...
--
Fighter Pilot
Manufacturing Engineer





RE: Group list of data into 3 groups
------------------------------------------
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail."
Wm. Phelps Eno, ca. 1928
RE: Group list of data into 3 groups
I assume you know how to sort if that is desired?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Group list of data into 3 groups
in B1 enter a formula like this:
=IF(A1<(MAX(A:A)*1/3),"Bottom",IF(A1>(MAX(A:A)*(2/3)),"Top","Middle"))
Then copy this down the B column for all your data. The B Column will contain "Bottom", "Middle", or "Top". You can then sort (<Data><Sort>) the spreadsheet by Column B.
I hope that helps.
RE: Group list of data into 3 groups
--
Fighter Pilot
Manufacturing Engineer