Modify countifs formula to exclude certain criteria

Hello all,

Hope you are having a good day.

In the sample worksheet, I created formulas in columns J-O that simply returns a 1 if the specified criteria in the countifs formula is met..a "n" if not

in this case, when for column J, "1 e" is in the same row columns A-H, a 1 is return...next column K when a 2 in the same range, a 1 is return..3 and so on to 6.

The issue I am having is I don't want it to count when the number occurs with a c..e.g 2c,3c,4c,5c,6c (excluding 1 e).

I highlighted in yellow the places where this occur and in the corresponding formula when it is counted, yet I don't want it counted.

For example, I row 5 there is 4c and so the formula counts this 4, but I would like it not too as there is no other 4 in the specified range.

How do I modify the formula to exclude this or is there a different approach?

Thanks for the help

Workbook didn't attach.

Please see instructions at the top of this page.

We only need a small sample. There's no way that amount of data should exceed the maximum for an Excel File. Just the sheet shown in the .pdf file will be enough if it's other sheets that make the file large. A .pdf file is as useless as a picture for anyone to work with.

Try, in cell N11:

Formula:

Please Login or Register  to view this content.

You should be able to copy the formula to the other cells EXCEPT column J. Possibly not needed there?

You're welcome. Thanks for the rep.