Find Dups in a Excel List

by MYLE 21. June 2010 16:38

Had some ask me how can I find the Dups in a list of number items in a list with out sorting them. mmmmmmmmmmmm

thinking ................

so this is what I told him why not count the number of items in a list

the formala would be =Countif([range],[cell_to_check])

you must put the $ in the [range]

ie =countif($A$4:$A$1000,A4) it will put a 1 in the formula cell and if more than 1 put the count of it.

 

Comments

7/15/2010 2:17:45 PM #

Pozycjonowanie Kraków

I would equal to add your journal to my blogroll gratify bowman me what mainstay should I use?

Pozycjonowanie Kraków United States |

7/15/2010 3:56:06 PM #

MYLE

try this www.myle.co.nz/syndication.axd

i'm new at blogging so still leaning this bit of the web
I think you can just copy the  post RSS

MYLE |

8/5/2010 11:45:23 PM #

Hypercom t7Plus manual

Well that makes 2 things that I learned today.  This and google now has a ton of greasemonkey scripts which I just found out.  You learn something every day?  I got more than what I bargained for! hahaha.

Hypercom t7Plus manual United States |

8/17/2010 2:33:50 AM #

MYLE

I

I spend most of my day in google helps me out heaps

MYLE |

8/14/2010 6:47:31 PM #

Phone Cards

Wonderful blog! I saw it at Yahoo and I must say that entries are well thought of. I will be coming back to see more posts soon.

Phone Cards United States |

8/17/2010 2:33:04 AM #

MYLE

thanks

MYLE |

8/17/2010 2:34:34 AM #

MYLE

Please Delete other wise i will

MYLE |

8/25/2010 3:04:09 AM #

Milf Sex

In search for sites related to web hosting and comparison hosting plans, your site came up.

Milf Sex United States |

8/26/2010 6:21:19 PM #

MilfMovies

Wow! Thank you. I always wanted to write in my site something like that. Can I take part of your post to my blog?

MilfMovies United States |

8/27/2010 10:19:40 PM #

MYLE

show some of you work then I think about it OK

MYLE |

10/23/2010 11:22:17 PM #

fantasy football busts

I'm having a hard time seeing your website with safari.  Could you try to fix this so I could read at your site?  I'd really appreciate it ;)

fantasy football busts United States |

10/25/2010 4:52:01 AM #

nintendo dsi games

Great post about this. I'm surprised to see someone so educated in the matter.

nintendo dsi games United States |

10/29/2010 7:22:21 PM #

Unblock

These tips here worked very well except my bf still dont want me back as he has found a new gf to take my place, but this has helped me get over him and i am not single ready  to mingle

Unblock United States |

10/30/2010 1:39:04 AM #

Funny COmments

WowYou evaluate tons of legitimate reasons.
I like your reasoningand you haved got another daily fan.

take it easy

Funny COmments United States |

10/31/2010 11:44:55 PM #

electronic cigarettes

Im not sure the democrats are going to be able to hang onto the house and senate this year. Looks like they will lose the house but hold the senate.

electronic cigarettes United States |

11/2/2010 10:58:56 AM #

Hassie Kerchner

This is getting a bit more subjective, but I much prefer other methods.

Hassie Kerchner United States |

11/2/2010 6:12:40 PM #

Wesz Łonowa

goooood website!

Wesz Łonowa United States |

11/3/2010 5:05:02 AM #

Brittny

I have been reading and commenting on a competing site lots recently. I didn't know your blog existed! I do believe this place is better still, I shall be around.

Brittny United States |

11/15/2010 10:08:18 PM #

Wilber Jody

I visit so many varied sites that are nowhere near as good as this one. I discovered all the info much simpler to understand. Now I can see clearly the way forward.

Wilber Jody United States |

11/16/2010 2:14:50 AM #

vector arts

Hi. I just noticed that your blog appears like it has a code issue at the very bottom of your site's page. I am not sure if everybody is seeing this same problem when browsing your web site? I am using a completely different browser than most individuals called Opera, so that is what might be causing it? I simply wanted to make sure you know. Thanks for posting some great info.

vector arts United States |

11/18/2010 10:20:04 AM #

How to Make Money online

Hey why you believe this method works.I suppose you are earning ample of money online by this system thus you are describing it to us.Do you have any unique idea why it would work with me as well.I am really desperate to make money online.

How to Make Money online United States |

11/18/2010 9:20:48 PM #

Wii Homebrew

A recent development in the Wii homebrew scene has enabled the capability to extract these virtual console games as .WAD files and with the help of some software, install them onto other Wii consoles without going through the Wii shop channel and without paying.

Wii Homebrew United States |

11/19/2010 5:04:13 PM #

poker

You might already know about this problem but your site does not look right on the browser Opera. However, I don't have any problems with IE & FireFox, do you know what's going on? Thanks for your help!

poker United States |

11/22/2010 9:25:01 PM #

Heriberto Hou

I visit so many varied sites that are nowhere near as perfect as this one. I found all the info much clearer to understand. Now I can see clearly the way forward.

Heriberto Hou United States |

11/22/2010 11:28:21 PM #

Kristi Sullivan

I don't normally check out these kinds of sites (I'm a pretty modest person) - but even though I was a bit shocked as I was reading, I was definitely a bit excited as well. Thanks for giving me a big smile for the day Smile

Kristi Sullivan United States |

11/23/2010 12:22:52 AM #

best all in one printer

Sure wish I had read this blog earlier. This would have been great for my research. It's always interesting to read what folks say these days. Thank you for sharing.

best all in one printer United States |

11/24/2010 9:02:21 PM #

Jillian Osthoff

At last a site I can relate to! Thanks for the useful posts!

