Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check if a time is past a certain time | Excel Discussion (Misc queries) | |||
Time check | Excel Discussion (Misc queries) | |||
How do I set up a column in Excel as a check mark column? | Excel Discussion (Misc queries) | |||
how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
How do I Make a column in excel a check box column | Excel Discussion (Misc queries) |