Forum

CK_One
@ck_one
Forum Home   |   Recent Posts
Active Member
Joined: Mar 16, 2017
Profile Activity
Topics: 2 / Replies: 5
AllTopicsReplies
Reply
RE: Count unique values based on two criteria

Thanks Sunny, Your suggestion work perfectly Kind regards, Craig

8 years ago
Forum
General Excel Questions & Answers
Topic
Count unique values based on two criteria
8 years ago
Forum
General Excel Questions & Answers
Replies: 2
Views: 153
Reply
RE: How to create a validated list that ignores blank cells?

Hi Sunny, That worked perfectly, thanks for your help much appreciated. Craig

8 years ago
Forum
General Excel Questions & Answers
Reply
RE: How to create a validated list that ignores blank cells?

Apologies Sunny, I have been away. Please see work book attached

8 years ago
Forum
General Excel Questions & Answers
Reply
RE: How to create a validated list that ignores blank cells?

Thanks Sunny, works perfectly Going off the topic, I would like the name list to be alphabetically sorted. I tried the formula below which seeme...

8 years ago
Forum
General Excel Questions & Answers
Reply
RE: How to create a validated list that ignores blank cells?

Forgot to add that I am using the formula in the defined list. ='Reference Sheet'!$B$3:INDEX('Reference Sheet'!$B$3:$B$1000,SUMPRODUCT(--('Referenc...

8 years ago
Forum
General Excel Questions & Answers
Topic
How to create a validated list that ignores blank cells?
8 years ago
Forum
General Excel Questions & Answers
Replies: 7
Views: 131