I am new to Advanced Excel functions and appreciate any need help with a
project. I have 2 sheets that need to be compared. Both sheets only consist
of 2 columns labeled ISBN and COST. Some data will be unique to each sheet,
while other ISBN data is not. When a match of the ISBN (column 1) is found
in both sheets, I need to then compare the COST of that ISBN on each sheet
and I would like the cheaper COST's row deleted. I could also have the
output onto a new sheet of the unique ISBN and its COST, without duplicates.
Ive been studying for days on creating a complicated function and am just
not getting anywhere, even though I have learned some other useful functions.
TIA .