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

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

Id like to format a table (gray/medium) in this document so its easier to look at/read.
Solved by Z. C. in 23 mins
Tough one (atleast for me). I am trying to group similar data in Excel. Below is a picture of what I am looking at and an explanation of what I am trying to do: The Value's across the top are the values for each zone. The letters down the left side are different variables for each zone. Some variables go that specific zone and some do not. For instance "A" goes to All of the zones as does "C". "B" however only goes to zones 1, 1A, and 2. I am needing for Excel to split these and list which "variables" (Column A) and final value totals for each different group of variables. So "A and B" would be a total of 29,483 as they go into all of the zones, and then it would also list "A,B,C" and a total of 25,651 since that only goes into Zone 1, 1A, and 2. I am needing those listed together in a easy to view table.
Solved by F. F. in 19 mins
Hi, I need to do a table where I put the number of stops done by a driver e.q. 90 and then it splits it down for different rates paid e.q. a driver does 70 stops and considering that it's £1 for 1 to 65 stops and £1.20 from 66 to 72 stops, then what formula do I need to use to break that number of total stops into the table for different rates so I can see that 65 stops been done for £1 and 5 stops been done for £1.20 which gives me a total of.... Thanks a lot!
Solved by S. Q. in 29 mins
use of solver To best match the group with meeting room, each group listed their preferences from 1 (the most desirable) to 10 (the least desirable). Your job is to allocate the rooms so the sum of the preference scores is minimised but also ensuring that each group receives no worse than their 6th best choice. Two groups have specific needs and have requested a particular room – ProjD Investigation needs to use the Velocity Room, and External: Open Data Meetup needs to use the Refactor Room. To complete this task, you should use Solver. The sheet you have for this contains two tables. The first table indicates each group’s preferences for the ten meeting rooms. The second table indicates the assignment of the room to the group. A value of 1 in the table indicates that the meeting room has been assigned to the client. A value of 0 indicates that the room has not been assigned. Only one meeting room can be assigned to each group and each group can only reserve one room; this each row and column of the table will have one cell containing the value 1 and the rest of the cells will contain the value 0. The values in the preference value column should be no greater than 6 indicating each group will receive no worse than their 6th best choice. The preference total cell is the sum of these scores.
Solved by S. C. in 27 mins
To best match the group with meeting room, each group listed their preferences from 1 (the most desirable) to 10 (the least desirable). Your job is to allocate the rooms so the sum of the preference scores is minimised but also ensuring that each group receives no worse than their 6th best choice. Two groups have specific needs and have requested a particular room – ProjD Investigation needs to use the Velocity Room, and External: Open Data Meetup needs to use the Refactor Room. To complete this task, you should use Solver. The sheet you have for this contains two tables. The first table indicates each group’s preferences for the ten meeting rooms. The second table indicates the assignment of the room to the group. A value of 1 in the table indicates that the meeting room has been assigned to the client. A value of 0 indicates that the room has not been assigned. Only one meeting room can be assigned to each group and each group can only reserve one room; this each row and column of the table will have one cell containing the value 1 and the rest of the cells will contain the value 0. The values in the preference value column should be no greater than 6 indicating each group will receive no worse than their 6th best choice. The preference total cell is the sum of these scores.
Solved by G. F. in 23 mins