software

I recently have recently started using Excell to keep track of things in
my side job as a video game reviewer, and have encountered a problem. I
need to find a way for Excel to sort through a list of 60 (the numbers
are not 1-60, there is just 60 total numbers) numbers and assign a name
to them in groups of 12. The numbers are not in order. So in other
words, lets say the list was literally the numbers 1-60; I want it to
look for any numbers that fall within 1-12 and name them quot;Group Aquot;,
look for any numbers that fall within 13-24 and name them quot;Group Bquot;,
and so on and so forth. Any Help would be greatly appreciated! Thank
you!--
cpontrelli
------------------------------------------------------------------------
cpontrelli's Profile: www.excelforum.com/member.php...oamp;userid=34056
View this thread: www.excelforum.com/showthread...hreadid=538203This formula in the cell next to a number cell would do it:
=IF(A1lt;=12,quot;Group Aquot;,quot;Group Bquot;)
....where A1 contains a number from 1-24.Try this:

=IF(RANK(A1,$A$1:$A$60,1)lt;=12,quot;Group Aquot;,IF(RANK(A1,$A$1:$A$60,1)lt;=24,quot;Group
Bquot;,IF(RANK(A1,$A$1:$A$60,1)lt;=36,quot;Group Cquot;,IF(RANK(A1,$A$1:$A$60,1)lt;=48,quot;Group
Dquot;,quot;Group Equot;))))

HTH,
Elkarquot;cpontrelliquot; wrote:

gt;
gt; I recently have recently started using Excell to keep track of things in
gt; my side job as a video game reviewer, and have encountered a problem. I
gt; need to find a way for Excel to sort through a list of 60 (the numbers
gt; are not 1-60, there is just 60 total numbers) numbers and assign a name
gt; to them in groups of 12. The numbers are not in order. So in other
gt; words, lets say the list was literally the numbers 1-60; I want it to
gt; look for any numbers that fall within 1-12 and name them quot;Group Aquot;,
gt; look for any numbers that fall within 13-24 and name them quot;Group Bquot;,
gt; and so on and so forth. Any Help would be greatly appreciated! Thank
gt; you!
gt;
gt;
gt; --
gt; cpontrelli
gt; ------------------------------------------------------------------------
gt; cpontrelli's Profile: www.excelforum.com/member.php...oamp;userid=34056
gt; View this thread: www.excelforum.com/showthread...hreadid=538203
gt;
gt;