Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I update Column #1 based on specific value of column #2?
I am trying to update an entire column (col #1) based upon specific values in
col. #2. Column #1 has random entries, no range and no sorted order. For example, 30, 365 & 1095 = 03; N/A or 0 = 10. |
#2
|
|||
|
|||
I would highly recommend providing an example of one line which would have
this replacement, as it is difficult to understand what you're looking for. -- Boris "SLH" wrote: I am trying to update an entire column (col #1) based upon specific values in col. #2. Column #1 has random entries, no range and no sorted order. For example, 30, 365 & 1095 = 03; N/A or 0 = 10. |
#3
|
|||
|
|||
I found the answer before seeing that my post was poorly worded. Thanks.
"BorisS" wrote: I would highly recommend providing an example of one line which would have this replacement, as it is difficult to understand what you're looking for. -- Boris "SLH" wrote: I am trying to update an entire column (col #1) based upon specific values in col. #2. Column #1 has random entries, no range and no sorted order. For example, 30, 365 & 1095 = 03; N/A or 0 = 10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Choose data from a particular column based on a specific value | Excel Worksheet Functions | |||
Count cells based on date range in another column | New Users to Excel | |||
Hide column based on data value | Excel Discussion (Misc queries) | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |