I am working on a file and decided that I need to show in a specific cell (let's say, G10) if there are two adjacent cells in a row in columns D and E that have specific values, e.g. "Text1" in col. D and "Text2" in col. E. The code should show a message like "Cells detected" in G10 if that situation occurs. How do I set up such a code?
Very unclear but as a beginner starter :
PHP Code:If Join(Application.Index([D10:E10].Value2, 1, 0)) = "Text1 Text2" Then MsgBox "Detected in row #10", vbInformation
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
Sorry, not sure how to apply that code? The attached is an example of what I want to do - if there are any adjacent cells in the same row in columns A and B containing "Text1" and "Text2" (row 4 in the file), then there should be a message in cell C1 saying "Values found".
Ok in fact for this no needs any code but just an Excel basics : a SUMPRODUCT worksheet formula …
Maybe:
=IF(SUMPRODUCT(($A$2:$A$5="Text1")*($B$2:$B$5="Text2"))>0,"Values Found","")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks