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
Thanks
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
ok
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
Yes
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
yes
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.
