Search
Search titles only
By:
Search titles only
By:
Forums
New posts
Search forums
What's new
New posts
Latest activity
Feedback
View Statistics
Members
Current visitors
Buy Sell Trade
WTB
Log in
Register
Search
Search titles only
By:
Search titles only
By:
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Forums
Technology
Computer Software
Microsoft Excel - Data Matching Help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="nihit" data-source="post: 1247443" data-attributes="member: 33879"><p>assuming you want to check col A with col C, </p><p></p><p>Use formula =IF(ISERROR(MATCH(A1,C:C,0)),"Not Present", "Present") in B1 and drag down..</p><p></p><p>This will check if value present in cell of col A of current row, is present anywhere in col C or not..</p></blockquote><p></p>
[QUOTE="nihit, post: 1247443, member: 33879"] assuming you want to check col A with col C, Use formula =IF(ISERROR(MATCH(A1,C:C,0)),"Not Present", "Present") in B1 and drag down.. This will check if value present in cell of col A of current row, is present anywhere in col C or not.. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Technology
Computer Software
Microsoft Excel - Data Matching Help
Top
Bottom