Forum Discussion
MariusSKG
Mar 07, 2020Copper Contributor
Help needed please : Align duplicates from two columns to same rows in Excel
Hi there, I am in need of help, please. I have found a formula which helps me align the same data in two separate columns which works well: (=IF(ISNA(MATCH(D2,F:F,0)),"",INDEX(F:F,MATCH(D2,F:F,0)))...
- Mar 07, 2020
MariusSKG You're welcome!
MariusSKG
Mar 07, 2020Copper Contributor
Riny_van_Eekelen Hi Riny, THANK YOU for the advice. Would the attached help? If you were able to PLEASE enter the formulas where they need to go so that I could simply copy/paste them as needed, I would be eternally grateful. I am hoping you can help me, I have been struggling to find someone to help me with this for a while now.
MariusSKG
Mar 07, 2020Copper Contributor
Riny! I figured it out using what you gave me!!!!! THANK YOU! THANK YOU! THANK YOU!
- Riny_van_EekelenMar 07, 2020Platinum Contributor
MariusSKG You're welcome!