Posts by pjordan

Yes I mean delete the non duplicates. I'm attempting to easily find which records are duplicates

I was thinking of a way that I could do this all in one column

For example

1
1
2
3
4
4
4
5
6

I would want just

1
1
4
4
4

to be flagged or shown

Or it could be done the opposite way, by deleting the duplicates in the column and then I could compare that to the original column with the duplicates.

Thanks, hope it's not too confusing...

I thought there was a way to compare two columns and then purge everything that was not a duplicate so that the duplicate fields could be isolated.

Any ideas? Thanks...

Cool thanks, that worked. I knew it had something to do with either the shift or crtl or alt buttons, but couldn't get the combo....

Is there a way to jump to the last text entered in a column at all? I have several columns of different lengths and need to quickly jump back and forth to the ends of each to enter new info. It's kind of time consuming to use the Pg down and up to get to each one...