Evening guys,
I've got brain freeze, so any help will be greatfully accepted.
In cells DW2-EB2 I have a selection of values of either Y or N.
In cell ED2 I need to put a formula which will result in a Y value if there are two or more Y values in the cells DW2-EB2.
Thanks
Last edited by Cmorgan; 07-02-2012 at 12:40 PM.
Are you looking for...
=IF(COUNTIF(DW2:EB2,"Y")>=2,"Y","")
HTH
Regards, Jeff
Hi. TRY.
=IF(COUNTIF(DW2:EB2,"Y")>=2,"Y","")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks guys.
Thanks for the feedback and we are glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks