Help with Spreadsheet

  steviegee 10:39 27 Jul 2007

I have a large spreadsheet with various numbers and info. What I need to do is add a row with another number and info whenever that number shows up.

i.e if it says abc123 and I need abc456 to go in a row beneath is it possible, using vlookup, hlookup whatever?

  johnnyrocker 11:20 27 Jul 2007

i would suggest using either sum or if format,


  steviegee 11:39 27 Jul 2007

How!!! I need some sort of formula please.

  VoG II 11:49 27 Jul 2007

You cannot add a row using a formula.

Can you explain a bit better what you are trying to do?

  steviegee 11:58 27 Jul 2007

If I can't add a row with a formula and I have to add them manually then we need not go any further!!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone