Return row index of all cells where text is found.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Return row index of all cells where text is found.

FAQ

Thread Tools

Display Modes

01-24-2025, 12:35 AM

Alansidman Alansidman is offline

Windows 11 Return row index of all cells where text is found.

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

An alternative means with Power Query

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type),
    #"Filtered Rows" = Table.SelectRows(#"Added Index", each ([Column1] = "Pears")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Column1"})
in
    #"Removed Columns"

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel VLOOKUP - Return cells that are not blank from range of specified cells	djlw84	Excel	10	05-09-2022 11:59 AM
Index Match and return mutiple results from a table	Bosslb	Excel	7	09-25-2021 11:42 PM
need Index, Match, Max to return SUMPRODUCT?	IRHSAM	Excel	0	11-17-2017 09:48 AM
Index to return value based on 2 conditions	george batshon	Excel	2	01-28-2017 05:11 AM
find a set of characters in a string and return a 0 (zero) if not found	MaineLady	Excel	2	11-05-2015 03:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:16 AM.