sort name records according to criteria
I have sheet of names and addresses but some of the rows do not have the
name title ( Mr / Mrs ) . i.e they only have the name J. Doe instead of Mr J. Doe I would like to prepare the list for mail merge in order to do this, I want to split the list into 2 segments. 1 section of the rows of records containing full title and the 2nd section containing the records which have no title. How can I do this quickly without highlighting and cut/copy etc? It's a list of several thousand records. -- -keevill- |
sort name records according to criteria
=IF(OR(LEFT(A1,2)="Mr",LEFT(A1,3)="Mrs"),"Mr/Mrs","")
then apply autofilter ctrl+G, Special, select Visibles, copy to another sheet/location, paste as values do the same for NON "Mr/Mrs" with changed formula: =IF(AND(LEFT(A1,2)<"Mr",LEFT(A1,3)<"Mrs"),"Mr/Mrs","") |
sort name records according to criteria
"Jarek Kujawa" wrote in message ... =IF(OR(LEFT(A1,2)="Mr",LEFT(A1,3)="Mrs"),"Mr/Mrs","") then apply autofilter ctrl+G, Special, select Visibles, copy to another sheet/location, paste as values do the same for NON "Mr/Mrs" with changed formula: =IF(AND(LEFT(A1,2)<"Mr",LEFT(A1,3)<"Mrs"),"Mr/Mrs","") few more instructions needed please... where do I insert this text/command ? |
sort name records according to criteria
These formulae (perhaps slightly changed to match your columns) should come
in a new column next to your table. Then you can use Sort or Autofilter. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "-keevill-" wrote: "Jarek Kujawa" wrote in message ... =IF(OR(LEFT(A1,2)="Mr",LEFT(A1,3)="Mrs"),"Mr/Mrs","") then apply autofilter ctrl+G, Special, select Visibles, copy to another sheet/location, paste as values do the same for NON "Mr/Mrs" with changed formula: =IF(AND(LEFT(A1,2)<"Mr",LEFT(A1,3)<"Mrs"),"Mr/Mrs","") few more instructions needed please... where do I insert this text/command ? |
All times are GMT +1. The time now is 10:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com