Get instant live Excel expert help to learn how to use Small function in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
To arrange figure in "2018" column from largest to smallest for all 3 tables (under YTD Guest Origin Report)
Solved by D. D. in 14 mins
Want to arrange the figure in the both table from largest to smallest
Solved by C. D. in 28 mins
I need a formula to separate and order data that I have pasted into Excel, currently all in one section (HC-One 9.4 352 CH, 1 ADC • P) and I want the number previous to CH to be ordered numerically largest to smallest
Solved by D. S. in 17 mins
Hello - Need to sory by column AB (Xray Market Spend).
This sheet was created using a pivot table & it's not letting me do a simple short largest to smallest in the sort & filter button.
Thanks!
Solved by I. H. in 25 mins
i have a column with my glass types and a column with my total sware footage for the glass size. i have arranged the glass in order from smallest square footage to largest. i want to make another column where the glass type EX GL-T gets a number added on the end of the glass type EX GL-T1 and +1 if the next piece of glass have a different square footage EX GL-T2
Solved by Z. Q. in 28 mins
How can I sort by smallest to largest ,but only by the first number in the cell? So I have 600253 at the top, then 00571G5 below that since it has more digits. I would like 00571G5 to be before 600253.
Solved by X. J. in 28 mins
I'm trying to refer to another cell in a row through a formula. I am using a MIN formula to find the smallest number in a column, but i also want to show the date where that number came from (the dates are in another column).
Solved by F. W. in 20 mins
I have a spreadsheet with specific item types and their monthly totals. I also have a formula which calculates the items specific percentage off the overall total. It works fine but my problem is when I sort by largest to smallest sales numbers, the percentage errors out and I have to manually fix it every time. Is there a way to fix it so that it auto changes once my other cells change?
Solved by A. L. in 30 mins
I need to take two spreadsheets and create a Pivot Table to aggregate contacts by company name, have a second column that shows a total number of contacts for each company, then be able to rank them from largest to smallest. Can you help me with rank function in table?
Solved by A. H. in 14 mins
I need a formula to add together the smallest 2 of 3 columns and display the result
Solved by F. Q. in 27 mins