Hi,
I am trying to create a formula that brings back a month number based on where a value is input.
For example I have month 1 to 48 in column B from B1 to B40 and in column G1 to G40, I would place randomly the value 1000 aligned with Column B months for example months 1-13-19 etc. In column N I would like a dynamic formula that brings back the month number based on where I place the 1000s In Column G.
I can't attach my sample but I will ask the administrator. Once I figured out how
Thank you so much for your help in advance.
Bruno
I am trying to create a formula that brings back a month number based on where a value is input.
For example I have month 1 to 48 in column B from B1 to B40 and in column G1 to G40, I would place randomly the value 1000 aligned with Column B months for example months 1-13-19 etc. In column N I would like a dynamic formula that brings back the month number based on where I place the 1000s In Column G.
I can't attach my sample but I will ask the administrator. Once I figured out how

Thank you so much for your help in advance.

Bruno