Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
Hi,
I need help to improve this formula to display multiple instances of the unapproved EOT's. Extension of Times that are not approved. ie....... 'EOT Register'!$O$2:$O$92,0)=0 =IF(COUNTIFS('EOT Register'!$D$2:$D$92,Program!C372,'EOT Register'!$O$2:$O$92,0)=0," ","EOT under review - "&LOOKUP(C373,'EOT Register'!$D$2:$D$92,'EOT Register'!$B$2:$B$92)& " " &LOOKUP(C373,'EOT Register'!$D$2:$D$92,'EOT Register'!$F$2:$F$92 & " " &LOOKUP(C373,'EOT Register'!$D$2:$D$92,'EOT Register'!$H$2:$H$92)&" days")) 'EOT Register'!$B$2:$B$92 - contains a unique number, if thats required. Thanks in advance Primed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming |