Transferring positions out of a table into cells

[cupcakeua]

Hello everyone,

first off im sorry for the title I couldnt form my problem into an understandable sentencene since im struggling with it myself..

My question/problem is the following as seen in this picture:

I have an 5x5 Grid and an simple Table underneath it.
Now if I enter an coordinate (Row+column) into the table the Grid should automaticly catch that addition and insert it into the written position with the numbers of total mentions of said cell.
Like in the example on the right, where the cell "M1" is choosen twice and inserts into the grid the number "2" since there are 2 of them.

My Question to put it simple is if it is even possible in Excel to do something like this and if yes how..

English isnt my main langruage so im sorry if some parts are not 100% clear..

Hope you can help me out!

 

[Guru008]

Hi,

You can count the same with countif formula e.g.

=COUNTIF(F1:F5,"=A"&ROW())

I am able to respond in real time to you until it is solved!

 

[FDibbins]

Welcome to the board

I am not able to view your pic, but based on what you asked...
- No formula can "put" data into another cell, it can only work on the cell that contains it.
- Not sure where "M1" is being selected twice, but if it is the same cell, no formula will be able to count that you entered the same thing, into the same cell, more than once. Formulas are "live", and work only on the current cell contents that they reference.

For both of the above, if that was what you wanted, you will need VBA to do that

 

[cupcakeua]

Thanks Guru!

Worked perfectly, thanks a lot =)