# Transferring positions out of a table into cells

#### cupcakeua

##### New Member
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!

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### Guru008

##### Board Regular
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

##### Well-known Member
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

##### New Member
Thanks Guru!

Worked perfectly, thanks a lot =)

Replies
0
Views
340
Replies
3
Views
2K
Replies
25
Views
2K
Replies
0
Views
564
Replies
4
Views
512

1,195,671
Messages
6,011,077
Members
441,581
Latest member
rp4717

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back