Hi all,
New to this forum so appreciate any help you can provide.
I have names in multiple rows in columns M:U named (Data) as well as in column V named (Final)
I also have two separate named ranges - (Primary) which only contains one cell
and (Secondary) which contains many names.
I am trying to count the number of times (Primary) is in (Data) when any of the names in (Secondary) ARE NOT in (Final).
Please see the attached spreadsheet.
I ultimately need to make this work in google sheets but any help in excel would help as a start.
Thanks!
Bookmarks