Hi,
Yesterday I posted a similar question to this one but figured more context is needed in order for a solution to work for me :(
For context, I have data in a primary table structured like below:
<tbody>
Name
City
Level
Jeff
Perth
5
Mark
London
2
Phil
New York
4
</tbody>
The names...
Hi!
I want to be able to make cells move together if I change the value of one of the headings. I currently have the heading set up to come from another sheet using a vlookup. When I insert a column on the other sheet, (say, Jim) the second table below is what I get, but what I want to occur is...
<tbody>
Name
Sales
Sales Code
Phil 1
£123
10
Phil 2
£123
12
Phil 3
£123
22
Phil 4
£123
20
</tbody>
Thank you in Advance!
As part of larger sumifs formula I want excel to do the following.
In column A is a list of names, in column B is their sales for the month figure...
For Worksheet_1, I have the following table below across columns A to G and on rows 1 to 15 in excel. As you can see, it shows which person owns which segment (SMB, ENT, GROWTH, COM) based on their state. So for example the person that owns ENT in MT is Kelly (cell G3) or the person that owns...
Hi Guys, I am trying to get a formula going which will show if an employee has worked over 6 consecutive days. The way in which my data is currently stored is like the following:
<tbody>
DATE
Week
Employee
Hours Worked
01/05/18
18
Bill
10:00
02/05/18
18
Bill
14:00
03/05/18
18
Bill
08:00...
Hi all,
My spreadsheet has a block of rows divided by an empty row,each block representing a student record.The blocks are of varying length i.e the records are split up into groups.,and it documents students maths marks over a given time.Here is an example.What I would like to do is add another...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.