|
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users
| FIND DUPLICATES IN EXCEL | PART ONE- 2012-09-25 07:10:43-04 |
In this post, I’m going to show you how to locate duplicates in Excel. I’m going to look at two scenarios. In the first scenario – we just have to identify duplicate/unique values in a list. For this I’m going to use Conditional Formatting . I also show you how to copy conditional formatting using [...]
Read more...
|
| FIND DUPLICATES IN EXCEL | PART TWO- 2012-09-25 07:25:33-04 |
In Part One of this blog posting, we’ve already looked at using Conditional Formatting to identify duplicates (and unique values). In the second scenario, I’m going to look at where we have a list of rooms/dates/times and we want to see if there are any clashes – so I’m going to use concatenation (not as [...]
Read more...
|
|