Thread: How to auto add data based on value in another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AlanMB AlanMB is offline
external usenet poster
  
Posts: 3
Default How to auto add data based on value in another column
Hi, I want to automatically add data in a column depending on the value of
data in another column. For example, if column one has a value of 1,3,9 or 12
then a value of 1 is automatically entered in column 2; if column one has a
value of 2,4,7,8 or 11 then a value of 2 is automatically entered in column
2.... and so on. Thanks.
Reply With QuoteReply With Quote