Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Nov 07, 2024

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 something like Col-J and K, for the rnti's with their corresponding numOfPrbs in a single column.

Thanks in Advance,

Br,

Anupam

Excel
Formulas and Functions
Power BI
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Nov 07, 2024

    Try the following formula-

    =TOCOL(HSTACK(FILTER(Table3[numOfPrb-1],Table3[rnti-1]=J1),FILTER(Table3[numOfPrb-2],Table3[rnti-2]=J1)),3)

     

  • anupambit1797's avatar
    anupambit1797
    Iron Contributor
    Nov 07, 2024

    Hi , may I also request to share the same solution by Python in Excel?

    I tried to do something like this, but getting err like "AttributeError"

     

    Thanks & Regards

    Anupam

Resources