Forum Discussion
Solved
How to extract data when there are duplicates
I'm using Windows 10 and Excel 365 enterprise. I have a sheet with duplicate entries and I need to copy data from a sheet with matching unique entries and repeat it on each line without having to delete the duplicates. Example attached.
Thanks in advance for any assistance!
- You may simply try this... In C2 =INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0)) and then copy it across and down.
3 Replies
- You may simply try this... In C2 =INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0)) and then copy it across and down.
- Subodh_Tiwari_sktneer Thank you so much for your response. It worked! I knew I had to use INDEX but the formula was tricky.
You're welcome SuzanneLedo! Glad it worked as desired.
