< Return to Talk
06.12.08, 17:56 PM General Topics
5 replies
anyone good with excel? [ Reply | Watch | Flag ]
General Topics 06.12.08, 05:56 PM Flag
 

Dear UrbanBaby community,

Thank you so much for being a valued member of the UrbanBaby community. We wanted to inform you that we are shutting down the site on July 6th. We are grateful for your participation and support that has helped make UrbanBaby such an important resource to parents for many years.

If you have any questions or concerns, you can email us at urbanbaby-support@cbsinteractive.com.

Thanks so much,

UrbanBaby Support

»
yes [ Reply | More
]
General Topics 06.12.08, 05:56 PM Flag
»
ok. here's my question. i have a very long list (words, not numerical information). i would like to know everything on the list that is/has a duplicate. I've been playing around and there's a filter option but it filters everything so that you only get unique records with no duplicates. i want to do the opposite...delete everything *except* if it's a double or a triple. I tried doing a subtotal and that might work b/c every time it's more than one it'll create a page break. but i'm wondering if there's something easier or more efficient. thanks. [ Reply | More
]
General Topics 06.12.08, 06:01 PM Flag
»
NP - you can sort alphabetically, then run a subtotal that will tell you how many of each record there are; then you can resort and delete just the ones that don't duplicate [ Reply | More
]
General Topics 06.12.08, 06:12 PM Flag
»
the problem is that my list is really long. several thousand items. most are unique entries. i don't want to scroll through thousands of entries to find to see where the duplicates are. unless it counts every unique item without a subtotal and then only subtotals the duplicates. i'm going to try that at work tomorrow. or maybe i'll create a sample spreadsheet here to see what happens. [ Reply | More
]
General Topics 06.12.08, 06:14 PM Flag
»
OP: you can actually do this. i found a web site if anyone is interested. here's the link and thanks for any brain power you put into my problem. http://office.microsoft.com/en-us/excel/HA011366161033.aspx?pid=CL100570551033 [ Reply | More
]
General Topics 06.12.08, 06:26 PM Flag
Refresh » New Post »
Select Category
close [X]

close [X]

Select a Category (only 1)

category
Stages
Regions