Thread
:
Show it here, if it exists there
View Single Post
#
4
Posted to microsoft.public.excel.misc
Kevin
external usenet poster
Posts: 26
Show it here, if it exists there
Sandy Mann,
Thanks, that works perfectly.
-Kevin
"Sandy Mann" wrote in message
...
Try:
=IF(COUNTIF(Sheet1!C:C,8),8,"")
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Kevin" wrote in message
...
Dear NG:
I have a list of different numbers in column C of page 1.
I would like Excel to search that list for a certain number
and if it exists anywhere in that column, then display it in
column A of Page 2
The IF function seems to only search one row in column C of page 1
(The same row that I enter the formula in on page 2)
I need it to search the entire column for the specific number.
I hope I've supplied enough information.
Thanks for any assistance.
-Kevin
Reply With Quote
Kevin
View Public Profile
Find all posts by Kevin