wos

Hi All, I know this is a big ask, but I'm really having trouble evaluating a formula to determine where an error is. The formula is returning 4.5 which is the value in AQ10, but it should return a 7.5 which is the value in DashboardH8. Here is the formula...

Hi, This code should return the value in AQ10, but for some reason I'm getting a #VALUE error. =IF(AND(VLOOKUP(A10,'WOs (DSP Only)'!A:B,2,FALSE)=VLOOKUP(A10,'WOs (DSP Only)'!A:C,3,FALSE)=VLOOKUP(A10,'WOs (DSP Only)'!A:D,4,FALSE)=VLOOKUP(A10,'WOs (DSP Only)'!A:E,5,FALSE)=VLOOKUP(A10,'WOs (DSP...

Hi, I'm trying to rearrange my if statement and I'm getting lost in it... Here's the code broken apart: =IF(OR(F6="Y",AN6<=6),AQ6, IF(AND(O6="N",SEARCH("Comp",D6),LEFT(D6,2)+0>24,AQ6>=7.5),AQ6, IF(AND(O6="N",SEARCH("Comp",D6),LEFT(D6,2)+0>24), IF(OR(AND(VLOOKUP(A6,'WOs (DSP...

Hi, I'm trying to write some VBA code (and it's been awhile) to do the following: I have a tab called 'WOs' and another tab called 'WOs (DSP Only)'. I'm trying to first filter on the 'WOs' tab on column P to select only "DSP" and "REC". Then I'd like to copy all data on the 'WOs' tab and...

I have a Pivot table that looks like below. I need to conditional format just the WOS row to highlight cells that are less than 0 in red, 0.1 to 1.5 in yellow and anything above 1.5 in green. The pivot must keep the formatting when I move the pivot fields around. I have made various attempts on...