Get instant expert help with Excel and Google Sheets

“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

I have a filtered data table that I build and I need to freeze a selection so that it will not be affected by column filters. More specifically freezing selection A1-B20 and the top row
Solved by X. S. in 22 mins
construct macro to 1st to replace #value! to blanks 2nd to Shift data all to left 3rd to sort left to right ascending order
Solved by K. J. in 14 mins
For each material if there is more than one distinct value in the status column then it should appear as true otherwise false, then i need to to pull all the true values into a second excel tab
Solved by A. D. in 21 mins
Looking for a formula that looks up a value in a column then returns a count of how many times it appears in the column.
Solved by X. W. in 17 mins
Hello I would like to work on Multi bracket formula to calculate my numbers
Solved by D. Q. in 16 mins
I have a table showing dates of attendance in column a, and ID numbers in column b. I would like to have column c show the amount of time since that person last attended.
Solved by I. A. in 13 mins
I have 2 columns, one with names and one with numbers, I need to total the names across the whole sheet
Solved by O. J. in 18 mins
How to create a Supply Chain KPI Dashboard with a speedometer type reading charts?
Solved by M. H. in 17 mins
When I try to open some of my saved excel documents I am receiving a message that says "This workbook is either deleted or not currently accessible." I am saving my documents just like normal and it is not happening to all of them but it is happening to several of them.
Solved by E. W. in 24 mins
Hi, I have a pivot chart where the times are not in chronological order (7 AM- 9 PM) and I need to know HOW to change that. Someone on here told me to right click and select "move to beginning" but when I right click- that is not something it is allowing me to do. Is there another way? Also, I need the days of the week need to be Mon-Sun and can't change that either. Thanks!!
Solved by X. W. in 15 mins