Question: Is it possible to have a function in Excel where the second range is the current row the user is current at? For example, if column A has customer numbers then can a user have column B be the current count of rows that have the same customer number? Something like `=countif(A1:Row(), Row())`. So, if the user were on B14 then the function would be `=countif(A1:A14, A14)`. 

I'd rather not use VBA and I'm new to functions in Excel. My apologies if it's a simple answer. I swear that I did search for an answer before firing off this question.

Answer: 
The answer to your question is yes. Use *INDIRECT* function. Something like:

```
=COUNTIF(INDIRECT("A1:A"&Row()), INDIRECT("A"&Row()))

```
You could use something else rather than taking the current row you could have a **drop-down list** with all the ids. The cell remains the same but you will be able to select the number that you want from the list and use it to count.

Have a look here and tell me if you need more help:
<http://www.techrepublic.com/blog/microsoft-office/how-to-add-a-drop-down-list-to-an-excel-cell/>