Hi,
I am enclosing a test file which is just a small sample of the dataset I actually have to consider.
Since the data set I am working with is large I cant use the application.countif type function.........its just way tooooo slow.
using the enclosed file: what I am trying to calculate is the following:
if I were to use equations in excel they might look like the following:
=countif(
ColN, "Open",
ColF, "Site*",
ColG, H2,
ColX, <= I2,
ColO, > DefnNameTAT)
+
countif(
ColN, "Open",
ColF, "Site*",
ColG, H2,
ColX, =&"All",
ColO, > DefnNameTAT)
Note: DefnNameTAT is a user defnd name and its value is located in M1
I started the macro..........i thought using a scripting dictionary would be helpful.....
I have probably confused someone......if so let me know.
note: i had to keep deleting rows from my input file so that it would make the 1000kB file size requirment.........but i did not go back and update the last row values i put into the macro.
Bookmarks