tweak

I have this code which works, but I need to finesse it; Sub filtersheets() Dim xWs As Worksheet On Error Resume Next For Each xWs In Worksheets xWs.Range("b4").AutoFilter 2, Sheets("total").Range("C1") Next End Sub What I want to change; - if C1 contains "ALL" it unfilters - any change to...

Is there a way I can tweak this formula so it looks at both the teacher and the subject? I've tried adding AND, adding IF (sub=$a4... at the beginning of the formula but doesn't quite work. {=IFERROR(INDEX(Cls,SMALL(IF(Teach=Sheet4!$FV4,ROW(Teach)-ROW(INDEX(Teach,1,1))+1),1)),"")} All help...

I have a formula using SUMIFS function to get a total sales amount based on three criteria from a different master workbook. It works only when the master workbook is open otherwise it gives me an error "#VALUE". Is there any tweak to make this formula works even if the master workbook is not...

Hey All, I thought this was an easy tweak, but apparently not so, atleast for me. Must have something to do with how excel is dealing with thearray formula, so hopefully someone else has a better understanding. This is my current formula...

Hello all, I have posted here before and you all have been really great in helping me out. I have a spreadsheet dashboard that I am trying to tweak. in one of the cells I have the following formula: =AVERAGEIFS('DAILY VALUES'!I2:I5200,'DAILY VALUES'!A2:A5200,">="&MAX(IF('DAILY...

Currently, I have the following formula which is working perfectly... =INDEX('Sheet2'!A:CG,MATCH($A$89,'Sheet2!$C:$C,0),MATCH('Sheet1 '!$G$89,'Std Values'!1:1,0) Now the only problem, is if the output from this above formula returns zero, I would need the next value in that particular row...

Hi all! In excel I have created a standard order template that should be used to create standard read-in files. I have managed to set up the standard read-in file with VBA, but I am stuck on one of the steps that must be taken in the preparation of the data. Sample: https://ibb.co/dh48uH...

Hi, Good Morning! Need you assistance to tweak this formula to work. Formula in CELL B8...

Ok I have a column of dates and in cell A9 my formula reads as follows EOMONTH(A8,1). A8 has the date 11/30/2016 and the formula is bringing back 12/31/2016, but the last day of December in 2016 was 12/29/2016. Is there a way to tweak my formula to bring back the correct day end of the month...