View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Suzanne Suzanne is offline
external usenet poster
 
Posts: 152
Default Help with formula

Thanks -- I was working the formula backward.

Is there any way to do this in data validation? (the number of rows may vary
between 2 and 2,000)

"Gary''s Student" wrote:

=IF(A2="","",IF(A2<A3,"Y","N"))

--
Gary''s Student - gsnu200760