[SOLVED]Find Value in Column A (which repeats) then return the value and the repeats

To extact unique data from column A1:A12 formula start at I2 (array formula)
=IF(ISERROR(INDEX($A$1:$A$12;MATCH(;COUNTIF(I$1:I1;$A$1:$A$12);0)));"";INDEX($A$1:$A$12;MATCH(;COUNTIF(I$1:I1;$A$1:$A$12);0)))

copy down

see attachment

Originally Posted by Ghozi Alkatiri

To extact unique data from column A1:A12 formula start at I2 (array formula)
=IF(ISERROR(INDEX($A$1:$A$12;MATCH(;COUNTIF(I$1:I1;$A$1:$A$12);0)));"";INDEX($A$1:$A$12;MATCH(;COUNTIF(I$1:I1;$A$1:$A$12);0)))

copy down

see attachment

Hey this works great except for when I try to adjust the range on A to A23:A700 it doesn't work at all anymore...thoughts? Also - I don't know if this is important - when I go to change it, the range it pink (the way you wrote it) but after I change it, it turns blue? This is this actual text in the formula bar by the way.

Again, very much appreciate the help.

- Joe

Originally Posted by FDibbins

did you take a look at the pivot table example i uploaded for you? you dont need any fancy formulas to adjust

Hey -

Yeah, of course I did! The pivot tables won't update when you change the data for some reason. Plus, I didn't know how to get the Totals on the right hand side either. I'm deleting the columns and then pasting new data in, I wouldn't think that would make a difference but I don't know. I'm attaching your file with my changes and you'll see what I mean. The able doesn't update.

Thanks,

- Joe