formula find repetition of combination

[febausa]

I want formula find repetition of combination

I attached example hand made.

Thank you for your help

 

[NARAYANK991]

Hi ,

See if this works.

Narayan

 

[prasaddn]

Hi Febausa,

I have used on helper column to concatenate all your columns, and then used countif().

Attached is the file.

Regards,
Prasad DN

 

[febausa]

Hi ,

See if this works.

Narayan

Thank you , you formula is great but not what I need. I need repeat the colors ; I don't repetition in numbers. Please amend the formula.
See my example repetition combination
Thank you for your help.

 

[febausa]

Hi Febausa,

I have used on helper column to concatenate all your columns, and then used countif().

Attached is the file.

Regards,
Prasad DN

Thank you , your formula and concatenate is great but not what I need. I need repeat the colors ; I don't repetition in numbers. Please amend the formula.
See my example repetition combination
Thank you for your help.

 

[NARAYANK991]

Hi ,

Recognizing cell colors using Excel formulae is not possible unless you use Excel 4 macro functions. You can look this up on the Internet.

Narayan

 

[febausa]

Hi ,

Recognizing cell colors using Excel formulae is not possible unless you use Excel 4 macro functions. You can look this up on the Internet.

Narayan

Hi Narayan.

I attach file with indicating the range of values for each color, perhaps with these values you can find a formula.

Thank you for your help.

FEBAUSA

 

[prasaddn]

Hi Narayan.

I attach file with indicating the range of values for each color, perhaps with these values you can find a formula.

Thank you for your help.

FEBAUSA

It is not clear what is your requirement! Can you come up with different data set and result.

Regards,
Prasad DN