Hi Folks,
Thanks to all of you for your assistance. I have not made my problem
clear... sorry.
I have a named area of cells (C2:C272 and D2:d272) called JOINED. This
contains two columns, one with dates (formatted to date) and one column
of strings.
I have two list boxes. Both contain the date column information.
These are located at F272 and F273.
So, when a user selects the From date (F272) and the To date (F273), I
want to return how many strings containing "INT" (or "SYS" etc) there
are in the JOINED columns between the chosen dates. I then use this
result for a graph.
I hope this is clearer.
Thanks again for you help,
Colin:)
--
colin_b
------------------------------------------------------------------------
colin_b's Profile:
http://www.excelforum.com/member.php...o&userid=36106
View this thread:
http://www.excelforum.com/showthread...hreadid=558799