Hi
if i have tow sheets one have my duplicate items with diffrent prices i have list of items in other sheet without duplicate i want the max price front the name of items what can i do ?
Mak_pj
Hi
if i have tow sheets one have my duplicate items with diffrent prices i have list of items in other sheet without duplicate i want the max price front the name of items what can i do ?
Mak_pj
Use a MAX(IF(... array function.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
the result refer to zero
I think you're going to have to share a little more information otherwise you (but not I) will be here a long, long time.
Post a sample workbook with some typical data.
The formula would look something like:committed with Ctrl-Shift-Enter rather than just EnterFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks