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 |
All times are GMT +1. The time now is 01:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com