User Profile
dscheikey
Bronze Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Getting the Most Filled Out Cells to the Top - Sort and Filter
nikkim45 I thought that if you added the additional column to your table, you would be able to filter and sort with it. To be able to help you better, I need more information. Maybe you can upload a document with sample data here. There is a field under the text field where you can store files.Re: Determine training compliance with IF/IFS function(s)
It would be helpful if you could write down what result you expect in the individual columns for the Compliance column and explain why this is the case. You have described 4 training levels in the rows. However, only level 3 can be found in the columns. Is level 4 the eLearning?Re: Summing all previous numbers with criteria
J-Des000 I have a solution, but I don't know if there is an easier way. Spilled Formula: =LET(a,OFFSET(A1,0,0,1,SEQUENCE(1,5)),b,OFFSET(A2,0,0,1,SEQUENCE(1,5)),IF(A1:E1=F6,SUMIF(a,F6,b),"n/a")) Whithout Spilling: =IF(A1=$F4,SUMIF($A1:A1,$F4,$A2:A2),"n/a") See also my enclosed example!Re: I'm looking for Excel Formula to pull Average Weekly Sales before and after an event.
LouRicchiuti Have a look at my enclosed example file. I have developed the 4 different formulas. Here is the example of 1-4 Weeks After Cousure: =ROUND(AVERAGE(FILTER($E6:$AF6,(DATEVALUE(RIGHT($E$5:$AF$5,8))>$D6+7-WEEKDAY($D6,12))*(DATEVALUE(RIGHT($E$5:$AF$5,8))<$D6+7-WEEKDAY($D6,12)+28))),2) I did not work with AVERAGEIFS() because a help line for the date would have been necessary here. So I used AVERAGE() in FILTER(). Update: BYCOL() was not necessary! I have adjusted the formulas again.Re: I'm looking for Excel Formula to pull Average Weekly Sales before and after an event.
LouRicchiuti Hi Lou, I think you should urgently upload a sample document here. The formula you need must be adapted to your requirements. I think you need AVERAGEIF(). 4 weeks are current date - 28 and 5 weeks +35. It is also unclear which date format you are using. m/d or d/m? Without an example it will be difficult to help.Re: Filter a table using value selected in a list and filtering another table using the filtered values
anujkhator Hello, I have solved your task with FILTER() within FILTER(). There is probably another way. =FILTER(Table1,ISNUMBER(XMATCH(Table1[TenderID],FILTER(Table2[TenderID],OFFSET(E11,1,XMATCH(J11,Table2[#Headers])-1,4)="Yes")))) Please also see my attached file.
