Last seen: May 22, 2025
As Phil said, your workbook doesn't seem to match your requirement, but you can multiply by: INDEX(B:B,INT((ROW()-3)/4)+1) which will ...
It looks like you could use: +(IF('Buy and Sell Criteria'!$D$33="",1,'IA Asia Pacific Ex Japan RAW'!$AN$2:$AN$300='Buy and Sell Criteria'!$D$3...
For example: =GETPIVOTDATA("Sum of Total APCs",Sheet1!$B$6,"Maps To","Other","APC Group",LEFT(K11,2)+0,"APC Group Name","Emergency Services","Month...
I'd guess it's taking longer than the 30s you specified for a timeout. I get Found when I run it.
Change the declarations section to: #If VBA7 Then Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Public Declar...
I'd have guessed the 0s were in column F, so: =AVERAGEIFS(F$4:F$158,$E$4:$E$158,$C160,F$4:F$158,"<>0")
Assuming the cell A1 just contains North America, or Latin America, you can use: =GETPIVOTDATA("[Measures].[Unit Qty]",'a) EGI '!$A$9,"[WW Det...
The basic gist is: =MIN(sales,1000)*50+MAX(0,sales-1000)*100
Prime(i) will return True if the number i is prime. In VBA true is equivalent to -1 and False is equivalent to 0, so subtracting the result of the Pri...
Do you want any manual change to increase the version number by 1 and update the date to the current date? If so, open the VB Editor (Alt+f11), locate...
Try this: =SUMPRODUCT(('Planning congés_2019'!$C$16:$C$40=$A4)*('Planning congés_2019'!$D$16:$D$40=$B4)*(TEXT('Planning congés_2019'!$L$15:$NL...
Since your last two criteria are just returning "", all you need is this: =IF(B8<'Fill up & Results'!$B$15;IF(H9<2300; 64/H9;IF(H9&g...
Can you post a sample workbook? It may be possible to do what you want with a consolidation range pivot table, if you can't download Power Query or Po...
As a matter of interest, why are capital letters important? SUMIF(S) wouldn't care about case.
Why have you used IFS in every cell? IFS is not particularly efficient as it evaluates all the criteria expressions and all the value expressions no m...