Cakz Primz
Board Regular
- Joined
- Dec 4, 2016
- Messages
- 102
- Office Version
- 365
- Platform
- Windows
Hello Folks,
I need your help and assistance, I need to lookup only for distinct or unique value.
I have a data which contains of date, and mostly duplicate, in column A. Starting from row # 2.
I want to lookup in column B based on column A but only for distinct value, is it possible to do it whether with VBA or function?
I try to use UNIQUE function but it gave me SPILL error
Thanks in advance.
prima
I need your help and assistance, I need to lookup only for distinct or unique value.
I have a data which contains of date, and mostly duplicate, in column A. Starting from row # 2.
I want to lookup in column B based on column A but only for distinct value, is it possible to do it whether with VBA or function?
I try to use UNIQUE function but it gave me SPILL error
Thanks in advance.
prima