millhouse123
Active Member
- Joined
- Aug 22, 2006
- Messages
- 335
How would I create the following formula in power query? I understand how to do a basic conditional formula but I am stuck on the part of the formula that looks at all rows above the current row. So basically the sumproduct part of this formula is where I need help.
Thanks in advance.
=IF(F2="Last Requirements",(IF(SUMPRODUCT(($B$2:$B2=B2)*($F$2:$F2=F2))>1,0,1)),0)
Thanks in advance.
=IF(F2="Last Requirements",(IF(SUMPRODUCT(($B$2:$B2=B2)*($F$2:$F2=F2))>1,0,1)),0)