Scenarios

10/24/2015:

• Compare excel ideas in two excel files, list down the ideas that are not common.

Solution1: You could copy the data of columns into  one sheet and apply Vlookup/Index(),Mattch() in 3rd column, with True/False status.

 - How to loop in excel without VBA or macros?

Source: http://stackoverflow.com/questions/4939537/how-to-loop-in-excel-without-vba-or-macros

• Find min/max values in a column among those matched from another column

http://stackoverflow.com/questions/20904092/excel-find-min-max-values-in-a-column-among-those-matched-from-another-column

for min:

=MIN(IF(($A$1:$A$50=D1),($B$1:$B$50)))

for max:

=MAX(IF(($A$1:$A$50=D1),($B$1:$B$50)))