Forum Discussion
Solved
Filter function
Dear Experts, Greetings! I have a data like below:- Each row has two rnti's (Col-C and Col-D), and their corresponding numofPrb are in Col-F and Col-G, I want to prepare som...
Try the following formula-
=TOCOL(HSTACK(FILTER(Table3[numOfPrb-1],Table3[rnti-1]=J1),FILTER(Table3[numOfPrb-2],Table3[rnti-2]=J1)),3)
Better ask a new question about Python.