| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically fill in third column depending on data in second column
I have a large list of data concerning events that happened in 2004.
Each event is either designated IR or Non-IR. I wish to create a macro that would allow me to automatically find keywords and automatically fill in the third column. For example, if the second column's data has the word "Investor" in the cell, the third column will automatically populate with the word "IR" The way I do it manually is to search the word "investor" and fill in the data myself in the third column. It's terribly inefficient, and any help would be great. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically fill in third column depending on data in second col
In C1 enter:
=IF(B1="investor","IR","") and copy down -- Gary''s Student - gsnu200720 "J.J." wrote: I have a large list of data concerning events that happened in 2004. Each event is either designated IR or Non-IR. I wish to create a macro that would allow me to automatically find keywords and automatically fill in the third column. For example, if the second column's data has the word "Investor" in the cell, the third column will automatically populate with the word "IR" The way I do it manually is to search the word "investor" and fill in the data myself in the third column. It's terribly inefficient, and any help would be great. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically fill in third column depending on data in second col
This doesn't meet my needs, sorry. Thanks though.
On May 11, 12:08 pm, Gary''s Student wrote: In C1 enter: =IF(B1="investor","IR","") and copy down -- Gary''s Student - gsnu200720 "J.J." wrote: I have a large list of data concerning events that happened in 2004. Each event is either designated IR or Non-IR. I wish to create a macro that would allow me to automatically find keywords and automatically fill in the third column. For example, if the second column's data has the word "Investor" in the cell, the third column will automatically populate with the word "IR" The way I do it manually is to search the word "investor" and fill in the data myself in the third column. It's terribly inefficient, and any help would be great. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically fill following cells depending on one cell. | Excel Discussion (Misc queries) | |||
| can you automatically size text to fill a column? | Excel Discussion (Misc queries) | |||
| Create a date column (MM/DD/YY) that fill sout automatically? | Excel Worksheet Functions | |||
| splitting one column into rows depending on the data in the column | Excel Programming | |||
| How to automatically fill a column? | New Users to Excel | |||
Linear Mode
