andy

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

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

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

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

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

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

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

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

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

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

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

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