Forum Discussion
Common entry
Dear Experts, I need to prepare a list of rnti's in column "N" ( a parameter say) which is common in all these 4 Tables, may be with XMATCH , or any other formulae.. ...
In your example, there are no common values, but if there were, they would be returned by
=FILTER(Table7[rnti-BIP], COUNTIF(Table1[[CRNTI]:[CRNTI3]], Table7[rnti-BIP])*COUNTIF(Table4[rnti-UL-TTI], Table7[rnti-BIP])*COUNTIF(Table5[rnti-DL-TTI], Table7[rnti-BIP]), "")
Thanks HansVogelaar it really helps, once you have some bandwidth , can you please share one more logic /Formula apart form the Filter function..
Thanks & Regards
Anupam Shrivastava
HiHansVogelaar seems a bit Lengthy..
A formula avoiding FILTER would probably be much longer...