This is making me crazy…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Page 1 <o></o>
(cell “A1” contains the number 1,2,3 or 4)<o></o>
(column “D” contains various names validated in a pull down list found on page 2)<o></o>
<o></o>
Page 2<o></o>
(column “A” is the original named list being used on page 1 as a pull down feature)<o></o>
(column “B” next to each name (found in page 1’s pull down) is counting how many times that name appears in Page 1 column “D”<o></o>
<o></o>
Question:<o></o>
I need a formula for page 2 column “C,D,E,F” that counts how many times each name appears in page 1 column “D” if cell “A1” says either 1 or 2 or 3 or 4.<o></o>
There will be thirty pages in the end, and I want to count them in relation to that cell “A1” criteria first.<o></o>
<o></o>
If cell “A1” says 1 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “C1”<o></o>
If cell “A1” says 2 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “D1”<o></o>
If cell “A1” says 3 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “E1”<o></o>
If cell “A1” says 4 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “F1”<o></o>
<o></o>
One formula will get me started, as I’ll just change the criteria for the 1,2,3, or 4.<o></o>
<o></o>
Thank you,<o></o>
Mark <o></o>
<o></o>
Page 1 <o></o>
(cell “A1” contains the number 1,2,3 or 4)<o></o>
(column “D” contains various names validated in a pull down list found on page 2)<o></o>
<o></o>
Page 2<o></o>
(column “A” is the original named list being used on page 1 as a pull down feature)<o></o>
(column “B” next to each name (found in page 1’s pull down) is counting how many times that name appears in Page 1 column “D”<o></o>
<o></o>
Question:<o></o>
I need a formula for page 2 column “C,D,E,F” that counts how many times each name appears in page 1 column “D” if cell “A1” says either 1 or 2 or 3 or 4.<o></o>
There will be thirty pages in the end, and I want to count them in relation to that cell “A1” criteria first.<o></o>
<o></o>
If cell “A1” says 1 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “C1”<o></o>
If cell “A1” says 2 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “D1”<o></o>
If cell “A1” says 3 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “E1”<o></o>
If cell “A1” says 4 (how many names in page 1, column “D” match a name in page 2, “B1”) formula on page 2, cell “F1”<o></o>
<o></o>
One formula will get me started, as I’ll just change the criteria for the 1,2,3, or 4.<o></o>
<o></o>
Thank you,<o></o>
Mark <o></o>