LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default How to check the whole column at the same time?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check if a time is past a certain time Savio Excel Discussion (Misc queries) 3 January 31st 09 10:21 PM
Time check Finks Excel Discussion (Misc queries) 4 May 4th 07 07:10 AM
How do I set up a column in Excel as a check mark column? wrsstevens Excel Discussion (Misc queries) 7 April 10th 07 07:12 PM
how to check for recurrence of same names in column 1 and column JillyB Excel Discussion (Misc queries) 1 January 30th 07 02:11 PM
How do I Make a column in excel a check box column Marie Excel Discussion (Misc queries) 0 November 10th 06 10:42 PM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"