Get instant live expert help on find merged cells in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula that could find values in the merged yellow rows (IDDD, /DDDD, and ZDDD) and show those values in the output columns... for those rows that are under the yellow rows.. one possible solution is a formula that searches the most recent merged cells in excel and copies the values from there. This is because the rows with the data have merged cells. Any other solution is also welcomed.
Solved by G. Y. in 12 mins
I am hoping to find a macro that will help me to convert one table (with columns of data that may contain merged cells and duplicate values) to another table with non merged cells and non duplicate values in 2 columns. Please see attached spreadsheet. Can you please help? Thanks!
Solved by K. L. in 13 mins
When sorting in Excel, I keep getting the Alert message: This operation requires the merged cells to be identically sized. Help!
Solved by D. H. in 17 mins
I want to merge duplicate rows and fill in the blank cells with the merged row
Solved by E. J. in 19 mins
=CONCATENATE('Merged Sheets'!$A$2,";",'Merged Sheets'!$B$2,";",'Merged Sheets'!$C$2,";",'Merged Sheets'!$M$1,";",'Merged Sheets'!$M$2) When I drag down to fill cells with this formula I need the last 2 formulas to increment by 1 column. Eg N1 N2, O1 O2
Solved by T. U. in 15 mins