M. Saad
asked on
Search and copy the corresponding value from duplicate values into the adjacent cell
Hello
I need your help please in the attached sample file ( original file with data over 100,000 rows)
Column A has many duplicate values and in column S the value is corresponding to this value but its enter only in one cell.
What I want is to copy the value mentioned in column S in front of all corresponding value in column A.
I hope this clear
LIST-1.xlsx
I need your help please in the attached sample file ( original file with data over 100,000 rows)
Column A has many duplicate values and in column S the value is corresponding to this value but its enter only in one cell.
What I want is to copy the value mentioned in column S in front of all corresponding value in column A.
I hope this clear
LIST-1.xlsx
ASKER
sorry, i have attached the sample
copy the value mentioned in column S in front of all correspondingPrepend the S column value to the text in the A column values?
Example:
SMGFB-JS-PM-T-00102A00-GA-E-0060012
SMGFB-JS-PM-T-00102A00-GA-E-0060012
SMGFB-JS-PM-T-00102A00-GA-E-0060012
SMGFB-JS-PM-T-00102A00-GA-E-0060012
Or create a new column A with the column S values?
Example:
New Column A Col.1
SMGFB-JS-PM-T-00102 A00-GA-E-0060012
SMGFB-JS-PM-T-00102 A00-GA-E-0060012
SMGFB-JS-PM-T-00102 A00-GA-E-0060012
SMGFB-JS-PM-T-00102 A00-GA-E-0060012
or something else?
======================
correspondingThese two columns don't seem to share any common data. Are they 'related' by the color coding?
What should happen when there is NO column S data? An example of this condition is in rows 53-60.
ASKER
thanks for your concern, please note that
1- color has nothing to do with the data
2- " What should happen when there is NO column S data? An example of this condition is in rows 53-60." ... nothing should be in the column S.
3 - example for document no from column A " A00-GA-E-0060012" this number start from rows 21-29 but the number "SMGFB-JS-PM-T-00102" is available on row no 26 only.
so i want the code or formula to search for all duplicate no in column A and then search for the value available in column S and then copy this value in the other empty cells in same column S ( so the result will be SMGFB-JS-PM-T-00102 available in all rows from 21-29.)
as you can see in the attached photo , the number highlighted in red is the original input, and the black numbers is what i need to do automatically
Capture.PNG
1- color has nothing to do with the data
2- " What should happen when there is NO column S data? An example of this condition is in rows 53-60." ... nothing should be in the column S.
3 - example for document no from column A " A00-GA-E-0060012" this number start from rows 21-29 but the number "SMGFB-JS-PM-T-00102" is available on row no 26 only.
so i want the code or formula to search for all duplicate no in column A and then search for the value available in column S and then copy this value in the other empty cells in same column S ( so the result will be SMGFB-JS-PM-T-00102 available in all rows from 21-29.)
as you can see in the attached photo , the number highlighted in red is the original input, and the black numbers is what i need to do automatically
Capture.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
dear Mr. Neeraj
many thanks for your support
many thanks for your support
You're welcome!
Posting an example of what you needed was very helpful. It would have saved time and clarification questions.
Kudos to Neeraj for an efficient solution.
Kudos to Neeraj for an efficient solution.
Thanks aikimark!