ChrisEngland
New Member
- Joined
- Nov 7, 2018
- Messages
- 3
Can anyone help please?
I have a column A in my worksheet which has a list of user name names and a column B which has a value against each user. Each user will appear several times in column A
I would like to create a list box which just holds the unique names from column A but I'm struggling!
I have found a suggestion via Google but it end in e reference error and I'm struggling to understand why. The formula I'm using to populate the source of a list box is:
=OFFSET(Sheet1!$A$2, 0, 0, COUNT(IF(Sheet1!$A$1:$A$1000=””, "", 1)), 1)
Could anyone shed any light on what I'm doing wrong please?
Thanks
Chris
I have a column A in my worksheet which has a list of user name names and a column B which has a value against each user. Each user will appear several times in column A
I would like to create a list box which just holds the unique names from column A but I'm struggling!
I have found a suggestion via Google but it end in e reference error and I'm struggling to understand why. The formula I'm using to populate the source of a list box is:
=OFFSET(Sheet1!$A$2, 0, 0, COUNT(IF(Sheet1!$A$1:$A$1000=””, "", 1)), 1)
Could anyone shed any light on what I'm doing wrong please?
Thanks
Chris