# formula help w/ screen shot example...

##### Board Regular
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 to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

##### MrExcel MVP
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.

Replies
3
Views
86
Replies
1
Views
277
Replies
1
Views
177
Replies
16
Views
434
Replies
2
Views
243

1,186,808
Messages
5,959,938
Members
438,455
Latest member
Beverly Jarrell

### 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?

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