Thread
:
Unmerge cells and fill duplicate data
View Single Post
#
5
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 1
Unmerge cells and fill duplicate data
Add another column (B) and then add this function to fill in everything until another entry for the merged cell in col A:
=IF(A2=0,B1,A2).
This assumes you have one header.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]