H Hyxt05 New Member Tuesday at 10:37 AM #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 14.9 KB · Views: 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.
AliGW Active Member Tuesday at 10:48 AM #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 15.7 KB · Views: 1
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 Tuesday at 10:57 AM #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 Tuesday at 11:01 AM #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
