Sorting by Unique Name

[Justijb]

Hello All,

Apologies for the multiple posts but I am in search of your expertise as my back is against the wall. I have a spreadsheet that needs to be sorted on Column D (there are column A through N) and over 18k records (rows).

Column D's header is 'Family Name'. I need to highlight in yellow the records that have only one name in it. E.g. Rows 2 and 3 only have 'Regina' while rows 4 through 23 have 'Elizabeth Lastname' and other rows have 3 or 4 words (names). I would need help developing a macro that would highlight the row that has only one word in it.

I'm not sure if this even possible because it is not specific but I figured I've received helped here before.

If any further information Is needed, please let me know.

Fingers crossed.

V/r

JB

 

[63falcondude]

It sounds to me like this can be done with sorting and Conditional Formatting. Make sure that you clean your data using the trim function to make sure that there are no leading or trailing spaces (e.g. " word", " word ", and "word "). Then you can search for a space in the conditional formatting rule.

 

[63falcondude]

For example, let's say that this is your data:

Excel 2010
	A	B	C	D	E	F
1				Family Name
2				Michael
3				John Doe
4				Regina
5				Elizabeth Lastname
Sheet1

Now highlight A2:N5, Conditional Formatting, New Rule, Use a formula, =NOT(COUNTIF($D2,"* *")), Fill yellow, OK. This will highlight row's 2 and 4 in the above example (specifically cells A2:N2 and A4:N4).

 

[Justijb]

You were spot on 63falcondude. I really appreciate it.

V/r

JB

 

[63falcondude]

Great, glad to help.