Search results

Hi Narayan, started doing it manually. But to answer your question, I can afford to dedicate another column that states the row type. Ie. Column to state if the row is a heading or otherwise. Shrikanth

I have an excel worksheet populated with a list of headings and subheadings under them arranged in consecutive rows. The headings are colored green and the sub headings under them red. I am looking for a method to extract the main headings alone and arrange them consecutively in an other...