Formulas in Excel Worksheet
Ok. Try this array formula (or if it doesn't work for you send me a copy of
woorkbook to
send.excel <at gmail.com
=COUNTIF(Worksheet3!$I$2:$I$7,""&B2)*($A$2:$A$7=W orksheet3!$A$2:$A$7)
I assumed that you have 7 rows of data, change it in your formula.
|