Hello!!
i am looking for a macro that will remove the rows with the least value and keep the rows with respect to the highest value in a column
image.jpg
many thanks
Gokz
Hello!!
i am looking for a macro that will remove the rows with the least value and keep the rows with respect to the highest value in a column
image.jpg
many thanks
Gokz
Please do not bump threads so fast.
What if both the rows have the same value in column B? Which row should be deleted?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hiiii,
Sorry for the quick threads..
on a deadline and trying out different concepts...
in the above macro, column B is not important....the sorting factor is column D...i.e is to pick the highest two values from the column D..
Any ideas???
Thanks
Gokz
The same code as before
Please Login or Register to view this content.
Helllo Ab33!!
thanks fr the reply...
can we do the macro with reference to one column...like only E..compare the values in column E ..take the highest and delete the remaining..???
thanks
Gokz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks