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

I need to create dashboard containing 4 charts(pie or histogram or any) and pivot table data

Solved by D. H. in 23 mins

Business Spread sheet. Need Help
Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.

Solved by T. U. in 15 mins

I have a list of Entities that each need a number of the same item. Some need as much as 72 of that item, some only need 1. I can only deliver 72 of that item per day, so I need to find a way to sort this list into asymmetrical groups where the total number of items needed per group is as close to 72 as possible without going over.

Solved by G. L. in 22 mins

In column I, enter a formula to calculate the insurance charge if the renter has elected
insurance coverage (Yes in column E). Use the furniture’s group code and the Monthly
Insurance column in the RentalCharges table to look up the insurance charge. Remember to
multiply the monthly insurance charge by the rental period. If the renter has not elected
insurance, the cost is $0.

Solved by K. H. in 13 mins

Need help with several vlookup and pivot table questions.

Solved by I. S. in 16 mins

Hi,
i have a spreadsheet which has 3 columns
a = date
b = time of day
c = numerical result from a machine monitoring air pollution
d = word describing where the person is at that time point
i am trying to do two things
1. work out how long each person spends on each activity/place
2. work out total sum of the pollution monitoring for each activity
i have tried sumif but it doesn't seem to work?

Solved by D. Y. in 11 mins

Write a formula for me that goes something like 'if cellA is in this range (between cellX and cellX*2), then 1. if cellA is in this range (between cellX*2 and cellX*3), then 2.
Its a formula to increase '# of employees needed' based on sales volume (cellA) and hours worked capacity per 1 employee (cellX).

Solved by X. W. in 29 mins

While trying to substract multiple cells ''=H13-H2:H12'' (=*a cell*-*bunch of cells*) doesnt work while ''=G13-G2-G3-G4-G5-G6-G7-G8--G9-G10-G11-G12'' works. Tried it the same way in google sheets and it worked.

Solved by I. E. in 24 mins

Hi,
I'm making a shedule calculating number of days with function (row 4) with number of hours/function (row 2).
=(G4*G2)+(H4*H2)+(I4*I2)+....
Colum marked PROBLEM
How can i get excel to do the same calculation for 2 rows for all functions G to AK. i.e =(G4*G2)+(H4*H2)+(I4*I2) + ... until (AK4*AK2)

Solved by X. C. in 21 mins

I currently have a large worksheet with over 7,000 cells. I have listed regions under a column i named "Location." In that column I want to change the region from lets say "Eastern North Central" to "US-Midwest," "Mountain" to "US-West" and so on. Is there anyway I could use a function to enter under my location column so all regions change to my desired classifications so i don't have to manually change over 7,000 cells? Perhaps some convoluted IF function?

Solved by Z. J. in 11 mins