Forum Discussion
Solved
merging cells
i have a long table like this: phone animal food 123 dog 123 cat 123 fish 123 pizza 123 123 hot dog 456 456 cat 789 fish pizza ...
See the attached workbook.
hi HansVogelaar
i have many rows (950,000 rows). and when i put thw formula that u made, the Excel course from the load.
many of my cells (for example, the Animal, and not the Number) are empty. there for i want that the formula get action only in non-empty cells.
i tried somthing in the file below (red font), but its worng. (i thought to use in if statment...)
ty so much!
I'm sorry, I really don't understand what's wrong with the solution that I proposed. It does not have the problem that your formula has.