Grouping question

  • Thread starter Thread starter Lee Harris
  • Start date Start date
L

Lee Harris

What is the most efficient way to achieve this in excel

given a list of numbers in col A from 1 to 70 (assume no repeats), I want
column B to reflect a group number such that there are 10 equal groups of 7

so any rank from 1 to 7 would have "1" in Col B, anything from 8 to 14 would
have "2" etc

The formulas I used are messy and sometimes don't work due to rounding and
boundary problems

t.i.a
 
I'm sure there are a million ways to do it, but the shortest I can think of
is
=ROUNDUP(A1/7,0)

ken
 
kcc said:
I'm sure there are a million ways to do it, but the shortest I can think of
is
=ROUNDUP(A1/7,0)

ken
Click to expand...

thanks, that was it - easy eh!
I use loads of advanced formulas in excel but I can't believe I never saw
roundup as opposed to just round before
doh!
 
Back
Top