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. |
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. |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com