Thread: How to check the whole column at the same time?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
AltaEgo AltaEgo is offline
external usenet poster
  
Posts: 245
Default How to check the whole column at the same time?
Please limit your question to one newsgroup

--
Steve

"tlee" wrote in message
...
Hi all,

Could anyone help me how to check the column content by different
condition?

If the content of the cell is "Father" then replace it to "1" in the same
column.
If the content of the other cell is "Mother" then replace it to "2" in
same column.
If the content of another cell is "Sister" then replace it to "3" in the
same column.

Besides, how can I implement this checking by using Marco?

Thanks,
Tlee

Reply With QuoteReply With Quote