Ianwillo123
New Member
- Joined
- Oct 19, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all,
I have a table or contains data like the below and as you can see there are some duplicates of IDs;
ID
966368
1004275
1004275
1004275
998516
What I’m trying to do is on another table on another sheet (milestonesis count how many times the ID exists.
I am using a vlookup but it’s not working, can anyone help where I am going wrong?
=Count(vlookup[@[id],Milestones[#all],3,false))
Thanks all
I have a table or contains data like the below and as you can see there are some duplicates of IDs;
ID
966368
1004275
1004275
1004275
998516
What I’m trying to do is on another table on another sheet (milestonesis count how many times the ID exists.
I am using a vlookup but it’s not working, can anyone help where I am going wrong?
=Count(vlookup[@[id],Milestones[#all],3,false))
Thanks all