Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Exclude a row with duplicate values in Excel

Hi all
I need to sum rows in excel.
But there are rows with duplicate data..

e.g  If for a giveb two rows..  with column FileName
If the number [99123654] appears in Row 1 and row 2.
Only one row 1 will be calculate. Row two will be skipped.
This case may involve about 4 rows.. Hence only 1 row out of the 4 will be included in the calculation..

Thanks in Advance
ZH
0
ZURINET
Asked:
ZURINET
  • 2
2 Solutions
 
NBVCCommented:
So are you just summing up a column of various FileNameIDs and just want to include only the first row of each unique FileName... or are you inputting the FileName somewhere and what to retrieve the value in the first row of that FileName's occurance in the column?
0
 
ZURINETAuthor Commented:
Hi NB_VC

This statement is correct

"So are you just summing up a column of various FileNameIDs and just want to include only the first row of each unique FileName"
0
 
NBVCCommented:
The simplest way would be to add a quick helper column to identify the first of each.

Assuming they are grouped together, and that the data starts in A2 and B2, then in C2 enter formula:

=IF(A2=A1,"",B2)

copied down

Then the total would be simply:

=SUM(C:C)

Does that work for you?
0
 
Shanan212Commented:
=SUM(IF(FREQUENCY(C5:C9,C5:C9),C5:C9))

Change it as you wish and enter as array formula.

That is, once you finish modifying the formula, select the cell the formula is in, then press

'Ctrl + Shift + Enter' keys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now