Thanks for the reply Narayan. Its working as you said. But is there any possibility to bring that entire row to the top. May be using the Macros???
Thanks
Praveen Ch
Hi
There is a requirement...i need to get the row on to the top which has the maximum length in characters. For eg.
A B C
1 AB CH
2 ABC KUMAR
3 ABCD PRAVEEN
I need to find the maximum length in the C column and get that row on the top.
Here in this case its...
Hi
I would like to compare data in two columns and display the data which is missing.
For EX:
A B
1 1
2 3
3 4
It should compare the column B values with column A values and the ouput should be 2.
Thanks in Advance