Get instant live Excel expert help to learn how to create and adjust tables in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi im looking for help with pricing between 2 tables
Solved by T. E. in 11 mins
how do i delete whole columns in worksheet and tables?
Solved by S. Q. in 11 mins
I have a data and wanted to create pivot tables
Solved by M. D. in 25 mins
I am making Likert scales. I have inputted all the data and now making tables. I did the first one fine. But in the second one, when i am copying different cells over (columns and rows) all the data changes to the same data in the first cell, and i don't think i have done anything differently. very puzzled.
Solved by X. C. in 11 mins
Hi! I have a slightly strange request and it’s been a long time since I’ve really got deep into Excel formulae. Although this is specifically for Google Sheets so hopefully it’s possible on that too.
So I have a list of people and dates that will be added to from time to time. Once a persons name has appeared 3+ times it will appear in another sheet and has to be at the bottom of that sheet.
I’ve done this using Pivot Tables but that auto sorts alpabetially. It’s essential once someone has completed three courses that their name appears at the bottom.
Hope this makes sense!
Solved by X. W. in 22 mins
How do I create a Pivot tables in Excel and are there any free tutorials
Solved by M. U. in 29 mins
I have a database extract that is showing the same clients multiple times in the list. How can I write a formula in excel to look at the column with the client names and return only unique records on another sheet? I want to run this over several files so wanting to avoid using pivot tables which is how I would normal do this.
Solved by X. J. in 27 mins
To arrange figure in "2018" column from largest to smallest for all 3 tables (under YTD Guest Origin Report)
Solved by D. D. in 14 mins
Good Morning
I have data with multiple pivot tables. I have a slicer with date ranges, example 07-29-18 to 08-11-18, that brings the data together with this date range. When I choose this date range the data shows blank. When I choose Blank on my slicer the data shows up. I have removed the data and re-entered it. File is very large and has been working up to this date. If I go to the next date range I get the data
Solved by M. L. in 21 mins
I am using an Excel 10, single sheet workbook, containing 200 2-D data tables. Is there a way to select only a subset of the 200 defined and registered data tables to be recomputed to save computation time? Also, are data tables executed in a predictable order? Thank you.
Solved by B. B. in 16 mins