Thread: Return row index of all cells where text is found.
View Single Post
 
Old 01-25-2025, 06:25 AM
gmaxey gmaxey is offline Windows 10 Office 2019
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default
Thanks, but either of those returns an error 2029 with my simple test data in Column 1


Sub A()
Dim x
x = [TOCOL(IF(A1:A9="Pears",ROW(A1:A9),NA()),3,FALSE)]
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote