How to find out in first column Cell A1 - R100 ,B1- Match, Cell A2 - R100 , B2 - Not Match Cell A3- R200, B3 - Not Match Cell A4 R300, B4 - Not match Cell A5 R300,B5 - Not match How to find out only Not match result by formula when there all results are not match only
Some very good tips here - thanks. I particularly like the deconstructing formulas section.
I'm really glad you liked it!
Props to Wayne Edmondson for introducing me to some of the keyboard shortcuts here!
Excellent. Thank you for making the effort to show us how you tackle understanding other people's formulas. I definitely need to do this!
CTRL Bracket Wicked Tip!Awesome Tutorial Thank You Sir :):)
You're very welcome! I gotta give the props for this one to Wayne Edmondson a few months back - always learning something new)
Absolutely brilliant! Subscribed.
Great stuff.
You explained this very well. But I was hoping you would go into how to trace error.
Nice! Thanks!!
Super duper!
How to find out in first column Cell A1 - R100 ,B1- Match,
Cell A2 - R100 , B2 - Not Match
Cell A3- R200, B3 - Not Match
Cell A4 R300, B4 - Not match
Cell A5 R300,B5 - Not match
How to find out only Not match result by formula when there all results are not match only