Hi
The formulas for what you want is as follows :
Product ID B&co Price Lowest Price for Product Difference
problem is that your amount of companies to compare for each set is variable and that is above my level of expertise......
You will need a "for each" loop to find each time that B&co appears in column b and that pastes the formulas next to each, the same code will then have to count the amount of companies to compare.
if you can narrow it down to the same amount of companies to compare to, my solution becomes a little bit more viable, here's how......
let's say you have B&co and 3 others to compare for each set
copy the formulas i gave above from column E to H next to the first B&co in your sheet
if the first B&co is in B2 then the formulas go in E2 to H2
then select E2 to H5 and at the bottom corner of H5, when you hover your mouse there it should show a +, click and hold that and drag it down all the way to your last comparisons.
then filter your sheet by B&co and you should have all the comparisons
if this is something that you do regularly, i'd record a macro for this process, but your best bet is to also consult one of the awesome experts here.....as i said.....my knowledge is very limited.
Bookmarks