|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add contents of specific cell into next column in range with specific string of characters
I want to be able to put the contents of a specific cell in the cell adjacent to every occurrence of a specific string in a range.
The specific cell whose value is to be added is outside the range selected. Hopefully the attached will illustrate what I wish to do. Thanks in advance |
#2
|
|||
|
|||
You could paste the following formula in D2, then drag it down and over as far as required.
|
#3
|
|||
|
|||
Sorry, I couldn't find the formula, or am I missing something...?
|
#4
|
|||
|
|||
Sorry
=IF(C2="ABC","xyz","") |
#5
|
|||
|
|||
Thanks for that, but I'm afraid I can't get that to work.
I've attached another example spreadsheet which hopefully better explains what I'm trying to do... |
#6
|
|||
|
|||
Solved!
Thanks for your interest, but I found the solution via an online Auto Bot - took some time, but very well worth it!
Apparently it can only be done via a Macro, as Excel only works in one-dimension for certain functions. (Please don't ask me - the Bot suggested that!) I have to say that this was my first experience of interaction with AI (at least as far as I was consciously aware) - great in the right hands. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Deleting specific strings of characters in specific positions | RobiNew | Word VBA | 11 | 11-26-2023 12:59 AM |
Define range within word table between specific text instance and end of cell content | Thom.Simmo | Word VBA | 10 | 03-15-2022 05:28 PM |
Search for specific data in a text string | teligence | Excel | 1 | 05-20-2017 11:51 AM |
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values | bolandk | Excel | 1 | 05-15-2014 08:22 AM |
Search first section for specific string... | donaldadams1951 | Word VBA | 4 | 03-14-2014 11:24 AM |