M
Max
Here's my set-up (book is set to manual calc)
In sheet: Y, in A1:B5, I have data
Area Brch
Zone1 Br10
Zone2 Br11
Zone1 Br12
Zone2 Br13
and in sheet: X, in A1:B3
Area Brch
Zone1 2
Zone2 2
Unique zones are listed in A2 down
In B2, copied down is the formula: =COUNTIF(Y!A:A,A2)
I'm looking for a sub which can auto-write the names of the 2 branches into
the comments over the formula cells B2:B3 (which return the counts of the #
of branches for the zones) when I press F9 to recalc the book. This is to
provide another result dimension to the table in X, so as to speak.
So in the comment for B2 will be:
Br10
Br12
and in the comment for B3 will be:
Br11
Br13
Appreciate insights on how the above could be achieved. Thanks.
In sheet: Y, in A1:B5, I have data
Area Brch
Zone1 Br10
Zone2 Br11
Zone1 Br12
Zone2 Br13
and in sheet: X, in A1:B3
Area Brch
Zone1 2
Zone2 2
Unique zones are listed in A2 down
In B2, copied down is the formula: =COUNTIF(Y!A:A,A2)
I'm looking for a sub which can auto-write the names of the 2 branches into
the comments over the formula cells B2:B3 (which return the counts of the #
of branches for the zones) when I press F9 to recalc the book. This is to
provide another result dimension to the table in X, so as to speak.
So in the comment for B2 will be:
Br10
Br12
and in the comment for B3 will be:
Br11
Br13
Appreciate insights on how the above could be achieved. Thanks.