G
Guest
Hello all.
Ok.... I have a table of data. Some are duplicated, and I'd like to find out
which one's, and how many.
I've got six columns of 5 digit#'s, spread out with match(), and countif()
in each subsequent column, and I want to do a "bulk" countif, just counting
the 5 digit#'s. I did try a countifs(), and that doesn't apply for my
situation here.
I.e.,
ColA ColB ColC ColD
........
12345 match() countif(A1:J100,A1) 56789 ......
....... ...... ..... .......
.......
Here's the catch.
Because of everything else within the group-- a match equation to make sure
I have everything needed, I wanted to place the countif at the end of each
individual grouping, and it of course returns a circular reference error.
So, my question is:
I need to countif, or something to count all incidences of my 5 digit
numbers to determine if there are duplicates, and which ones.
How can I have a count if that will account for 6 range columns, without
creating a circular reference?
you'll ask me then why not just place them in a single column.
I had placed them all in a single column before and after I'd processed
everything I found other errors that I wasn't previously anticipating; so
I've placed them all back in columns-- accounting for their source location,
an important aspect in this specific case.
If this isn't clear enough, send me an email, and I'll forward a sample in
xls. Oh, I am working in 2007 if that matters. We however save our files in
compatible mode.
As always, thank you, in advance.
Best.
Ok.... I have a table of data. Some are duplicated, and I'd like to find out
which one's, and how many.
I've got six columns of 5 digit#'s, spread out with match(), and countif()
in each subsequent column, and I want to do a "bulk" countif, just counting
the 5 digit#'s. I did try a countifs(), and that doesn't apply for my
situation here.
I.e.,
ColA ColB ColC ColD
........
12345 match() countif(A1:J100,A1) 56789 ......
....... ...... ..... .......
.......
Here's the catch.
Because of everything else within the group-- a match equation to make sure
I have everything needed, I wanted to place the countif at the end of each
individual grouping, and it of course returns a circular reference error.
So, my question is:
I need to countif, or something to count all incidences of my 5 digit
numbers to determine if there are duplicates, and which ones.
How can I have a count if that will account for 6 range columns, without
creating a circular reference?
you'll ask me then why not just place them in a single column.
I had placed them all in a single column before and after I'd processed
everything I found other errors that I wasn't previously anticipating; so
I've placed them all back in columns-- accounting for their source location,
an important aspect in this specific case.
If this isn't clear enough, send me an email, and I'll forward a sample in
xls. Oh, I am working in 2007 if that matters. We however save our files in
compatible mode.
As always, thank you, in advance.
Best.