Excel: if in advance unknow# repeated in row get remark in a cell

D

dilettante

I use the formula suggested in 1 second by "teethless mama".
=IF(COUNT.IF(Range;value)>1;"duplicated";"")
It works well for know numbers but I am not able of using it if the numbers
(more than 7) are unknow.
ColumnA ColumnB Column C etc
row =SUM(A1:A10) =SUM(B1:B10) =SUM(C1:C10) etc

I would like to get an advice in a cell if there are duplicate results (the
same result in different colums).
Thank you for help
Dilettante
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

repeat summing? 3
Variable Sumproduct Range 6
Unique Value Count in 3 Columns Using Search Criteria 0
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row 4
How do I use advance filter correctly? 2
simple formula help in Excel 2007 2
AND() for an array 8
sumproduct, multiple if, some same cell, determine number of rows 4

Top