LIFamilies.com - Long Island, NY


RSS
Articles Business Directory Blog Real Estate Community Forum Shop My Family Contests

Log In Chat Index Search Rules Lingo Create Account

Quick navigation:   

Microsoft Excel - HELP!

Posted By Message

Elbee
Zanzibar

Member since 5/05

10767 total posts

Name:
Me

Microsoft Excel - HELP!

Any way to weed out duplicates in an excel file?

Is there a formula or something?

Posted 8/23/06 10:59 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

MrsMerlot
Unconditional Love

Member since 4/06

6005 total posts

Name:
Chrissy

Re: Microsoft Excel - HELP!

insert another column and do something like this:

=IF[a1=(a2:a55), FALSE]

whatever returns N/A are unique, and whatever has a value, is a duplicate

might have my brackets in the wrong spot though

Posted 8/23/06 11:01 AM
 

Elbee
Zanzibar

Member since 5/05

10767 total posts

Name:
Me

Re: Microsoft Excel - HELP!

thanks, one more question ... how do I get two cells to become one cell?

Meaning if I have "Chrissy" in one cell and "Ricky" in another ... can I get them into one cell to say "Chrissy Ricky"? Is that possible?

Posted 8/23/06 11:28 AM
 

MrsMerlot
Unconditional Love

Member since 4/06

6005 total posts

Name:
Chrissy

Re: Microsoft Excel - HELP!

Posted by Elbee

thanks, one more question ... how do I get two cells to become one cell?

Meaning if I have "Chrissy" in one cell and "Ricky" in another ... can I get them into one cell to say "Chrissy Ricky"? Is that possible?



use this formula:

ie: a1 chrissy, b1 ricky

=CONCATENATE(A1,B1)

which will give you chrissyricky

Posted 8/23/06 11:30 AM
 

Smiley
LIF Infant

Member since 6/06

83 total posts

Name:

Re: Microsoft Excel - HELP!

You'll have to hilight both cells and right-click, Format Cells, Alignment Tab, Check off "Merge Cells". You may have to retype data. Not sure exactly what you're trying to do.

Posted 8/23/06 11:31 AM
 

Elbee
Zanzibar

Member since 5/05

10767 total posts

Name:
Me

Re: Microsoft Excel - HELP!

I found it

A1: Chrissy
B1: Ricky

The formula is

=(A1&" "&B1)

= Chrissy Ricky


Thanks Chat Icon

Message edited 8/23/2006 11:36:42 AM.

Posted 8/23/06 11:33 AM
 

MrsMerlot
Unconditional Love

Member since 4/06

6005 total posts

Name:
Chrissy

Re: Microsoft Excel - HELP!

Posted by Smiley

You'll have to hilight both cells and right-click, Format Cells, Alignment Tab, Check off "Merge Cells". You may have to retype data. Not sure exactly what you're trying to do.



that actually merges the cell into one cell, using the data from the first selected...

ie: makes two boxes one box...

Posted 8/23/06 11:36 AM
 

Elbee
Zanzibar

Member since 5/05

10767 total posts

Name:
Me

Re: Microsoft Excel - HELP!

I just read the CONCATENATE formula too. Thank you for that.

Posted 8/23/06 11:37 AM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
Need Microsoft Excel help quick Scotty-CassidysMom 6/15/05 5 Families Helping Families ™
how can i download IE6? can't find it on microsoft.com CathyB 8/13/05 1 Families Helping Families ™
Question about Microsoft.. HELP! dottiemchugh 3/2/06 6 Families Helping Families ™
Anybody good at microsoft word? CAJ 1/25/06 12 Families Helping Families ™
GM VS. Microsoft AJsMommy122 9/2/05 2 Families Helping Families ™
 
Quick navigation:   
Currently 467219 users on the LIFamilies.com Chat
New Businesses
1 More Rep
Carleton Hall of East Islip
J&A Building Services
LaraMae Health Coaching
Sonic Wellness
Julbaby Photography LLC
Ideal Uniforms
Teresa Geraghty Photography
Camelot Dream Homes
Long Island Wedding Boutique
MB Febus- Rodan & Fields
Camp Harbor
Market America-Shop.com
ACM Basement Waterproofing
Travel Tom

      Follow LIWeddings on Facebook

      Follow LIFamilies on Twitter
Long Island Bridal Shows