Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Is there a way to prevent xlookup to bring in duplicate data?
A1: Source
B2: Formula
The data is things like 1 - Segment, 2 - Field, 3 - Range and they repeat several times but I don't want to them to repeat in B2 but rather just pull 1 instance of each.
Maybe I need a filter formula in a helper column to assist?
A1: Source
B2: Formula
The data is things like 1 - Segment, 2 - Field, 3 - Range and they repeat several times but I don't want to them to repeat in B2 but rather just pull 1 instance of each.
Maybe I need a filter formula in a helper column to assist?