How to identify the row number that a text cell is in?

[MLSNetworks]

Is there a formula to identify what row number a certain cell is in? I have a column that has that has the word Yes in some of the cells and I want to know what row number those Yes cells are in. Is there are way to get this? I'm inclined to say there isn't but I thought I'd ask this forum in case there is someone that knows.

I've uploaded an image as an example of what I'm talking about. I have the word Yes in rows 2, 3, 10, 11, 12, 14, 15, 20, 21 and I want to know if there is a formula that would identify what row number this text is in. My excel file has 19 tabs with the word Yes in the sheet in multiple places and I don't want to manually write down what row these are in. This may sound like a crazy request but the reason why I need to do this is prepare the formatting to be uploaded into RFPIO (Request for Proposal Input Output) software program.

Thanks for any help!

 

[jasonb75]

Depends if you have an up to date version of excel, based on what I see in your screen capture, array confirmed with Ctrl Shift Enter.

=TEXTJOIN(", ",1,IF(A2:A21="Yes",ROW(A2:A21),""))

If it shows #NAME? then it means that your version of excel doesn't have the TEXTJOIN function.

 

[DanteAmor]

My excel file has 19 tabs with the word Yes in the sheet in multiple places

Always in column A?
Where do you want the result?
How do you want the result?
What happens if 2 sheets have "Yes" in the same row?

 

[MLSNetworks]

Is there a formula to identify what row number a certain cell is in? I have a column that has that has the word Yes in some of the cells and I want to know what row number those Yes cells are in. Is there are way to get this? I'm inclined to say there isn't but I thought I'd ask this forum in case there is someone that knows.

I've uploaded an image as an example of what I'm talking about. I have the word Yes in rows 2, 3, 10, 11, 12, 14, 15, 20, 21 and I want to know if there is a formula that would identify what row number this text is in. My excel file has 19 tabs with the word Yes in the sheet in multiple places and I don't want to manually write down what row these are in. This may sound like a crazy request but the reason why I need to do this is prepare the formatting to be uploaded into RFPIO (Request for Proposal Input Output) software program.

Thanks for any help!

Thanks Jason, this worked! Brilliant. Thank you so much!

 

[MLSNetworks]

Always in column A?
Where do you want the result?
How do you want the result?
What happens if 2 sheets have "Yes" in the same row?

Thanks DanteAmor, I got the answer from jasonb75 which worked but I really appreciate your prompt reply. Thank you!

 

[jasonb75]

I got the answer from jasonb75 which worked

If you want an answer then take the first reply, if you want a solution then take every reply and see which works best.

I have a rough idea of what @DanteAmor has in mind based on the questions that he asked, if I'm correct then it might be a better option for what you're doing than the formula that I suggested.