auto line inserts needed

  • Thread starter Thread starter Mr BT
  • Start date Start date
M

Mr BT

Hello,
I have several duplicate records in column B. I determined this with a
formula... =if(b2=b1,"*","") and filled down. Then I copied and paste
special value. I then selected Data>Text to columns, Fixed width to remove
any data left by "" in the formula.

From here I would like a script that finds the blank lines in column A
(without the *) and select EACH of these lines so I may INSERT a row. This
will allow me to use other formulas from the .functions ng I received.

Thank you.
 
no help required. thank you though, i figured this one out on my own...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(AND(Complex Formula in Error in data import before I process it 8
Mid column sum formulas with varied ranges to sum 17
Keeping formulas on an insert 1
Copy columns and paste with blank column between 5
A data validation question 1
Insert columns and values programmatically with IF statement 9
Need help on this strange event 1
Insert formulas 1

Back
Top