Get instant expert help with Excel and Google Sheets

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

construct macro to 1st to replace #value! to blanks 2nd to Shift data all to left 3rd to sort left to right ascending order

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

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.

Hello I would like to work on Multi bracket formula to calculate my numbers

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.

I have 2 columns, one with names and one with numbers, I need to total the names across the whole sheet

How to create a Supply Chain KPI Dashboard with a speedometer type reading charts?

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.

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!!