**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have data that I need to categorize for example
If the number falls between 1 through 9, I want to put it in column A
10 through 20, column B, etc.
Can you give me the formula

Solved by X. U. in 26 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
29/08/2018 - 03:36

Hii

Excelchat Expert
29/08/2018 - 03:37

can you build a quick example

Excelchat Expert
29/08/2018 - 03:37

so that i understand better

Excelchat Expert
29/08/2018 - 03:37

Hi you there

Excelchat Expert
29/08/2018 - 03:38

based on you description

Excelchat Expert
29/08/2018 - 03:39

you have data in column A and based on its values you want to move it to column a,b,c and so on

Excelchat Expert
29/08/2018 - 03:39

is that right?

User
29/08/2018 - 03:39

Hi, I have data that falls into ranges. they want each range to be A,B,C, D, etc. if the number fall in the first range, say a number between 1 and 5, put that in a column named A,

Excelchat Expert
29/08/2018 - 03:40

1-5 or 1-9 we need to define the range 1st clearly

User
29/08/2018 - 03:40

second range B, third C, etc

Excelchat Expert
29/08/2018 - 03:41

will the range be 1-5,6-10 or 1-10,11-20

User
29/08/2018 - 03:42

A= 1 - 5

Excelchat Expert
29/08/2018 - 03:42

ok got it give me few min

Excelchat Expert
29/08/2018 - 03:42

i'll assume you have your data in Sheet 1 column A then will more them to corresponding column sin sheet 2

User
29/08/2018 - 03:42

A = 1 - 5, B = 6-10, C=11 - 15, D = 16 - 20

User
29/08/2018 - 03:44

or to over to other columns on the page

Excelchat Expert
29/08/2018 - 03:45

it would be the same formula you can use it where ever you want the new sheet would look nices

User
29/08/2018 - 03:45

ok, thanks

Excelchat Expert
29/08/2018 - 03:45

few min to work on the formula

Excelchat Expert
29/08/2018 - 03:51

[Uploaded an Excel file]

Excelchat Expert
29/08/2018 - 03:51

check sheet 2

Excelchat Expert
29/08/2018 - 03:52

please do check and let me know

User
29/08/2018 - 03:52

how do I get to sheet 2 isn't there usually a tab at bottom

Excelchat Expert
29/08/2018 - 03:53

the formula is dynamic if you change any values in A it will automatically adjust and at any time you can change the range by changing the values in row 1 and row 2 the lower and upper limit

Excelchat Expert
29/08/2018 - 03:53

yes there is

Excelchat Expert
29/08/2018 - 03:53

did you download the file i sent

Excelchat Expert
29/08/2018 - 03:53

[Uploaded an Excel file]

Excelchat Expert
29/08/2018 - 03:54

were you able to see sheet 2

Excelchat Expert
29/08/2018 - 03:55

you there

User
29/08/2018 - 03:55

not sure I understand it - can you explain

Excelchat Expert
29/08/2018 - 03:56

can you see sheet 2?

Excelchat Expert
29/08/2018 - 03:57

now in Row 1 i.e a1 it says 1 a2 =5

Excelchat Expert
29/08/2018 - 03:57

so basically column A is C-1(category 1) will fetch all numbers from sheet 1 column A that is in between 1-5

Excelchat Expert
29/08/2018 - 03:58

next b1=6b2=10 c-2 column B will have all number between 6-10

User
29/08/2018 - 03:58

I see the ranges now up top in first two rows. is your data on sheet one and I am just seeing results

Excelchat Expert
29/08/2018 - 03:58

check sheet 1 column A to see all the data

Excelchat Expert
29/08/2018 - 03:58

yes

Excelchat Expert
29/08/2018 - 03:59

they are just random numbers you can type anything .

User
29/08/2018 - 04:00

that is perfect! Thank you so much!

Excelchat Expert
29/08/2018 - 04:01

Welcome :)

Excelchat Expert
29/08/2018 - 04:01

very intresting one ...

Excelchat Expert
29/08/2018 - 04:01

interesting one ..

Excelchat Expert
29/08/2018 - 04:01

have a nice day

User
29/08/2018 - 04:01

You too! thank you for your help!

Excelchat Expert
29/08/2018 - 04:01

Please do leave a feedback once you have ended the session :)

User
29/08/2018 - 04:02

I most certainly will!

Excelchat Expert
29/08/2018 - 04:02

:)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*