andy

  1. A

    Change column order

    Hello, Shown below is a simple table showing a list of students and their grades for tests they periodically take. I send the results to them so that they can see how everyone is performing without knowing each others scores. I would like to automatically anonymise the columns each time I send...
  2. M

    Sumif for category and criteria

    Hi there, I am looking to create a sumif (or sumifs) for the following data set, so that a sum is given for each name, HOWEVER with the caveat of the addioanl criteria of under a certain value. For example, the total sum of volume for Matt, but only for values less than 4. Please can someone...
  3. A

    Disabling Row Expand After AutoFiltering

    Hello all, I have a set of data that has manual grouping of rows, and all the rows are summarized to level 1 to hide the detail. When an autofilter is entered, my grouping automatically expands all rows. Is there any way to disable this? Many thanks! -Andy
  4. A

    Insert 5 Rows above Specific Text

    Hi all, I am looking to find the text "Final" in column B and insert 5 entire rows above it. Thanks for any help Andy
  5. L

    Conditional formatting Question

    How do I set up conditional formatting for all of the cells between I and R to change to Green if the cell is above the target cells (C) and red if it's below. I can't seem to find a way without setting it up for every single row individually. I realise this is probably something simple but I am...
  6. X

    Merging/Formating Question

    How can I merge/format 2017 and 2016 (BEFORE) together like the example at the bottom(AFTER). The only difference is that Taylor has zero for 2017. Thank you, <tbody> BEFORE 2017 2016 Andy 500 Andy 800 Eddy 100 Eddy 300 John 1000 John 400 Todd 600 Taylor 1...
  7. E

    Formula to select the earliest date

    <tbody> Person Date Amount Jim 2/21/2019 15 Jim 1/1/2018 85 Jim 4/6/2018 11 Andy 6/1/2019 23 Andy 4/1/2018 15 </tbody><colgroup><col><col><col></colgroup> I want a formula to pull the earliest date and amount for that per person: Output: need formula for below Date and amount...
  8. A

    Help with a formula

    Hi Im trying to make a formula that can take keywords i specify and change them to the name of where they are located in an adjacent cell. This is how far i have got =IF(OR(ISNUMBER(SEARCH("Cap",A2)),ISNUMBER(SEARCH("Hat",A2)),ISNUMBER(SEARCH("Snapback",A2))),"Cap Room") but i don't know how...
  9. L

    How to count text as a number - Exclude duplicates

    This is probably very simple for most people but I want to have a total number of names from a list but if the name comes up more than once I only want to count it once. For example: <tbody> <tbody> A 1 Ryan 2 Bob 3 Jim 4 Dan 5 Andy 6 Luke 7 Peter 8 Ryan 9 Andy 10...
  10. T

    Create summary sheet

    Hi I am using excel 2013. I have individual sheets for each team member that use 'networkdays' to calculate holiday used between a start and end date. I would like to put a letter 'R', 'A' or 'D' in columns in a summary sheet depending who has booked holiday. I can't attach the workbook I am...
  11. N

    Urgent - Excel/VBa help - identify text in cell and sort

    All, My original spreadhsheet with user name, location and package is in this format: <tbody> First Last Location Package Andrew Wan Chicago <tbody> EX - RT CBOT, EXD - DELCOMEX, EXD - DEL NYMEX, NTWK WB BASE - QUOTES AG/COMMODITY, PUBLIC DEFAULTS </tbody> Nicole Andy New York...
  12. H

    A formula to check on everyone's first day attendance

    Hi everyone, date day name check 1/11/17 wed andy OK 1/11/17 wed carl OK 2/11/17 thu andy 2/11/17 thu brian OK 2/11/17 thu carl 3/11/17 fri brian 3/11/17 fri dan OK 4/12/17 mon andy OK 4/12/17 mon dan OK...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top