=IF(A1="Y",5,0)

--
HTH

Bob Phillips

"CJSnet" wrote in message
...
Perfect, thanks.

Also is there a way to say something like 'if A1's value is 'Y' then put
'5'
in A2 but if A1's value is 'N' then put '0' in A2'?
--
Thanks.

CJSnet

(Remove TEETH to reply by e-mail.)

"greg7468" wrote
in
message ...

Hi,
click on the header of the column with the data you want to filter (the
one with the 0000 in)
Go to Data Filter Autofilter

Now click on the dropdown arrow in the header and choose custom

From there you have several options to filter for data you want or
filter out data you do not.

If you filter the data to show what you do not want, you can then
delete those rows.

HTH,

Greg.


--
greg7468
------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread:
http://www.excelforum.com/showthread...hreadid=374220