Request for a formula to use in spreadsheet

sriniwas67 · General User Joined: 05 Mar 2012 Posts: 9

Request a code for adding new values only from 2nd spreadsheet or workbook while retaing the old values in sheet one or workbook 1.

For eg, values in sheet 1 - .001,.014, .079, Values in sheet two - .001, .085,.014,.092.

I want a formula or code for adding only new values from sheet 2 i,e -.085 & .092 while retaining the old values in sheet 1. the cells may contain Numerals,alpha numerals or alpha alone.

Regards,
Sriniwas

Moved to Calc – Robert Tucker, Moderator

davidh182 · OOo Advocate Joined: 01 Apr 2004 Posts: 413

Can you just stick all the values into 1 column,sort, and then identify the duplicates with a 2nd column "=A1=A2" in cell B2 [ie true if the value equals the one above]

Then filter out the "TRUE"'s and delete.

karolus · OOo Advocate Joined: 22 Jun 2011 Posts: 208

Hallo

Needs no sorting and 2.nd Column with Formula -

Copy together in one Column and do:
→Data→Filter→Standardfilter....with Option [x]without Duplicates

Karo

CSLam · Posted: Thu Aug 30, 2012 12:43 am Post subject:

Try this :-

SUM(IF(Sheet1.A1:A6=Sheet2.A1:A6,0,Sheet2.A1:A6))

note:
This is an array function therefore after entering the formula, hold down Shift & Control together, then press Enter. You should see
{=SUM(IF(Sheet1.A1:A6=Sheet2.A1:A6,0,Sheet2.A1:A6))}

The above will compare values in the range A1:A6 across Sheet1 and Sheet 2, and only add together new values identified in Sheet2.

CSLam