Create counter for combinations of cell matches within same row

Gouldinho · #1 02-03-2023, 02:12 AM

Hi All,

I'm trying to create a counter which identifies instances where for example "*P*" in column C and "Office" in D both occur in the same row. This counter would go in I21 in my attached screenshot.

For context, I know how to create counters, just not how to ask it to look for combinations from 2 cells within the same row.

This would obviously need to apply to the whole sheet.

I hope I've managed to explain this clearly and thanks in advance for any help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
lookup the date beside a cell that matches a value	oscarlimerick	Excel	2	01-30-2022 09:38 AM
how to create a Microsoft word 2016 tempalte so it matches a CSS template	bboerma	Word	3	11-21-2017 08:18 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
cell text to auto populate if criteria matches	Jackie	Excel	2	02-06-2015 07:58 PM
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?	alshcover	Excel	2	06-03-2014 12:50 PM