Hellooo. Below is the the data I am looking at. I need to keep the row with the highest value in Col4 for each group of data. What is the best way to do this? When I use the sort descending and then remove dups and keep the first row, it sorts all of the numbers so that in Col4 it would be all of the highest numbers together, not grouped. Am I making sense? I know this is possible but it's just not coming to me that easily. Any advice is appreciated! Thanks, Nicole.
No problem - below is what I would want the output to look like. Basically I want to keep the row with the highest number in COL4 for each group of data. Does that help? I was trying to sort and remove duplicates, but it just wasn't working, at least not the way I did it!
Did you try creating a Key Change Column when you sorted descending? It will be a 1 for the first record in each key group and a 0 otherwise, you'd want all the 1s.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Thanks, Nicole.