phil

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