Hi All,
I have the following formula, which basically looks up the name and plots the different lines into certain cells on another spreadsheet.
what I would like it now to do, is to miss out any jobs where it is indicated in the Next Service Type as a Mini.
I have attached an example of the sheet for you to see what i'm needing.
thanks in advanc efor your help
Cheers
donna
Bookmarks