|
» Filtering a Range into a List of Unique Records
CATEGORY: Excel Filter |
VERSIONS: All Microsoft Excel Versions |
|
To filter a range into a List of unique records: 1. Select a cell the range (see screenshot). 2. From the Data menu, select Filter, and then Advanced Filter. 3. Select Copy to another location. 4. In the Copy to box, insert a cell address. 5. Select the Unique records only checkbox, and then click OK. |
| Screenshot // Filtering a Range into a List of Unique Records |
  |
|
RATING:
3.27
VIEWS: 54313 |
||||
Exclude hidden cells when selecting
Randy Aldous wrote on December 31, 1969 19:00 EST
In response to pmarion's post (which is dated "December 31, 1969 18:00 EST" by the way. I don't think this site, let alone the Web, even existed back then. Someone might want to look at system dates somewhere.....) asking, in part,
"Lastly, if filtered and I choose to select all rows, the hidden records are also copied. Short of selecting each cell using the ctrl key (difficult for ranges with thousands of records,) how might this be achieved?"
After you do your find, in the menu, go to EDIT --> GO TO... --> SPECIAL --> click VISIBLE CELLS ONLY. This essentially performs a Select All but only on the cells
that are displayed.
-Randy
unique record filter doesnot works properly
sachin wrote on December 31, 1969 19:00 EST
If I try to get unique recordes for the below I get a twice. can you please figure out the cause
a
d
f
s
a
a
s
f
g
j
s
s
s
reaction to Sachin
Ron.oldeboom wrote on December 31, 1969 19:00 EST
Sachin, the 2 a's appear because the advanced filter recognises the first entry in the list as the label heading your data table; hence the "a" appears twice.
Hope this helps
reaction to Sachin
Ron.oldeboom wrote on December 31, 1969 19:00 EST
Sachin, the 2 a's appear because the advanced filter recognises the first entry in the list as the label heading your data table; hence the "a" appears twice.
Hope this helps
reaction to Sachin
Ron.oldeboom wrote on December 31, 1969 19:00 EST
Sachin, the 2 a's appear because the advanced filter recognises the first entry in the list as the label heading your data table; hence the "a" appears twice.
Hope this helps
To filter a range into a List of unique records:
Syed Azhar Ali wrote on December 31, 1969 19:00 EST
My attempts to exercise your tip failed. You have shown 5 steps for this procedure. In "View Tip on the web with user comments". There is no mention of Conditional Formating but the same is there. Please help me as to what you mean by "unique records" and how should I filter them.
Copy Unique rows to another sheet
LF wrote on December 31, 1969 19:00 EST
Is there a way to copy specific rows that have the same dealer name in the cell to a different sheet? The entire list has many different rows with different dealer names and I want to each dealer onto a different sheet. Do you know of a way to do this?
Copy Rows to other sheet
NA wrote on December 31, 1969 19:00 EST
You can name the list using Insert->Name->Define
Ex. "MyList"
Then you can open the other sheet and input for the "List Range:" the list name
Ex. "=MyList"
This allows you to copy to a range in the currently open sheet.
Copy Rows to other sheet
NA wrote on December 31, 1969 19:00 EST
You can name the list using Insert->Name->Define
Ex. "MyList"
Then you can open the other sheet and input for the "List Range:" the list name
Ex. "=MyList"
This allows you to copy to a range in the currently open sheet.
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
Furthermore, if I use conditional formatting, how may I select the conditionally formatted cells alone (cannot use find function with format.)
Lastly, if filtered and I choose to select all rows, the hidden records are also copied. Short of selecting each cell using the ctrl key (difficult for ranges with thousands of records,) how might this be achieved?