Jillian Osthoff United States |

11/25/2010 2:38:06 AM #

Edward

I would love to write and say what a great job you did on this, as you have put a lot of work into it

Edward United States |

12/1/2010 1:25:12 AM #

skin care review

These website is awesome it s got all of the points i wanted to debate, it has fulfilled my data, i basically chosen this blog and that i desire to subscribe so would you please notify when your site gets updated and what's the method to optin in details.

skin care review United States |

12/1/2010 2:03:55 PM #

Adrien Wappel

its <STRONG>very</STRONG> nice Blog! But There are a little mistake. For 4.reference subjects may be more illustrative and your blog tema  more live

Adrien Wappel United States |

12/3/2010 6:53:51 AM #

Dyson Hand Dryer

I simply purchased a model new HP laptop from bestbuy and when i rigorously opened the laptop computer from its original packaging I noticed there was a finger print on the LCD display screen? I cleaned it off with a microfiber fabric, however why do you suppose there was a finger print on this LCD in the first place? it was near the edge of the display screen and it seemed prefer it was from a thumb print

Dyson Hand Dryer United States |

12/4/2010 2:06:09 PM #

Hüseyin

www.sanalkalite.com alisveris

Hüseyin United States |

12/4/2010 2:09:24 PM #

Taner

www.sanalkalite.com alisveris

Taner United States |

12/4/2010 2:18:56 PM #

Hüseyin

www.sanalkalite.com alisveris

Hüseyin United States |

12/4/2010 5:56:40 PM #

Steve Murillo

I like vanity searches for random questions like <a href="http://isstevemurillocool.com/">is Steve Murillo cool</a>

Steve Murillo United States |

12/4/2010 7:00:26 PM #

Samantha Williams

Hola!

Samantha Williams United States |

12/4/2010 9:21:52 PM #

Check the Poker

Yes, this is one of the things that I think so. But still like it ;)

Check the Poker United States |

12/6/2010 6:30:57 AM #

Armandina Wen

I have built a blog and I was thinking of changing the template.I got some ideas from here! You could visit my website and tell me your opinion!

Armandina Wen United States |

12/12/2010 12:47:01 AM #

Kera Hermens

Just subscribed...I'm a lurker, but this got me off the fence.

Kera Hermens United States |

12/15/2010 11:08:11 PM #

scrapebox

I like what you guys are usually up too. This kind of clever work and coverage! Keep up the superb works guys I've incorporated you guys to  blogroll.

scrapebox United States |

12/15/2010 11:08:46 PM #

scrapebox

Please let me know if you're looking for a article writer for your blog. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I'd absolutely love to write some material for your blog in exchange for a link back to mine. Please blast me an email if interested. Many thanks!

scrapebox United States |

12/24/2010 1:01:01 PM #

veille seo

Hey check out my blog too. I hope i have some cool stuff too.

veille seo United States |

12/25/2010 12:00:29 AM #

George Abecassis

how will you get ideas to get your content? because i find your articles very engaging everytime i see your blog.

George Abecassis United States |

12/25/2010 2:20:57 AM #

Mário de Araújo Cabral

Mário de Araújo Cabral United States |

12/31/2010 8:47:56 PM #

Issac Perez

Hey, I just played the funniest funny game LOL it's called bloons 4.

Issac Perez United States |

12/31/2010 10:58:36 PM #

Eliza Dushku

recall, It has been quite a while There is some stuff. Well okay. I need this article something I am working on, fortunately for me mine is on a similar subject as the one here. Thanks, great share.<a href="snoopnews.info/...britynews4111.html">http://snoopnews.info/celebritynews4111.html</a>

Eliza Dushku United States |

1/1/2011 3:53:27 AM #

Jennifer Sky

for a second time, much too long since the last time I was here There is some stuff. Well another article that will work out just fine. I need something like this one of my school projects, lucky mine has the same topic as the one here. Glad, happy trails.<a href="snoopnews.info/...britynews3303.html">http://snoopnews.info/celebritynews3303.html</a>

Jennifer Sky United States |

1/4/2011 10:02:53 PM #

aquasana

.And I am not only marching in that procession but carrying Poverty.

aquasana United States |

1/9/2011 8:26:08 PM #

Amateursex

Nunja, das war ja klar, dass das nicht klappt! Ich hab's leider vorausgesehen!

Amateursex United States |

1/11/2011 2:31:12 PM #

Isobel Jones

Do you think it's best to post to a schedule or to post on a more random basis?

Isobel Jones United States |

1/24/2011 9:52:51 AM #

şişme bebek

ohh good. im find my answer ty Smile

şişme bebek United States |

1/26/2011 10:28:03 PM #

wpolscemamymocneseo

Can I simply say what a relief to find somebody who really is aware of what theyre talking about on the internet. You positively know how you can deliver an issue to light and make it important. More people must learn this and perceive this side of the story. I cant consider youre no more fashionable because you definitely have the gift.

wpolscemamymocneseo United States |

Comments are closed

Dislexia

I see people have commented about my style of writting.
Well I have dislexia so spelling is not one of my good points
but when it comes to reading/written code thats the easy bit.

 

 

Poll

What Search Engine Do you use




Show Results

Disclaimer of Liability

While every effort will be made to ensure that the information contained within this website is accurate and up to date, The Company's listed with this web site and any associated parties, make no warranty, representation or undertaking, whether expressed or implied, nor does it assume any legal liability, whether direct or indirect, or responsibility for the accuracy, completeness, or usefulness of any information.

 

Google Ads

Most comments

apply cash advance apply cash advance
1 comments
us United States
cloudy cloudy
1 comments
us United States
mutuelle mutuelle
1 comments
fr France

RecentComments

Comment RSS