hi,
I have a column which has the following data
a
a
a
a
d
e
a
a
a
i need to remove d and e and keep al the a's together. could you please suggest a way?
thanks n advance.
-venkat
hi,
I have a column which has the following data
a
a
a
a
d
e
a
a
a
i need to remove d and e and keep al the a's together. could you please suggest a way?
thanks n advance.
-venkat
Hi Venkat.
Remove meaning you want to delete those rows?
Click *, if my suggestion helps you. Have a good day!!
b2and drag down.![]()
Please Login or Register to view this content.
filter on column B with the value which are NOT equal to 1.
then delete those rows.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
use conditional formatting....in the conditinal formatting tab highlight the unique values...than sort the highlighted values using filter and delete the same
hi,
i have a very large data set and each value is assosiated with a set f values that i have got from v look up. and i need to delete unique values. could you please suggest some other solution?
thanx.
And what about the solution in #3?
hi why dont you try coditioal formatting.....even after colour sorting you can delete the rows.......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks