Hi hope someone can help. Using the following formula =MAX(B14,D14,F14,H14,J14), but is not really capturing the cost value that I need. I need to capture the cost from the last cell that has a value in it that is not 0, the cost can fluctuate so the MAX does not work.