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!”

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

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

need to print out but font coming out way too small
Solved by I. J. in 30 mins
I have names in 200 rows in colom A each name has a value in Colum B i want to create 10 small groups based on their values +or - 50 if required a row can be taken from lower ones
Solved by T. U. in 19 mins
Hi there, I am working on a large spreadsheet with qualitative content for work. However, in some of the sheets the column headers (e.g. A, B,C etc) have become really large/wide and the content in the cells below relatively small. How can I make these column headers regular-sized again?
Solved by A. J. in 20 mins
I have a formula obtained from you guys recently that I cannot seem to make work when trying to use it for the same purpose, but when attempting to extract info from another sheet. I need a better understanding of the following formula to understand how it works so that I can adjust it for other uses. =IFERROR(INDEX('Estimate Detail 1'!$F$12:$F$2447,SMALL(IF(0<'Totals by Cost Code'!$V$12:$V$2447,ROW('Totals by Cost Code'!$V$12:$V$2447)-ROW('Totals by Cost Code'!$V$12)+1),ROW(2:2))),"") I'm struggling with the rows portion of the formula, I believe.
Solved by E. J. in 28 mins
I want to be able to hover over an excel and see a small pop up message that shows the calculated equation based on the formula, that can change along with when the formula changes.
Solved by B. S. in 21 mins
I need a macro help (consolidation of multiple excel files into one) I've already created a macro but I need a small fix in it.
Solved by C. A. in 21 mins
I need help with a formula that uses index and match along with small, row and if statements to return multiple rows and columns of data from a matrix
Solved by Z. W. in 12 mins
I need help with a particular formula given by a previous expert. It uses the following: INDEX, SMALL AND ROW. The formula works very well for my data. But, when I try to add information to my dataset, the formula does not behave the same. Here, I want to change the formula to expand it to more possibilities of my dataset.
Solved by A. H. in 30 mins
i uploaded my excel./ i need it to be able to print in one page ( it is small but is printing it separetly in small pieces also 4 first coluns i need to be able to mark X or no X and make it locked to only accept x or no x .
Solved by E. E. in 17 mins
Have a small issue with what message i want to appear instead of #N/A
Solved by S. W. in 16 mins