Đ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: www excel, the spread .com, mediafire.com, ice com, how to find problems, free excel help, need help to seperate, excel rush, Excel Formulas, break the ice, analysis excel, analysis excel spreadsheet, excel com create sheet, analysis required, gap analysis excel, coff, analysis sheet excel, sheet excel visual basic, excel array, help creating, visual basic problems excel, create excel formulas, products excel sheet, visual basic create excel sheet, gap analysis

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

Mã Dự Án: #1910714