Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i have a multiple tax rate in column g like 12,5,18,28,28,12,5,12,28,12,5,and more, my summary in column b at below portion of invoice. i want a formula which can appear in summary column as ascending order like 5,12,18,28. but if there is not a tax rate in column which should drop that rate and appear next rate. Like if there is not 5 though it's drop and fetched result 12,18,28. please help me and let me know solution on this topic
Solved by B. F. in 21 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/07/2018 - 04:08
Hi…Welcome to Got It Pro
Excelchat Expert 02/07/2018 - 04:09
Could you please share your file?
User 02/07/2018 - 04:09
i have a pdf which not link in site
Excelchat Expert 02/07/2018 - 04:10
pdf will not be accepted
Excelchat Expert 02/07/2018 - 04:10
Can you put the data in this preview sheet?
User 02/07/2018 - 04:10
yes, i'm typing
Excelchat Expert 02/07/2018 - 04:10
Excelchat Expert 02/07/2018 - 04:11
I will just need to know your data structure and what exactly you require.
User 02/07/2018 - 04:11
i put a structure in sheet
Excelchat Expert 02/07/2018 - 04:13
User 02/07/2018 - 04:13
i want a tax rate from column g to column b in ascending order, but if there is not a rate in column g it should drop and next rate appear in summary column
Excelchat Expert 02/07/2018 - 04:14
I didn't quite follow you.
User 02/07/2018 - 04:15
have you any solution regard this problem, pls let me know
Excelchat Expert 02/07/2018 - 04:15
Which cell in column B should the tax rate appear from column G?
Excelchat Expert 02/07/2018 - 04:15
And what is the criteria?
User 02/07/2018 - 04:16
criteria from column g and result should appear one by one
User 02/07/2018 - 04:18
hey, r u there?
Excelchat Expert 02/07/2018 - 04:18
Excelchat Expert 02/07/2018 - 04:18
I am trying to understand your problem and working out a solution
Excelchat Expert 02/07/2018 - 04:19
Please see the formula in column B]
Excelchat Expert 02/07/2018 - 04:19
Is that what you want to list them in ascending order?
User 02/07/2018 - 04:20
column g is tax rate which calculate item wise tax and i want summary that tax amount in below portion of invoice
User 02/07/2018 - 04:20
there is not view any formula
Excelchat Expert 02/07/2018 - 04:21
You have be very clear and precise of what exactly is your question.
Excelchat Expert 02/07/2018 - 04:22
If you click on cell B2 and look at formula bar, you will see formula =small($G$2:$G$10,A3)
Excelchat Expert 02/07/2018 - 04:23
I have done this by listing a sequence in column A as you said you wanted the column G tax rate to be listed one by one in ascending order.
User 02/07/2018 - 04:23
formula view, but it's appear multi time and i want a one time, because in column c i will show a sum of that tax rate
Excelchat Expert 02/07/2018 - 04:24
"criteria from column g and result should appear one by one"
User 02/07/2018 - 04:24
Excelchat Expert 02/07/2018 - 04:24
You said one by one here....what did that mean?
User 02/07/2018 - 04:24
means 5 after 12 after 18
Excelchat Expert 02/07/2018 - 04:24
in just one cell??
User 02/07/2018 - 04:25
no, cell by cell
Excelchat Expert 02/07/2018 - 04:25
So that is what is happening now, right?
Excelchat Expert 02/07/2018 - 04:25
cell by cell all tax rate are appearing in ascending order
User 02/07/2018 - 04:26
it's show multi time and i want only one time
Excelchat Expert 02/07/2018 - 04:26
Can you take a screenshot of your pdf and upload here as .jpg file?
Excelchat Expert 02/07/2018 - 04:27
I guess that will help me understand your problem as you seem to be unable to explain it.
User 02/07/2018 - 04:27
i cant do that, sorry!
Excelchat Expert 02/07/2018 - 04:27
Then how are we going to solve your problem.
Excelchat Expert 02/07/2018 - 04:28
Now it appears one time, do you see that?
Excelchat Expert 02/07/2018 - 04:28
You are not explaining it precisely and you are unable to show it either.
User 02/07/2018 - 04:28
ok, i will try on that
User 02/07/2018 - 04:30
thanks for gave me your time and trying to solve my problem

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc