SOLVED

Need help manipulating table for data pull

Copper Contributor

solved thanks so much!

 

 

Capture3.PNG

I have an attachment for the actual workbook, but it doesn't seem to be working for some reason....

Thank you so much!

 

4 Replies
hi,
we love to help you out of this thing, but for that please upload data so we can use it and resolve your problem
best response confirmed by ukfan91 (Copper Contributor)
Solution

@ukfan91 

In E2:

=LET(yes,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"Yes"),no,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"No"),IF(OR(no=0,AND(yes>0,yes<no)),"Yes","No"))

Fill down.

what is the best way to upload an excel document? Do I need to link it/store it online somewhere?

you are a genius! thanks so much

1 best response

Accepted Solutions
best response confirmed by ukfan91 (Copper Contributor)
Solution

@ukfan91 

In E2:

=LET(yes,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"Yes"),no,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"No"),IF(OR(no=0,AND(yes>0,yes<no)),"Yes","No"))

Fill down.

View solution in original post