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

Need a percentage of a calculation to show in a column

Solved by I. Y. in 15 mins

I have a spreadsheet with multiple names on it across the top.
There is a line for each date of the month.
In each date there is a 1-5 rating listed
I need to total the ratings at the end of the month and then give the average rating.
For example: this person got two 5's. That's an average rating of 5
this person got a 5 and a 3 = 5+3=8/2=4 average rating of 4
I don't have the time to create a new page and need to add the formula to this person's worksheet

Solved by O. F. in 13 mins

I doing a check register, Columns D are the deposits, Column E are the withdrawals Column F is the balance.
How do I write the formula for this,so it will give me the balance if I deposit or with draw?

Solved by Z. H. in 15 mins

why is this dashboard not displaying what i really want

Solved by I. C. in 17 mins

got help yesterday, but not easy to copy. i want a single formula that i can copy to hundres column to the right, the formula is to check wether team is unique or duplicated by looking onto team members. for example team 1 and team 2 are duplicated despite the order because team members are same. team 3 to 5 is uninque,what is the formula for row 9?

Solved by Z. Q. in 16 mins

id like to copy a formula into the cells below but want to change one number to be consecutive i.e. ='002.xlsx'!$D$2, ='003.xlsx'!$D$2, ='004.xlsx'!$D$2

Solved by D. U. in 16 mins

I have a workbook with many pages. The cells on the following sheets are fed from the first sheet. Is there a way to get the units (currency) on the first sheet to apply to the cells on the following sheets?

Solved by A. D. in 30 mins

Hi team. would like to figure out how to cross reference information from a column to a row.

Solved by F. H. in 15 mins

I am trying to create a summary worksheet for several worksheets in my workbook. I need to be able to look up a value and return the value.

Solved by S. E. in 30 mins

Hi, is it possible to create excel for checking who has absence leave of
in office and how many days of absence leave he has:
It needs to show: basic info like name, department, personal n. then n. of days left for holiday.
I was thinking that if someone will open it he will mark with color in calendar that is shown in sheet which day hes taking absence leave. Then it calculates how many days has he left.

Solved by X. Y. in 16 mins