Forum Discussion
What Assets have been service but not on the schedule?
Hi, I hope you can help please. i have two excel spread sheets, DATA1 and DATA2. DATA1 shows a service schedule for a set of ASSETS which are being serviced for three different SITES. DATA2 shows ...
Here is an example file as far as I understand it.
Method:
First open a new column in DATA1 and enter this formula:
=IF(AND(COUNTIFS(DATA2!$B:$B, $A2, DATA2!$A:$A, "<>"&$B2)>0, $C2=""), "Serviced, Not Scheduled", "")
Then from D2 selected all cells below and opened a new rule in conditional formatting and enter this formula:
=D2<>""
In the sample file you can see how it is structured.
I hope that I understood the task correctly and that it helps you.