phil

  1. C

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

    Assign column values to heading? - Linking Cell Movement

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

    Sumifs - Help Please

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

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

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

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

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top