# 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

A problem with almost made function. Small thing that doesn't work, need professional to solve it. Function calculates distance between two cells
Solved by C. F. in 17 mins
please , this is my last credit. i have 5 people helped me without solutions. the 1st seems good but need some modification. i want data validation to restrict repetition of any character letter,number, and symbols. but the letter is same small and capital for example aA\$123# is not allowed for user input
Solved by E. E. in 29 mins
I have an VBA script which copy the files from Shared Drive to SharePoint Location. But its taking more time to complete. I am using a small user form just to display which particular Folder is copying. Need Optimizing in VBA code
Solved by T. J. in 13 mins
Hi there.. I'm trying to use my existing formula to check multiple sheets for 'yes' in a certain column. This formula works perfectly for 1 sheet (jan),.. but I need it to check everything month (each month per sheet) and then load the row. formula: =IFERROR(INDEX(Jan!A\$4:A\$250,SMALL(IF(Jan!\$M\$4:\$M\$250="yes",ROW(Jan!\$A\$4:\$A\$250)-ROW(Jan!\$A\$4)),ROW(1:1))),"")
Solved by M. J. in 12 mins
Hi, On Sheet 1 I have a sales rep id in column C (highlighted) The rest of the columns are revenue with the dates across the top. I would like to calculate the total each sales rep is worth. So add up all the rows with that rep ID. On sheet 2 I have created a small table where I will put my formulas and the calculation. What is the most efficient way to do this. I believe it is a sumif formula but I cannot get it to work? Thanks
Solved by T. J. in 18 mins
can some one help me on a small macro code, i have a row of numbers 1 and 0's , if 1 numbers repeats continuously for more than 2 its non unique and if less than 2 or =2 its unique
Solved by F. Q. in 30 mins
Its just a quick issue. I would like to know how i can plot some data onto a bar chart the way i want to. I simply have a very small amount of data litterally 2 numbers but also 2 variables . Each time i plot the chart it comes out in the same coloour so than when i do the error bars it doesnt let me do individual errors .... please help
Solved by C. U. in 17 mins
Hello I have a small project where I am trying to calculate the commission for each employee less the previous amounts paid. Is there an option in excel where I can make some sort of table telling me this
Solved by E. H. in 11 mins
i need help in small vba code please i need help in small vba code please
Solved by D. B. in 12 mins
I want to merge multiple files into 1 master. There will be around 3k small files in a folder that need to be merged. Also, want to add 1 column/field in that final file which will show the source file name from which the data is taken
Solved by C. E. in 21 mins