Formula for a cell number

[GetPaidOl9]

Hello Friends,

I have a huge spreadsheet with 18 columns and >2000 rows. In column 'N' there is data that change by changing the data in columns 'C', 'D', 'E' and 'G'. On the top of column 'N', I have put the the formula "=MIN(N10:N2087)". I get the ans correctly, but can I get the cell number (in the adjacent cell) which contains that minimum values. I don't want to scroll whole sheet every time when the cell number changes.

Thanks in advance.

 

[GetPaidOl9]

@ Aladin:

Can you please help me on my query posted in post #17?

These are the images -
1. Imgur
2. Imgur
3. Imgur
4. Imgur

I have used jarjarbingie's formula. I am sure, I am missing something and can't find out.

Your help is much appreciated.

Thanks.

 

[GetPaidOl9]

Can anyone help me please?

 

[proficient]

Can anyone help me please?

Aladin can help you out, I guess he sent a solution few days ago, did you check...?

 

[GetPaidOl9]

Aladin can help you out, I guess he sent a solution few days ago, did you check...?

I tried his solution, but I don't know anything about Array. I didn't understand, Column A contains formulae already, then how can paste the copied (Aladin's) formula in A10 by Ctrl+Shift+Enter.

Please help me.

 

[GetPaidOl9]

Please help me...

 

[jarjarbingie]

it's really hard to find out what is and what isn't working for you since only part of your spreadsheet is what we see..

Please help me...