Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I insert a row in MS Excel using a formula?
Hi,
I have an excel file which goes like this in my first 2 columns: PRODUCT PUBLICATION NAME Product 1 publication 1 publication 1 publication 2 Product 2 publication 1 publication 1 publication 2 Product 3 publication 3 Product 4 publication 2 This file runs in 20k + rows.....and I need to insert a new row whenever I encounter a new product or publication. The end result as I want is below: PRODUCT PUBLICATION NAME Product 1 publication 1 publication 1 publication 2 Product 2 publication 1 publication 1 publication 2 Product 3 publication 3 Product 4 publication 2 Notice that there's a row between new products and new publications. Can someone tell me an easier way to do it , or than doing it manually for 20,000+ rows? Thanks :) P |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to insert time of day in excel cell | Excel Worksheet Functions | |||
formula to insert time of day in excel cell | Excel Discussion (Misc queries) | |||
formula to insert time of day in excel cell | Excel Worksheet Functions | |||
insert logical formula in excel worksheet | Excel Worksheet Functions | |||
How do I set up a formula to insert text in excel? | Excel Discussion (Misc queries) |