nth occurrence

Hello, thanks for looking I was hopping that my last post ( Structured Table Names for current row ) would have given me workable answer to this problem. I need to find in array (7*20+ x 25 rows) if a number or greater is a selected in a row. This done by checking the 1stcolumn in a set of 7...

Hello, I'm hoping someone can help me on this. I've looked everywhere and the only thing I can find is formulas where I must identify which occurrence of a value I want to return. However, what I'm looking for is to apply a formula to all of the recurring values to return which occurrence it...

I cannot figure out what I'm doing wrong. I have the following data in one sheet 1-Jan Jim Jane 4 Mary Jerry John 7 Sally Mark 7 I am trying to get the data to fill in on another excel sheet, within the same workbook, that is setup like a calendar My expected result is: Jane...

Can someone help me adjust this formula to return the Nth "group" that a "name" is in? And if the "name" only occurs once, the search for the 2nd occurrence will return ""? Sticking with the pictured example, I would like each person's 1st group to show in column H [like it already is] and each...

Hi, I couldn't find this answered exactly on the forum. Sorry if it has. I am looking to return the column number of the nth occurrence in a row. So in the example in the table below, I am looking to return the column number in row 1 of the 2nd (B4) occurrence of the word 'dog' (B3). In this...

The desired outcome is in the picture. Your help will be really appreciated.

Hello, I'm trying to do a nth occurrence lookup (probably with a macro), among an array of data and returning the value from a specific column within the same row. I'm trying to look up student scholarship assignments from the following data: <tbody> Scholarship Name Awardee Student#1...

I am building somewhat of a rudimentary search engine that looks for a name, address or unique identifier, using an Index Match formula that searches with a wild card: =INDEX(Name,MATCH("*"&F3&"*",Name,0)) "Name": is the defined name for column C on a separate sheet. F3: is "search field" The...

Trying to isolate the second number in cell. If I have 48X144X68 in J10, I need 144. I tried: =MID(J10,FIND("X",J10,2)+1,3) which works, but when a cell has 65X50X68, then I get 50X where I only want 50. The numbers can vary in size (i.e., 1 to 5 digits) but always separated by an X or some...