Hi all

Another little bit for me to Learn.
I have a date Sheet arranged in Daily Single Columns. each row has a piece
of information about that days activity. ie c3 = USA, d3 = USA,e3 = canada.

on a seperate work sheet i only want to pick out the USA entries and not the
canadian entries with the basis of the following
=IF(INDIRECT("'Date Details'!"&ADDRESS(3,(INT(ROW()/7-53)+3)))="usa",(?),(?)

How can i Get the sperate worksheet only the details of THE usa Columms

This has to appear in a List Format .ie

12/3/2008 HOTEL usa
lINE oNE ADDRES
Line 2 Address
ETC

Thanks For Looking

Stew

How can i Get the sperate worksheet only the details of THE usa Columms