Thread: How to set condition for frequency?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to set condition for frequency?
1. If column B is either text or blank, then apply an AutoFilter to column B
to display only the rows with non-blank entries in column B.

2. Print the range.

3. Remove the AutoFilter
--
Gary's Student
gsnu200712

Reply With QuoteReply With Quote