Excel return how many times a value appears

I have an excel file that I keep track of what cards I have for a game. What I want to do is to have a field that whenever I click on it, will prompt me to click on a cell and get the text of the cell as a variable. Let's say for example I have this matrix

| 1 | 2 | 3 | 4 | 5 | |----|----|----|----|----| | fe | de | as | rf | sa | | as | ds | fr | cd | zx | | as | rf | gt | er | we |

User clicks on the field with this formula

=COUNTIF(C2:G12;{Text of the field user will click next}) 

So if user clicks on a cell that writes as I want it to return number 3, since value as appears 3 times on the matrix.


Category: microsoft excel Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.241 (s). 12 q(s)