Search:

Type: Posts; User: danielpeam; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    291

    Remove zeros

    Hey guys,

    I have a spreadsheet with a very simple formula - ='Copy updated data here'!K173

    Essentially copying over the figures from another spreadsheet.

    However, when the cell is blank it...
  2. Get external data / run saved query Mac

    Hey all,

    Last week I could run a saved query in Excel on my Mac - it would pull a url from a text file and import a table into my spreadsheet.

    This week the option has disappeared, and I'm...
  3. Re: Return a specific cell if two criteria is met

    This works and is amazing! Thanks!
  4. Return a specific cell if two criteria is met

    <tbody>
    Grade
    Name
    Date




    Terry
    00-01
  5. Replies
    2
    Views
    225

    Split date into different format

    Hey guys,

    I have a problem splitting a date format into different columns.

    The dates appear like so - Tuesday, March 6, 2018 3:23:52 PM GMT within the cell would like this split by D/M/Y -...
  6. Combining conditional formats or forumulas

    Hey guys,

    I have two sets of data - one has an IF formula which leaves the words 'win' or 'lose' based on the results.

    Formula is =IF(A15<=C15,"lose","win")


    And another which highlights...
  7. Replies
    2
    Views
    152

    Re: Sumifs or alternative for a table

    This is perfect - thanks
  8. Replies
    2
    Views
    152

    Sumifs or alternative for a table

    I'll do my best to phrase this - I have a table, see below.

    I have a table similar to below, in cells A9 and B8, I want to be able to edit the names to any of the names in the table, and have it...
Results 1 to 8 of 8