formula help w/ screen shot example...

[M.E. MAD]

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
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	WORKDESCRIPTION			BCJOC	BC	EXCHANGE				WORKORDER		FUNCTION		TOTALHOURS
3														0
4						847				8P001BK		2422.10		0
5						832				9PR02GR-027		2422.10		0
6						832				9PR02GR-036		2422.10		0
7						832				9PR02GR-014		2422.10		0
8						847				8P001AT		2422.10		0
9						832				9PR02GR-039		2422.10		0
10														0
11														0
12														0
13														0
14														0
15														0
16	EMPLOYEESIGNATURE						SUPERVISORSIGNATURE							TOTALHOURS
17														0
Sheet2

spective work orders. Thanks for the help...

 

[Aladin Akyurek]

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.