Hi guys
Trying to get a formula to work, and failing....again!
So I've got this far and can't understand why its not working, did tests as I went along, but now it's coming up with a result of '0' Dunno why?
The Formula is as follows
I haven't started on the formula for the Job # cells yet but if you could point me in the right direction I would greatly appreciate it.
heres a pic of the spreadsheet.
Kind Regards
Nile
Trying to get a formula to work, and failing....again!
So I've got this far and can't understand why its not working, did tests as I went along, but now it's coming up with a result of '0' Dunno why?
The Formula is as follows
Excel Formula:
=IF(AND(MATCH(C5,[Quote '#],0),([Customer Name]=C6)),MAX([Customer '#]),MAX([Customer '#])+1)
I haven't started on the formula for the Job # cells yet but if you could point me in the right direction I would greatly appreciate it.
heres a pic of the spreadsheet.
Kind Regards
Nile