Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-21-2015, 01:53 AM
troggot troggot is offline I can do it but I don't know why Windows 7 64bit I can do it but I don't know why Office 2010 64bit
Novice
I can do it but I don't know why
 
Join Date: Oct 2015
Posts: 2
troggot is on a distinguished road
Default I can do it but I don't know why

Hi!



This seems to be repeating topic in my tech life as an engineer, I do things but no idea how.

So my problem is the simplest I guess. How to compare 2 columns and see if there are common values.

I have even resolved somehow by cutting&pasting from here and there and changing values randomly. But I have not understood the sintax of this formula:

=INDEX($A$1:$A$12, SMALL(IF(COUNTIF($B$1:$B$12, $A$1:$A$12), ROW($A$1:$A$12)-MIN(ROW($A$1:$A$12))+1, ""), ROW(A1)))

Would any one be able to describe me in layman terms what I have done?

I add a pic of the result.

Additional question would be: Is there a way to have the number of occurrences rather than the string repeated in column C?
The fact that I don't understand the sintax is not helping me to be flexible enough to change it.

Also, is all that mess really needed?
In the beginning I was looking in this area:

=IF(ISERROR(MATCH(A1:A210,$B$1:$B$33,0)),"",A1)

or

=IFERROR(IF(VLOOKUP(B1,$A:$A,1,FALSE)=B1,"x"),"")



But I have not been able to make it work. Of course because basically I don't understand what I am doing.

Many thanks!
Attached Images
File Type: jpg eureka.jpg (137.0 KB, 36 views)
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 04:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft