Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Showing Duplicate rows in excel
Hi Friends!
I want to show the unique rows in a columns....say in ColA there are 100 filled cells and out of which only 65 are unique.... I want to list only unique entries..... It is very difficult to sort all the entries individually IF anybody help me out...... By Jagjeet Singh |
#2
|
|||
|
|||
Hi
use 'Data - Filter - Advanced Filter' and check 'Unique entries' or use the following addin: http://www.rondebruin.nl/easyfilter.htm -- Regards Frank Kabel Frankfurt, Germany "Jagz" schrieb im Newsbeitrag ups.com... Hi Friends! I want to show the unique rows in a columns....say in ColA there are 100 filled cells and out of which only 65 are unique.... I want to list only unique entries..... It is very difficult to sort all the entries individually IF anybody help me out...... By Jagjeet Singh |
#3
|
|||
|
|||
Jagz wrote:
Hi Friends! I want to show the unique rows in a columns....say in ColA there are 100 filled cells and out of which only 65 are unique.... I want to list only unique entries..... It is very difficult to sort all the entries individually IF anybody help me out...... By Jagjeet Singh If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook =ArrayUniques(A:A) array entered into a column of cells of sufficient number to accommodate the output. Alan Beban |
#4
|
|||
|
|||
Thanx Frank! It is indeed useful.....But one thing can i also filter
more than one row say Unique records in First second and third rows eg Row one contains -----1,jag,23 Row two contains -----2,man,34 Row three ----------------1,jag,23 Row four ------------------2,man,22 Row five -------------------2,jag,45 now i want the output should be four rows ....... in adv filter it will delete all duplicate rows with jag OR 1 OR 23 AS THE CASE MAY BE THANKS DEAR FRANK FOR THE PROMOT ANSWER AND HAPPY NEW YEAR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding duplicate records in Excel | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Remove empty rows in excel? | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |