Get instant live Excel expert help to learn how to use Small function in Excel

A problem with almost made function. Small thing that doesn't work, need professional to solve it. Function calculates distance between two cells

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

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

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))),"")

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

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

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

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

i need help in small vba code please i need help in small vba code please

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