Indirect function countif
Hi, it's working, but it's looking only in one sheet. Can your code search in
5 sheets? And i need to display "yes" if the code finds a duplicate nr, and
"no" if doesn't find a duplicates.
Can this be done?
Thanks!!!!
"muddan madhu" wrote:
Try this
=COUNTIF(INDIRECT("["&N1&"]"&"Sheet1!$C:$C"),C5)
On Nov 14, 2:56 pm, puiuluipui
wrote:
Hi, i have a number in "C5" and i need to search for this number in another
workbook. I need to search only in column C:C.
But i need an indirect function because the name of book2 will change every
week. I will put in "N1" the name of other workbook.
Can this be done?
Thanks!
.
|