phil

1. Assigning column values to a heading

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...
4. Need help finding a result in a table (array? maybe simpler?)...

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...
5. Count of Consecutive Work Days

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...
6. adding a column to reflect position of a score

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've detected that you are using an adblocker.

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.

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

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.
Go back