Find next on list

[billybowen]

Hi folks, i have a list of names in col D and some have a number in col F
In col H i want to list all names with a number in Col F but without spaces, in other words find next

 

[Rick Rothstein]

If you can make use of a macro, here is one for you to consider...

[table="width: 500"]
[tr]
	[td]Sub GetNamesWithNumbers()
  Intersect(Columns("F").SpecialCells([B][COLOR="#FF0000"]xlConstants[/COLOR][/B]).EntireRow, Columns("D")).Copy Range("H1")
End Sub[/td]
[/tr]
[/table]

The above code assumes the values in Column F are constants... they are the result of formulas, then change the red highlighted text to xlFormulas instead.