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.

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.

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.