formula help w/ screen shot example...

M.E. MAD

Board Regular
Joined
Nov 13, 2003
Messages
60
I have several worksheets that contain data such as below and am attempting to generate a list based on checking all worksheets for unique order based on Exchange column and work order column. Once the list is generated I have a formula that will go through and check for all hours charged to the re
TIME 2004-1.xls
ABCDEFGHIJKLMNO
1
2WORKDESCRIPTIONBCJOCBCEXCHANGEWORKORDERFUNCTIONTOTALHOURS
30
48478P001BK2422.100
58329PR02GR-0272422.100
68329PR02GR-0362422.100
78329PR02GR-0142422.100
88478P001AT2422.100
98329PR02GR-0392422.100
100
110
120
130
140
150
16EMPLOYEESIGNATURESUPERVISORSIGNATURETOTALHOURS
170
Sheet2
spective work orders. Thanks for the help...
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Assuming that each sheet has Order# (numbers in Exchange column) in F4:F15. Insert 2 new sheets, name them First and Last, place all of the relevant sheets between First and Last. You can now use in the destination sheet from A2 on:

=INDEX(UNIQUEVALUES(THREED(First:Last!$F$4:$F$15)),ROW()-ROW($A$2)+1)

which must be confirmed with control+shift+enter instead of just enter, then copied down.

Hope those merged cells will not cause any trouble. Unmerge them if needed.

Note. UNIQUEVALUES and THREED are functions from the morefunc.xll add-in.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,493
Messages
5,764,698
Members
425,231
Latest member
mramb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top