LinkBack URL
About LinkBacks
Hi, I have column E with Random True & False in it
like this
COLUMN E
TRUE
TRUE
FALSE
TRUE
FALSE
TRUE
TRUE
TRUE
TRUE
FALSE
FALSE
FALSE
please
I want macro that would go to cell that two false back to back
Thanks
Hi, I have column E with Random True & False in it
like this
COLUMN E
TRUE
TRUE
FALSE
TRUE
FALSE
TRUE
TRUE
TRUE
TRUE
FALSE
FALSE
FALSE
please
I want macro that would go to cell that two false back to back
Thanks
assuming your data starts in E1, try this formula in F2....
=if(and(E1="FALSE",E2="FALSE"),"Two Falses","")
Let me know if that is what you need?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
And why not this three?
COLUMN E
TRUE
TRUE
FALSE
TRUE
FALSE
TRUE
TRUE
TRUE
TRUE
FALSE
FALSE
FALSE
whatever try this
Please Login or Register to view this content.
Last edited by tom1977; 04-20-2012 at 04:39 PM.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks