Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move column data based on value of another column
Thanks to all who helped me solve my last problem now, I have another.
I have a spreadsheet that has alphanumeric information in column b, and telephone number and the letters y or n (as in yes or no) in column d on the same row. So for instance: column b column c column d column e row1 298784 Y row4 10025 (212)280-4018 (917)596-8194 row7 10019 (212)315-5607 (347)968-9446 row10 11355 (718)463-0674 (212)369-2490 row13 Y row16 10024 (212)799-6026 (631)265-9168 row19 517472 N row22 10024 (212)874-0220 (917)846-0910 row24 10023 (212)874-2356 row26 10025 (212)865-0329 (212)792-4155 row29 547852A1 Y So, here's what I need to do. I need to grab all alphanumeric data off of a row column b, where the value of the same row in column d is equal to y or n and move it one column to the right in column a, all the while keeping it on the same corresponding row. If the value of column d is empty or it has one of those telephone numbers in it, it can ignore it. I would really appreciate it if someone can figure it out. Thanks in advance. Marvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
How do I move data based on a conditional column search? | Excel Programming |