Pulling out List

[Leonora Bayona]

Hello Ninja Excel,

I would like to ask for help, currently I'm using the microsoft 365 to pull out the list from different tabs within the worksheet, and the formula is working. But when I send it to my colleague its not working because they have a lower version of Excel.
Kindly help me to translate the formula in the PO Pagoda tab that will work for a lower version of Excel.

Regards,
Leonora

 

[Leonora Bayona]

i tried to use this =IFERROR(INDEX('4 COGS PRE PACK'!$D$7:$D$3000,SMALL(IF(('4 COGS PRE PACK'!$A$7:$A$3000=$J$2)*('4 COGS PRE PACK'!$K$7:$K$3000=$B$6),ROW('4 COGS PRE PACK'!$D$7:$D$3000)-ROW('4 COGS PRE PACK'!$D$7)+1),ROWS(R$7:R8))),IF(ROWS(R$7:R8)=1,"No items found","")) but items is duplicated. Please help me how can i remove the duplicates. Thank you

 

[ETAF]

whats the lower version of excel you need it to work in, this matters as a lot of functions are added to different versions of excel

Maybe VBA is the way to go - I dont provide VBA to forums

 

[MikeVol]

Leonora Bayona​

It was already suggested above

Maybe VBA is the way to go

that yes, this can be solved with a VBA script. I've attached the file below with this solution; open it and play with it. I think you'll understand the meaning and logic. Good luck.

 

[Leonora Bayona]

whats the lower version of excel you need it to work in, this matters as a lot of functions are added to different versions of excel

Maybe VBA is the way to go - I dont provide VBA to forums

using 2019 Version, is there a way to use the index match and put column helper. Honestly, i havent use VBA. I will put in my list to learn basic of this.

Leonora Bayona​

It was already suggested above

that yes, this can be solved with a VBA script. I've attached the file below with this solution; open it and play with it. I think you'll understand the meaning and logic. Good luck.

Thank you Mike, please help to give a background for VBA. I havent use VBA before.

 

[MikeVol]

please help to give a background for VBA

You can find information about VBA online yourself. I can't tell you everything about the VBA programming language in your area. And I'm a terrible teacher.

 

[daievans]

using 2019 Version, is there a way to use the index match and put column helper. Honestly, i havent use VBA. I will put in my list to learn basic of this.

Thank you Mike, please help to give a background for VBA. I havent use VBA before.

VBA is scarier than it appears! Start small with code to do minor tasks, and before you know it, you'll be challenging yourself to more complicated code. Fortunately, there are plenty of resources out there.

@MikeVol has kindly started the process for you - kudos to him!

 

[daievans]

VBA is scarier than it appears! Start small with code to do minor tasks, and before you know it, you'll be challenging yourself to more complicated code. Fortunately, there are plenty of resources out there.

@MikeVol has kindly started the process for you - kudos to him!

Duh - VBA is less scary than it appears ..... which is the opposite of what I said above ...