Hi,
When you have a list of names with corresponding %'s such as below and you have double names, such as Tom and Joe, how to get the first % that belongs to the respective name?
Tom 0.5%
Joe 0.25%
Brad 0.25%
Bill 0.35%
Charlie 0.26%
Tom 0.6%
Joe 0.30%
Many thanks