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

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique