Heather,

This any good?

=COUNTIF(A:A,1)+COUNTIF(A:A,"1"&CHAR(10)&"*")+COUN TIF(A:A,"*"&CHAR(10)&"1")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"peacelittleone"
<peacelittleone.1rgmeo_1120169190.0972@excelforu m-nospam.com wrote in
message news:peacelittleone.1rgmeo_1120169190.0972@excelfo rum-nospam.com...

I have the following in column A :

A
1
2
3 4
3 4 5
3
4
5
1 3


How do I find out if the number 1 is found in Column A. Column A
contains either a single entry or multiple entries separated by
"ALT+Enter" (Chr(10)).

I don't care if it is there more than once, only if it is there at
all.

Any suggestions?

TIA

Heather.


--
peacelittleone


------------------------------------------------------------------------
peacelittleone's Profile:
http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=383726