# Compare and Count Entries

1. ## Compare and Count Entries

I am trying to work out a calculation that counts the number of entries from two separate sheets, compares them, and gives a final tally between the two. The lists are supposed to be redundant, so occasionally one catches an item the other doesn't. I need my final tally to include every item that passes through, but the items can cycle through, so it can't just be a count of unique items. Comparing and merging the columns may be a solid path forward, if that's possible. I thoroughly appreciate any help you can provide! I'm attaching a simple example of the goal.

2. ## Re: Compare and Count Entries

why would the result be 13? please explain...

3. ## Re: Compare and Count Entries

The separate items from the two lists would be:
1
2
3
4
5
6
7
8
1
2
3
4
5
Which is a total of 13 items

4. ## Re: Compare and Count Entries

In sheet 3 you have at the end
1
2
3
5

4 is missing.....and you count it in your list above, so I dont think the logic is well understood.

In sheet 2 you have only 11 items....

5. ## Re: Compare and Count Entries

The two lists each miss item(s) that the other list contains.
List 1: Missing the first 4 and 8
1
2
3
5
6
7
1
2
3
4
5
List 2: Missing the 2nd 4
1
2
3
4
5
6
7
8
1
2
3
5
The total list, that I am trying to count, is:
1
2
3
4
5
6
7
8
1
2
3
4
5

6. ## Re: Compare and Count Entries

Formula:
`Please Login or Register  to view this content.`

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1