hi,
is there a formula that can search an entire excel sheet and return a value? eg. I have "apple" 17 times on my sheet so in a separate column i ask to search the sheet and the return would be 17.
thanks in advance
hi,
is there a formula that can search an entire excel sheet and return a value? eg. I have "apple" 17 times on my sheet so in a separate column i ask to search the sheet and the return would be 17.
thanks in advance
Last edited by Junior4; 11-24-2010 at 03:21 PM.
Hi,
If you literally mean the whole sheet you'll need to put the formula on a second sheet otherwise you'll get a circular formula. However if it's less than one sheet and just say columns A:Z just use
=COUNTIF(A:Z,"apple")
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
went with the two sheet idea and it works..thanks much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks