I have a list of names (Names) in sheet 1 Column A that I need to be able to paste onto a new sheet. Most names appear more than once.
The thing is I need to paste each name only once. (Lets call this new list NamesOnce) How can I do this with a macro?
On top of that, each name has a value associated with it, let call that SALES. Is there anyway to have next to the NamesOnce list the Maximum Value associated with a certain name?
E.g
Names Sales
Lisa 4
Bob 4
Josh 1
Paula 7
Lisa 5
Bob 2
Bob 6
Josh 10
Paula 8
I need to have this on a new sheet
Names Max
Lisa 5
Bob 6
Josh 10
Paula 8
Can I do this?
The thing is I need to paste each name only once. (Lets call this new list NamesOnce) How can I do this with a macro?
On top of that, each name has a value associated with it, let call that SALES. Is there anyway to have next to the NamesOnce list the Maximum Value associated with a certain name?
E.g
Names Sales
Lisa 4
Bob 4
Josh 1
Paula 7
Lisa 5
Bob 2
Bob 6
Josh 10
Paula 8
I need to have this on a new sheet
Names Max
Lisa 5
Bob 6
Josh 10
Paula 8
Can I do this?