15th May 2009, 04:17 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,441
|
|
For the purposes of simplicity, I'll explain, but you can record a macro afterwards to make it easy next time.
Data > Sort
By column E Ascending and H Descending
In column I2 =IF(B1&C1<>B2&C2,"favourite","")
Copy formula all the way down Column I
Favourite should be written in Column I for favourite, or blank if it's not.
Then you can Data Filter Autofilter and just select favourites from column I, or use a formula to add them up or whatever.
|