| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i look through worksheets in a workbook to find duplicate
I have 5 worksheets in a workbook. I need a formula that will look through
the worksheet for duplicated information and display in another worksheet. |
|
#2
|
|||
|
|||
|
Hi Connie, I regularly use the COUNTIF function, providing you have a unique identifier, which counts the number of the cells in a range with the value which you state (which can be a value or cell). Any entries that are NOT duplicated will return 1, because only one instance has been found, and any entries that are duplicated (or more) will return the number of times they are in the range. =COUNTIF(Range,Criteria) Good luck, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=381987 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
| How do i group worksheets inside a workbook into subgroups? | Excel Worksheet Functions | |||
| Viewing Worksheets withing One Workbook | New Users to Excel | |||
| Count the number of worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
