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

Is there a small manual, I can download, for Excel on my IPhone.
Solved by O. Q. in 29 mins
I have a small table as such: Power Interest Result Low Low Monitor High Low Keep Satisfied Low High Keep informed High High Manage Closely When a user selects a power level and an interest level in separate columns, I want it to return the result in the 3rd columns. I am getting very frustrated with IF(AND functions not working for me! Thank you!
Solved by O. H. in 13 mins
Okay, now breaking down the big problem in small parts, if want all sheets name that has a Y in column D or column I in the first sheets column F. Anyone? or the awesome peoples who used to work here last year are all dead already?
Solved by S. J. in 20 mins
Trying to auto populate multiple 'row' information from named table in sheet 1 (BASEDATA) to specific corresponding cells in sheet 2 (WORKDATA) using a drop down list. Current test formula in sheet 1 works great within that sheet but when I try to copy it to sheet 2 it does not work at all. Need a little help on where to place sheet 2 title in formula once copied over for it to work. Test formula: =IFERROR(INDEX(\$P\$2:\$P\$3752, SMALL(IF(\$AB\$1=\$A\$2:\$A\$3752, MATCH(ROW(\$A\$2:\$A\$3752), ROW(\$A\$2:\$A\$3752)), ""), ROW(A1))), "")
Solved by T. L. in 17 mins
may i connect with the expert who helped me with power query yesterday? I need a small modification on the solution provided and I have no clue how to do it myself.
Solved by D. C. in 14 mins
how do i print to make my sheet readable and not so small
Solved by X. A. in 26 mins
I want to display a list of names in B and G. If the name in L corresponds with Big, it should display in B. If the name in L corresponds with small it should display in G. I got as far as =if(m7="Big",L7) Else... I'm not a programmer, help would be much appreciated :)
Solved by E. J. in 11 mins
Hello! I need help with a formula. I have two Sheets - Sheet 1 (Product Info) & Sheet 2 (Order Calculations). In Sheet 1, there is a range for the Products (e.g. A1-20), as well as the prices by product and size (e.g. for Small prices S1-20, for Medium prices, M1-20, for Large prices L1-20). In Sheet 2, I have a few drop down options: For example, "Product Type" with a dropdown of all A1-20 items. Then I have a field with the Size options, so the dropdown has "S", "M" and "L". If I want a formula in Sheet 2, depending on the dropdown of "Product Type" (A1-20) & "Size" (S/M/L), how do I make it take the correct information from Sheet 1?
Solved by I. E. in 20 mins
I need to print my Excel sheet to an A3 page. Each time I select A3, it prints out but it's all too small. I want the page to fill the whole A3 page. I seem to be able to do this for A4 but not A3.
Solved by O. S. in 30 mins
I am trying to run a formula that takes a value, and if it appears in both columns on a separate tab, it pulls the difference between the adjacent cells value. I have tried if, match, and vlookup formulas but can't seem to figure it out. Any help is much much appreciated. Below is small example of what I am trying to run asking if CA9099 it should tell me \$1. So in a cell I put =ifmatch(CA9099, it will take the difference, and if the value doesn't exist in column A on the tab it reads N/A A B CA9099 \$21 CA9099 \$20 CA5674 \$20 CA8788 \$30 CA8788 \$35 CA5674 \$15
Solved by S. F. in 22 mins