Thread: Less than 10
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Coady Matthew Coady is offline
external usenet poster
 
Posts: 3
Default Less than 10

In column A I have a numbers, 57, 86, 92. In column B I want the digits
greater than 10 from column A, so column B would look like 50, 80, 90. In
column C I want everything less than 10 from column A, so column C would be
7, 6, 2.