Forum Discussion
Question on Merging of rows
Hi, I have a sheet of over 5000 rows, and I'm looking to merge rows with a similar name, while combining the rows so that main row contains all the necessary information. Not really sure how to expla...
=IF(COUNTIFS($A$2:$A$9,$I2,$B$2:$B$9,$J2,C$2:C$9,"TRUE"),"TRUE","FALSE")An alternative could be this formula. The formula is in cell K2 and filled across range K2:O4. The unique entries of first name and last name in columns I and J were done with Data -> Remove duplicates.