Hi All, I have an excel sheet containing a few columns, one column contains details which are duplicate and another columns
contains values, all i want to do is pick the unique records with minimum values and highlight them. I tried to do
conditional formating, but after sort option it showed highlights for the new rows. I mean the formating stayed but I moved
the values. I'll try to explain it on below example:
Let's take two columns. Column A displays some items from a
several producents. Column B contains prices. Let's say there are 200 products from 50 sellers. I need to find 200 minimum
Column A Column B
I have 10k rows and doing this by hand it takes a lot of time.
I want to have highlighted in Column B prices £3,40 the cheapest price for abc product and £4,05 the cheapest def.
It's about 200 minimum prices.
So the price must dependent on details based in Column A.
That was the first part, more important.
next thing: i would like to have attached notes or comment to highlighted cells with all the information from four Columns,
Cell B2 - highlighted £3,40 and attached note "A1,C1,D1,E1".
Cell B6 - highlighted £4,05 and ...
If anybody knows how to do it please let me know.