Hello,
I've been using these forums for most of my questions,
however I've not seen this one posted before so..
I'm currently working on a client list where each
client has a dedicated row with all of their information.
In column A I have the clients Last name,
In column B I have the clients First name.
In column U I have the name of the person
who referred the client to me: (First name Last name)
What I need is to have column V show me how
many clients this client has referred to me by counting
how many times their name shows up in column U.
I'd like it to be able to update and be linked to the column
rather than having to enter a new formula every time I enter
a new client.
Bookmarks