View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jambruins
 
Posts: n/a
Default Removing blank cells...

Cells B38:B90 either are blank or have text in them. I would like a formula
in cell I38 to find the first cell in B38:B90 with text in it and have that
text entered into cell I38. I would like cell I39 to find the next cell in
B38:B90 that has text in it and have that text entered into cell I39 and so
on. Thanks for the help.