# Excel - IF Function Problem - Expert Solution

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
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
Excelchat Expert 29/08/2018 - 03:53
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.