| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Great idea Dave.
Thanks! "Dave Peterson" wrote: I'd just use a helper column of formulas: =countif($b$2:$B$1000,b2) and drag down (adjust the range to match) Then filter to show greater than 1 Dennis wrote: XL 2003 If I had data in column B like: Col A Col B Col C R1 xx 1 vt R2 qq 3 er R3 tt 2 lk R4 ll 1 ha R5 cv 2 ne R6 ws 1 xw I would like the live data "filtered" to display like: R1 xx 1 vt R4 ll 1 ha R6 ws 1 xw R3 tt 2 lk R5 cv 2 ne R2 qq 3 er Does not display because listed only once Thus 1) sorted by value in Col B 2) Any "B" value with more than one item in the list What is the smartest way to do this and be able to use it again and again. (That is why I thought of VBA) Thanks for any efforts. I am hoping that someone may have this tool already designed and is willing to share it? Dennis -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| How to count number of occurences in an autofilter list | Excel Worksheet Functions | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
| AutoFilter Blank Rows | Excel Discussion (Misc queries) | |||
Threaded Mode
