Hi guys, I want to compare 2 dynamic lists and get their similar (matching) values count.
I have 2 lists. List A and List B.
List A is values created by admin & List B is values inserted by users. I want the count of those matching values (without intersecting).
Below is an example of what i want to achieve,
Here are 2 lists having different number of values.
Matching items count= 6
I just want this count. (Here item# number (index) should be same in both lists, I don’t want count of matching values intersecting with different index items)
Anybody know how to achieve this kindly help.
Thanks in advance.
Hey @ankur1 , do you have any suggestions for this?
This is just off the top of my head, try RepeatingGroup A’s list of things:intersects with RepeatingGroup B’s things:count
That should work as long as both are the same thing like a number?
Do something like this-
List’A unique value intersect with List’B Unique Value Count
I am able to match values by calling them in 2 different RG’s. If matched formatted as 1, if didnt matched formatted as 0.
by using this expression:
so I got the matching numbers as desired:
in above example, if you sum all matched items, matched items count is 3.
But, I am not able to get that (sum) count. Everything is in RG, I cant use current cells index outside RG, and i cant use > or + inside RG, to count total matched items. I also tried possibility of setting CS, but couldnt.
How can i get that matched items count?
Did you figure it out ?
This topic was automatically closed after 70 days. New replies are no longer allowed.