Đang Thực Hiện

164523 Excel Array Help Required

Hello,

I am having some problems working out how I can create a solution for a gap analysis spreadsheet im creating.

I need to find the products that aren't listed in Sheet 1 by making excel refer to an array in Sheet 2.

For example. The following products are listed in sheet 1..

ICE BREAK COFF 500ML

ICE BREAK COFF 750ML

RUSH F/FREE 500ML

BREAKA 500ML

In total there are 6 products in the array on sheet 2.

I need to find which products aren't being displayed in Sheet 1 by referring to the array in Sheet 2, and then printing them in Sheet 1 into a seperate column which states that they are not ranged..

I also need the formulas to skip the results columns.

I have attached the spread sheet for your reference.

[url removed, login to view]

Anyhelp would be greatly appreciated....

Kỹ năng: Bất kì công việc gì, Visual Basic

Xem thêm: free excel help, need help seperate, excel rush, excel formulas, coff, sheet excel visual basic, excel array, help creating, visual basic problems excel, create excel formulas, products excel sheet, required gap, products sheet excel, column excel, help required, spreadsheet solution, spread excel, formulas spreadsheet, spread sheet excel, free help, formulas excel, create excel visual basic, excel problems, printing required, spreadsheet basic formulas

Về Bên Thuê:
( 0 nhận xét ) Brisbane, Australia

Mã Dự Án: #1910714