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![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thank you so much for your help in advance.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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