View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] khuon@insightbb.com is offline
external usenet poster
 
Posts: 3
Default Conditional Row Delete

Review many postings on conditional row delete but still need help. I
want to delete all rows where there are fewer than 5 companies within
industry. The median within that industry is not very useful if there
are less than 5, or some other number, of companies.

Company SIC Code Sales

If frequency of SIC code is less than 5, then delete the row.

Please help.