Hi,

I've got a pivot table that has dates on the left, and items tested in the
other columns, however not every item is tested every day leaving blank
cells, how do I continue on the last test number until a new test result is
provided?

Thanks

Ross

I'm not following you.
You lost me when you said "how do I continue on the last test number until a new test result is provided?"