Hello!

I have a sheet with 6 columns and more than 25000 rows.

The first two columns have a client name and a client number. The other 4 have numbers. I have used duplicate values to mark some of the cells with color.

What I need to do is find which row has 3 or more columns filled with color and I need Excel to give me the name and number in the first two rows.

Can it be done?

Thank you!