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
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 |
|
|