Spreadsheet: 767877d1644687802-formula-to-copy-rows-based-on-on-three-different-criteria-extract-multiple-matches-from-same-column
Sheet: Source Data

Ref | Location | Text 1 | Full Name | First Name | Surname | email | Category | Match
DPS-001 | NY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | Amelia Brooks | Amelia | Brooks | amelia [EMAIL] | Low |  |  | Objective is to filter records where Col H is "Criitcal", "High" or "Moderate". [NAME] in Helper Column I enters "1" if it does, or "0" if it does not.
DPS-002 | LON | ipsum dolor sit amet, consectetur adipiscing elit | Archie Barker | Archie | Barker | archie [EMAIL] | Very Low
DPS-003 | PAR | dolor sit amet, consectetur adipiscing elit | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Critical
DPS-004 | MUN | consectetur adipiscing elit | [NAME] | Ava | [NAME] | ava [EMAIL] | Very Low
DPS-005 | MAD | sed do eiusmod tempor incididunt ut labore et [NAME]. | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Moderate |  |  | Test by changing any Category
DPS-006 | NY | Ut enim ad minim veniam | Freddie Booth | Freddie | Booth | freddie [EMAIL] | Moderate
DPS-007 | NY | Quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Critical
DPS-008 | PAR | [NAME] et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | George | [NAME] | [NAME] | High
DPS-009 | MUN | [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Grace | [NAME] | grace [EMAIL] | Moderate
DPS-010 | MAD | Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Very Low
DPS-011 | LON | [NAME], quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Bell | henry [EMAIL] | Low
DPS-012 | LON | quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Chapman | isabella [EMAIL] | High
DPS-013 | LON | exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Isla | [NAME] | isla [EMAIL] | Moderate
DPS-014 | NY | [NAME] ut aliquip ex ea commodo consequat. | Ivy Campbell | Ivy | Campbell | ivy [EMAIL] | Low
DPS-015 | PAR | aliquip ex ea commodo consequat. | [NAME] | [NAME] | Barnes | [NAME] | Critical
DPS-016 | NY | [NAME] et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Leo | Bailey | leo [EMAIL] | Moderate
DPS-017 | MUN | [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Lily | [NAME] | lily [EMAIL] | Low
DPS-018 | PAR | Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Butler | mia [EMAIL] | High
[NAME] | LON | [NAME], quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Atkinson | [NAME] [EMAIL] | Moderate
DPS-020 | NY | dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | [NAME] | noah [EMAIL] | Very Low
DPS-021 | PAR | consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Adams | [NAME] | Critical
DPS-022 | MAD | sed do eiusmod tempor incididunt ut labore et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Olivia | Bradley | olivia [EMAIL] | Low
DPS-023 | MAD | ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | [NAME] | oscar [EMAIL] | Low