#multiplecriteria

Hello! I am at wits end with this one having spent an entire day on it My desired results are in Col D in blue. I have unique Case ID's but duplicate codes. I want the Approved codes to show the approved Case ID by skipping blanks & picking the first match it gets.

I have a need that I can’t seem to find a resolution to. I need a formula that will look in Training Records workbook, Column E for a name in the Staff List workbook, tab1 Column A. If that name is in both locations, then search all records with that staff name in Training Records...

Hello to everyone, I have been an active reader and have only just joined today in a bid to get some assistance as quite normally the friendly advice that is readily available has been sufficient up until now (where I cannot find a solution to my following problem- apologies if it's listed...

Hi Guys. I so badly need your help. Here's what I wanted to do. I wanted to know if the following names from Table 1 have already submitted the documents considering that they submitted it after the Actual Date with the same infraction. Table 2 shows the documents submitted. I need a formula...

I have a spreadsheet which looks like this <tbody> in the second spreadsheet (Sheet2) i have a list of names with associated references to them. what id like is these refferences to appear in collumn P seperated by a comma like the names are in collumn O, is this possible? </tbody> <tbody>...