Data filtering

%3CLINGO-SUB%20id%3D%22lingo-sub-2806750%22%20slang%3D%22en-US%22%3EData%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806750%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20excel%20file%20as%20per%20attached%20format%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20filter%20the%20data%20based%20on%20some%20sample%20conditions%20as%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20I%20need%20names%20of%20members%20who%20have%20%3CSTRONG%3ECompleted%3C%2FSTRONG%3E%20the%20course%26nbsp%3B%20%3CSTRONG%3EBusiness%20Process%20Framework%20Fundamentals%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EPassed%3C%2FSTRONG%3E%20the%20exam%26nbsp%3B%3CSTRONG%3EBusiness%20Process%20Framework%20(eTOM)%20Foundation%20Level%20Exam%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E2.%26nbsp%3B%3C%2FSTRONG%3EI%20need%20names%20of%20members%20who%20have%20%3CSTRONG%3Epassed%3C%2FSTRONG%3E%26nbsp%3Bthe%20exam%20%3CSTRONG%3ETM%20Forum%20Open%20API%20Fundamentals%3C%2FSTRONG%3E%26nbsp%3Band%20also%20%3CSTRONG%3EPassed%20%3C%2FSTRONG%3Ethe%20exam%20%3CSTRONG%3ETM%20Forum%20Information%20Framework%20(SID)%20Fundamentals%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2806750%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806822%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1173455%22%20target%3D%22_blank%22%3E%40ramchu2000%3C%2FA%3E%26nbsp%3BPerhaps%20not%20the%20most%20elegant%20way%2C%20but%20I%20believe%20that%20the%20pivot%20tables%20in%20sheets%20PT1%20and%20PT2%20will%20give%20you%20the%20lists%20asked%20for.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2807624%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2807624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1173455%22%20target%3D%22_blank%22%3E%40ramchu2000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPivot%20View%20Completed%20and%20Passed%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1633309225004.png%22%20style%3D%22width%3A%20677px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314707i55AD5AC3EF6AFDD3%2Fimage-dimensions%2F677x425%3Fv%3Dv2%22%20width%3D%22677%22%20height%3D%22425%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1633309225004.png%22%20alt%3D%22Yea_So_0-1633309225004.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1633309438414.png%22%20style%3D%22width%3A%202160px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314708iBA2EA287724A40A2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1633309438414.png%22%20alt%3D%22Yea_So_0-1633309438414.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a excel file as per attached format  

 

I need to filter the data based on some sample conditions as below:

 

1. I need names of members who have Completed the course  Business Process Framework Fundamentals and Passed the exam Business Process Framework (eTOM) Foundation Level Exam

 

2. I need names of members who have passed the exam TM Forum Open API Fundamentals and also Passed the exam TM Forum Information Framework (SID) Fundamentals

2 Replies

@ramchu2000 Perhaps not the most elegant way, but I believe that the pivot tables in sheets PT1 and PT2 will give you the lists asked for. See attached.

@ramchu2000 

 

Pivot View Completed and Passed:

Yea_So_0-1633309225004.png

Yea_So_0-1633309438414.png

 

cheers