Thread
:
Choose the cells where there is a value
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
Posts: 11,058
Choose the cells where there is a value
Say data is in columns A & B. In C1 enter:
=IF(A1="",B1,A1) and copy down
--
Gary''s Student - gsnu200800
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student