urban_player
New Member
- Joined
- Feb 22, 2019
- Messages
- 14
Hi Message Board,
I am seeking advice on the following:
I have a column which contains a reference. The reference may be seen multiple times in different rows. In this row, there is another column which contains a number between 1 and 20. I'm trying to calculate the count of how many times it's seen throughout the sheet using another table:
E.g
Data Sheet looks like
Column A: Column C:
SVA-001 1
SVA-001 4
SVA-002 3
SVA-002 3
SVA-002 5
SVA-002 1
SVA-003 4
SVA-004 6
I have another table that has values from 1 to 20. I need to look in Column A for the reference, and then a countif(?) where column C contains the number in the table that has values from 1-20.
What would be the best way, to achieve a lookup using a reference table containing values 1-20.
Reference: Number of times seen
SVA-001 2
SVA-002 3
SVA-003 1
SVA-004 1
I hope this makes sense and any feedback is greatly appreciated. I might be over thinking this or it's friday and my brain has crashed.
Regards,
Urbanuser
I am seeking advice on the following:
I have a column which contains a reference. The reference may be seen multiple times in different rows. In this row, there is another column which contains a number between 1 and 20. I'm trying to calculate the count of how many times it's seen throughout the sheet using another table:
E.g
Data Sheet looks like
Column A: Column C:
SVA-001 1
SVA-001 4
SVA-002 3
SVA-002 3
SVA-002 5
SVA-002 1
SVA-003 4
SVA-004 6
I have another table that has values from 1 to 20. I need to look in Column A for the reference, and then a countif(?) where column C contains the number in the table that has values from 1-20.
What would be the best way, to achieve a lookup using a reference table containing values 1-20.
Reference: Number of times seen
SVA-001 2
SVA-002 3
SVA-003 1
SVA-004 1
I hope this makes sense and any feedback is greatly appreciated. I might be over thinking this or it's friday and my brain has crashed.
Regards,
Urbanuser