Forum

Sean Schubert
@seanexcel
Active Member
Joined: Jun 1, 2022
Topics: 1 / Replies: 3
Reply
RE: FILTER spill values giving #VALUE! error due to character length

The thing is I have multiple columns of which the data doesn't need to appear as well as multiple selection criteria that is required hence the reason...

3 years ago
Reply
RE: FILTER spill values giving #VALUE! error due to character length

Hi Catalin, Thanks for responding. I've attached a file with some random data. Due to confidentiality I cant upload my working file but the attachm...

3 years ago
Reply
RE: INDIRECT drop-down list

Note that this solution may not be the cleanest. In your main file you can create a table which will have the display names and a reference table w...

3 years ago