Help with Spreadsheet

  steviegee 10:39 27 Jul 07

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 07

i would suggest using either sum or if format,


  steviegee 11:39 27 Jul 07

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

  VoG II 11:49 27 Jul 07

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 07

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.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…