Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with sorting text in columns to match other columns
Hi, I have two columns of email addresses, say 1000 in Column E and 500 in Column F. I would like to sort Column F so that each individual email address in column F is in the same row as its matching email in Column E. Is there an easy way to do this? Thanks -- rkat ------------------------------------------------------------------------ rkat's Profile: http://www.excelforum.com/member.php...o&userid=37366 View this thread: http://www.excelforum.com/showthread...hreadid=570576 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with sorting text in columns to match other columns
One thing you can do is to use an additional column with this formula:
=IF(COUNTIF($F$1:$B$500,E1)0,E1,"") And copy it across the column to match the column E. The emails that are in the F column will be on the same line in column F, and it will be blank in the others. If you need it on column F, you can copy/paste values from that extra column to column F. Hope this helps, Miguel. "rkat" wrote: Hi, I have two columns of email addresses, say 1000 in Column E and 500 in Column F. I would like to sort Column F so that each individual email address in column F is in the same row as its matching email in Column E. Is there an easy way to do this? Thanks -- rkat ------------------------------------------------------------------------ rkat's Profile: http://www.excelforum.com/member.php...o&userid=37366 View this thread: http://www.excelforum.com/showthread...hreadid=570576 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a Text Box be Formatted in Columns? | Excel Discussion (Misc queries) | |||
Sort and Match like Items in 2 Columns | Excel Worksheet Functions | |||
Turn Off Text To Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) |