#1
|
|||
|
|||
Repeat values in row
I need help solving the problem. I need to put on SharePoint an excel file that would be populated with data, but if some data is repeated in three cells within in single row a message should appear (like data validation error alert)informing that that values already exist.Is it possible solve this only with formulas?
Thanks in advanced |
#2
|
|||
|
|||
have they all got to be in the same row to match? i.e your example row 7 ,matches row 2. or can the 10 be in row 2, the 200 in row 5 and the 1000 in row 6?
|
#3
|
|||
|
|||
Yes, they got to be in the same row, but it doesn't matter in what row is it, all rows need to be unique.
|
#4
|
|||
|
|||
have a look at the attached, i have added a formula in column D that is true if all 3 match. I have also added the formula into the Conditional formatting so it highlights.
please note i have changed your numbers around |
#5
|
|||
|
|||
Thank you very much.You save me.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table with values from several locations and years - need to find comp values | Ricardo Sousa | Excel | 9 | 07-27-2018 02:06 AM |
Table with values from several locations and years - need to find comp values | Ricardo Sousa | Excel | 6 | 06-09-2018 10:51 PM |
repeat if | paltser | Excel | 1 | 12-01-2015 09:32 AM |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
Repeat formula 5 times and repeat? | Jenny345 | Excel | 4 | 06-14-2013 04:37 PM |