Thanks, but I am not able to add any more columns to the worksheet, only
extract data from it(v.important), so I need to filter one column then
by another different column.

example:
column 1 - list of colours
column 2 - list of flowers

count number of red roses
count number of red tulips
count number of blue roses
count number of blue tulips

Please help, I am stumped given the complicated nature of my formulas!


--
TISSMOD
------------------------------------------------------------------------
TISSMOD's Profile: http://www.excelforum.com/member.php...o&userid=30830
View this thread: http://www.excelforum.com/showthread...hreadid=504931