{=INDEX(data[Qty],SMALL(IF(COUNTIF(data[Qty],data[Qty])=MAX(COUNTIF(data[Qty],data[Qty])), ROW(data[Qty]),""),1))}

For most often purchased item:

{=INDEX(data[Item],SMALL(IF(COUNTIF(data[Item],data[Item])=MAX(COUNTIF(data[Item],data[Item])), ROW(data[Item]),""),1))}

PS Thank you for all your work on this site!

]]>I tried to add the "More than 3 conditional formats for Excel" VBA macro

to my Excel 2008 for Mac and it didn't work. Would this VBA macro work

with Excel 2011 for Mac? Does it have to be a certain version: Student,

Home & Office, or Standard?

Thanks for your help.

Tom

How about my other question ?

extracting the whole Line ?