Hi Narayan
May be i have not explained properly, let explain it again
i have a excel sheet with number of columns and containing number of rows may be 10000
i want to check for example if A column contains 1 t 30 and B has numbers frm 1 to 30 with some missing numbers and same with C. which...
i would be grateful if you help me in solving this problems
my excel looks like this
A B C D
1 2 1 1
2 1 2 2
3 1 1 2
4 4 4 1
i want this to be arranged in
A B C D
1 - 1 1
2 - 2 2
3 - - -
4 4 4 -
Meaning that if there no match in other columns it should be left blank
Thank you...