| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
hi try doing this first sort all the rows in desc order eg A10:A100; then in next column B1 put formula =IF(A1=A2, 0,1) once formula put drag it down till the column B100 and see if you get any 1 that means its a duplicate data. hope this helps regards digvijay -- digvijay21 ------------------------------------------------------------------------ digvijay21's Profile: http://www.excelforum.com/member.php...o&userid=23929 View this thread: http://www.excelforum.com/showthread...hreadid=375559 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a list of numbers. | Excel Discussion (Misc queries) | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
Threaded Mode
