'extension'/enhancement of this tip wanted
pmarion wrote on December 31, 1969 19:00 EST |
I believe it would be useful to be able to break a list down, showing unique records as WELL as duplicates, perhaps filtered into two seperate columns or at least formatted differently between the two.
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?
|
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. |
Business Analysis with Microsoft Excel (2nd Edition)
