iamjonbeamer
New Member
- Joined
- Apr 11, 2022
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hello,
This is my first time using this forum so I apologize for not fully understanding the standard protocol for asking questions on a board like this.
I am using Excel 2016 and am more or less looking to use a =FILTER formula, however as most of you should know, 2016 doesn't support this function. More or less, I am looking to compile only select lines (lines that have the word "YES" in the "CREATE SHIPPING LABEL?" column) to another sheet. That sheet will then feed into 20 pages to print out a shipping label. I have no problem getting the information from the "Compile" sheet to the shipping label. I just need to get a maximum of 20 lines of information from the "Gift Card Log" sheet to the "Compile" sheet. BUT, only the lines with the word "YES" in the "CREATE SHIPPING LABEL?" column without any duplicates.
The idea is as the user of the sheet I will select the lines I want to print on my shipping labels by selecting "YES" and the information will be pulled accordingly. Allowing me to skip lines, work back and forth and maybe do it again for the same line in the future. Since i am horrible at explaining this stuff, I am sharing photos of what I want it to do below.
This formula {=INDEX('Gift Card Log'!A2:M1048576,MATCH("YES",'Gift Card Log'!M2:M1048576,0),1)} does work for getting information where I need it, however it will duplicate results and I only want each result pulled 1 time.
This is my first time using this forum so I apologize for not fully understanding the standard protocol for asking questions on a board like this.
I am using Excel 2016 and am more or less looking to use a =FILTER formula, however as most of you should know, 2016 doesn't support this function. More or less, I am looking to compile only select lines (lines that have the word "YES" in the "CREATE SHIPPING LABEL?" column) to another sheet. That sheet will then feed into 20 pages to print out a shipping label. I have no problem getting the information from the "Compile" sheet to the shipping label. I just need to get a maximum of 20 lines of information from the "Gift Card Log" sheet to the "Compile" sheet. BUT, only the lines with the word "YES" in the "CREATE SHIPPING LABEL?" column without any duplicates.
The idea is as the user of the sheet I will select the lines I want to print on my shipping labels by selecting "YES" and the information will be pulled accordingly. Allowing me to skip lines, work back and forth and maybe do it again for the same line in the future. Since i am horrible at explaining this stuff, I am sharing photos of what I want it to do below.
This formula {=INDEX('Gift Card Log'!A2:M1048576,MATCH("YES",'Gift Card Log'!M2:M1048576,0),1)} does work for getting information where I need it, however it will duplicate results and I only want each result pulled 1 time.
