H Hyxt05 New Member Nov 19, 2024 #1 hello team, i was wondering if someone can help me with a formula that will calculate range of values in the table that will arrange number of exits per week and per department. Attachments HELP.xlsx HELP.xlsx 14.9 KB · Views: 4
hello team, i was wondering if someone can help me with a formula that will calculate range of values in the table that will arrange number of exits per week and per department.
AliGW Well-Known Member Nov 19, 2024 #3 If you have 365, in K5 followed by ENTER: =DROP(REDUCE("",J5:J8,LAMBDA(x,y,VSTACK(x,BYCOL(K4:W4,LAMBDA(c,COUNT(FILTER(E5:E130,(F5:F130=y)*(ISOWEEKNUM(E5:E130)=--SUBSTITUTE(c,"W",""))))))))),1) Attachments Hyxt05 HELP(31) CHANDOO SPILL 365 AliGW.xlsx Hyxt05 HELP(31) CHANDOO SPILL 365 AliGW.xlsx 15.7 KB · Views: 5
If you have 365, in K5 followed by ENTER: =DROP(REDUCE("",J5:J8,LAMBDA(x,y,VSTACK(x,BYCOL(K4:W4,LAMBDA(c,COUNT(FILTER(E5:E130,(F5:F130=y)*(ISOWEEKNUM(E5:E130)=--SUBSTITUTE(c,"W",""))))))))),1)
H Hyxt05 New Member Nov 19, 2024 #4 AliGW said: Which version of Excel are you using? Click to expand... I am using Microsoft office 365 ProPlus 2016
AliGW said: Which version of Excel are you using? Click to expand... I am using Microsoft office 365 ProPlus 2016
H Hyxt05 New Member Nov 19, 2024 #6 AliGW said: OK - then my solution will work for you. Click to expand... yeah, it worked. thanks a million
AliGW said: OK - then my solution will work for you. Click to expand... yeah, it worked. thanks a million
