Shahin Ghaffari
New Member
Hi
In column A I have some prices and in column B some codes. In column E I sorted the prices ascending by LARGE formula. When I use INDEX MATCH in column E to put the codes in front of prices, there are a lot of duplicate codes because the prices are similar. is there any way that similar prices have different codes?
In column A I have some prices and in column B some codes. In column E I sorted the prices ascending by LARGE formula. When I use INDEX MATCH in column E to put the codes in front of prices, there are a lot of duplicate codes because the prices are similar. is there any way that similar prices have different codes?