Thread: Search an array of sheets for an array of numbers & return count of numbers
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Search an array of sheets for an array of numbers & return count of numbers
Hi again,

Am Tue, 13 May 2014 12:41:57 +0200 schrieb Claus Busch:

or write in B2 of Sheet1:
=SUM(COUNTIF(INDIRECT("Sheet"&ROW($2:$6)&"!1:10000 "),A2))
and enter the formula with CTRL+Shift+Enter and copy down

and in C2:
=IFERROR("Sheet"&SMALL(IF(COUNTIF(INDIRECT("Sheet" &ROW($2:$6)&"!1:10000"),$A2),ROW($2:$6)),COLUMN(A1 )),"")
and enter the formula with CTRL+Shift+Enter and copy down and to the
right till cells remain empty


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote