This content has been marked as final. Show 3 replies
Hi Guys i have the attached scenario and i need a quick solution, i have given the excel example in the attached.
I have a group of records. 1 record has multiple lines identifing the types so the record ID repeats for every Type and Oper see attached.
i want to count the reordID which contains type of F and Oper=0010 which is straight forward
i then want to count the records ID that contains a line where Type =F and Oper=0010 and also contains type =X on any line where Oper>0010.
Any replies/samples would be appreciated