Hello all. I am trying to find the function or the code to return a "yes" in a cell if any type of data is entered in more than 1 specified column in a row. An example is attached
Any feedback would be most appreciated! Thanks!
Hello all. I am trying to find the function or the code to return a "yes" in a cell if any type of data is entered in more than 1 specified column in a row. An example is attached
Any feedback would be most appreciated! Thanks!
Last edited by wvpersephone13; 05-27-2011 at 10:26 AM. Reason: Attached Sample
Hi,
It's much easier to upload a sample workbook than try and replicate the layout in your post and often helps anyone trying to answer your question.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi and welcome to the board
That is why you always can upload a sample sheet - Click Go advanced on yoiur original post and clck the paperclip**It's messing up my columns when I actually post this question but hopefully it gives you an idea of what I'mlooking for.**
I've attached a Sample Sheet -thanks!!
Perhaps =IF(COUNTA(A2:C2)>1,"yes","no")
Pull down as needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks