“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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