Alan,

If A1 contained "Depth" it would be discarded anyway, I think, because we'll
only be taking Depth rows that immediately follow a location row.
--
Earl Kiosterud
www.smokeylake.com

"Alan Beban" wrote in message
...
Tom Ogilvy wrote:
Your right, thanks for the heads up.

here is the correction

=if(OR(And(A1="location",A2="depth"),A1="Depth")," Keep",#N/A)

This assumes you will never have two sequential rows with depth.

And that A1 does not contain "depth"

Alan Beban