I am trying to bin my results so my groupings have lower granularity - going from a 1-10 scale to a 1-5 scale.
For example, any result 1 or 2 would be renamed to 1 in the next column, any result 3 or 4 would be renamed to 2 in the next column, ...
I have tried:
=lookup(F3{=10,=9,=8,=7,=6,=5,=4,=3,=2,=1},G3{5,5,4,4,3,3,2,2,1,1})
and get a formula parse error.
Can you help?
Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by vzhz via Recent Questions - Web Applications Stack Exchange
No comments:
Post a Comment