-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
reverse duplicates
-
C
Remove reversed duplicates from a reversed 2 way lookup
Imagine a spreadsheet with the data in the columns being the same as in the rows. A B C D E A 1 2 3 4 5 B 2 4 6 8 10 C 3 6 9 12 15 D 4 8 12 16 20 E 5 10 15 20 25 The above is a simple multiplication "table" to illustrate. The alphabets are my column and row headers. In the...- Chamkey
- Thread
- excel reverse duplicates
- Replies: 1
- Forum: Excel Questions
-
L
Identify reversed cells, where A1=A2, B1=B2, C1=D2 & C2=D1
Hello guys! This forum has poven to be very useful when I'm having real troubles with Excel, so I hope you guys will be able to give me a hand this one time once again! Thank you in advance :)) My issue consists of a database of routes A-B-C-D. But sometimes there is A-B-D-C (A and B stay the...- LitoII
- Thread
- reverse duplicates
- Replies: 3
- Forum: Excel Questions
-
M
Reverse of "Remvoe Duplicates"?
Instead of removing duplicates, I would like a list of the duplicates Excel would remove. The data is imported from another program, and I would like to clean up the source data, so that over time, there would be no duplicates. Is there way to do this? Mark- MarkSpencer
- Thread
- reverse duplicates
- Replies: 1
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
