Posts by Abingail


    I have a spreadsheet which has name IDs as a list in Column A with Row 1 [from B onwards] used to show the dates.

    Name IDs will have a unique letter code under certain dates.

    How can I make a list to show all the names for each date with content.

    What I am looking to achieve is this:

    I have multiple years worth of sheets to combine and the name ID list is over 200 long!

    Any help would be much appreciated, thank you in advance!

    I would use an advanced filter. Copy the exact headings into the next 4 blank columns and in the row below the criteria you want. Use <>UUF for A. Select the list range as the table, criteria range as these four new volumes and the row below.

    This will then allow you to quickly change the criteria without having to edit a formula