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

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

Hi,
I am one of the Administrators of my company, supervising the contact lead and customer cycle together with our sales team. We have used Quickbooks to do so before but needed to add a few more information due to the very specialised nature of our products.
Structure of tables enclosed:
1. Contact leads table to be seen as main database from which the 'Inactive' and 'Customers' tables are drawing from (using simple if-formulars)
2. Using filter options in the tables 'inactive' and 'customers' all results showing n/a's are being filtered out.
3. Further Status of orders or reason for why a customer was added through the 'status list' and the data validation excel function.
My current problem is:
1. I would like to have an 'automatic running' formular that transfers. Currently my approach is very manual and time intensive as I continously have to further adjust the if-formulas to make e.g. new customers appear in the 'customers' table after the my colleague adjusted their status in the contact leads table.
2. I did try iferror function and did not find the result pleasing.
I would greatly appreciate your support!
Thank you!
Kind regards,
Neblina Weggeland

Solved by F. J. in 25 mins

Hi I have a table of data and I would like to increase every cell by 45%, please can you help

Solved by K. H. in 22 mins

I am having an issue creating a separate table to show only two results from my original table. The table I want is the one highlighted in yellow. Could you please show me how to get there? Thanks

Solved by M. A. in 13 mins

I'm having trouble with the VLOOKUP from the Master sheet to the table linked to the internet on Sheet2.

Solved by F. W. in 21 mins

Please could you margin the cost in table 'Express Cost' into a new sheet with a 80% margin added. Is it possible to be able to be able to change the Express cost sheet if we had a rate increase and still have the formula work?

Solved by V. C. in 16 mins