Excel Formula 2

[vmgodfrey]

I have question. I am trying to do a true false statement that will return the vaildations as Duplicates or Not Duplicates using just an excel formula for 6 columns. Heres an example
Columns:
Row# - RowAlpha - Lot# - LotAlpha - Space# - Space Aplha
1 C 1
1 C 2
2 A 1
I have tried the validation using Sql, but for the column cells that are blank above a cell that has a value, it nulls everything in that column and I can't pin point the duplicates because it is reading the blanks as dups.
I've tried tagging, highlighting and counting but m=nothing works.
HELP

 

[vmgodfrey]

I have notice that the validation for the duplicate rows will only work if the duplicates are one after the other. If I have a dup on line 37 and the other on 389, it will mark invalided duplicates.

 

[Bowers74]

Do you you put the Concatinate formula in the Column A cell before you enter any date into the other cells that calculate the address?

The formula has to be there before the data is added. If you copy the formula down after you have entered the data, then the validation won't work unless you change one of the "location" cells.



If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!