Range or similar formula?

BT690

New Member
Joined
May 24, 2013
Messages
13
Hi

I have a spread sheet with a couple of thousand cells of decimal numbers between two values of 0 & 10. I want to use some type of formula that will put them into five ranges eg "0> & <2"=1, ">2 & <4" =2 etc. What is the best formula to apply in this instance please.

Thanks

BT
 
Last edited:

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

thespardian

Board Regular
Joined
Aug 31, 2012
Messages
53
Office Version
2016, 2013
Platform
Windows
Please try this.
=INDEX({1,2,3,4,5,6},MATCH(A1,{0,2,4,6,8,10},1))

just change the cell reference accordingly
 

Watch MrExcel Video

Forum statistics

Threads
1,099,869
Messages
5,471,252
Members
406,750
Latest member
Becky24

This Week's Hot Topics

Top