marshalxxl
New Member
- Joined
- Nov 17, 2018
- Messages
- 12
Hello can somebody help me whit this:
I need a data criteria for : When i search in column AF the filter to copy from column AO TO COLUMN CP ( AO,AP,AQ,AR ETC) only the filled cells and for AO to modify the text to "#" and then to export only the last letters as you can see in this example (blue circle i want to be the output from my search in COLUMN AF and variants from filled columns from AO to CP):
EXAMPLE 1: https://imgur.com/a/mgRYO5V
example 2 : https://imgur.com/a/EXWww31
Note that in my list i can have duplicates but i need them only once.
I need this beacause we use this at work and we have thousands of different variants and when we type them sometimes we forget to add some of them
I need a data criteria for : When i search in column AF the filter to copy from column AO TO COLUMN CP ( AO,AP,AQ,AR ETC) only the filled cells and for AO to modify the text to "#" and then to export only the last letters as you can see in this example (blue circle i want to be the output from my search in COLUMN AF and variants from filled columns from AO to CP):
EXAMPLE 1: https://imgur.com/a/mgRYO5V
example 2 : https://imgur.com/a/EXWww31
Note that in my list i can have duplicates but i need them only once.
I need this beacause we use this at work and we have thousands of different variants and when we type them sometimes we forget to add some of them
