Hi,
I need to validate a column in Excel for its uniqueness. This column should accept only unique values. The function should iterate through the entire column to compare the string with all the previous and next cells in the column. How can i do this using a function n not any formula?
Also i'd appreciate if somebody can help me with an Excel sheet with 5 columns such that only 1 of the columns has a '1' n rest all can have only '0's.
What i mean is suppose u have columns A-E. If u put a '1' in cell A2, rest all ie B2,C2,D2,E2 must have only '0's n no other value. So that only 1 of 5 cells has a '1'. Next time u may choose C5 to put '1'.Then A5,B5,D5,E5 must have only '0's.
Thanks in advance.