Dear All,
Thanks a lot for helping us previous threads.
I have a result sheet , i want to return true or false cell by cell .
e,g- in result sheet C4 and C5 match then cell C6 TRUE , then D4 and D5 match then result in d6 true if match and false if not match and so on for E4 and E5 upto AG4 and AG5.
Note - Match with formula return value.
Attached sheet...
rgds,
aligahk06
Not that clear.
Based on what youve said you don't need MATCH, this is simply
in C6
=C4=C5
and copy along the row.
Though I suspect there's more to this problem that you haven't explained.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
In the example there are leading blanks
It would be better sorting the source data but
=trim(c4)=trim(c5)
Administrative Note:
Welcome to the forum.
We would love to help you with your query; however, it has been brought to our attention the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly.
Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks