Hi,

I need to fill an 20x20 block of cells with a formula based on the
following......

=(indirect(WaferNum) Die1)

where the die number changes from 1 to 400. is there a way i can
generate the formulae easily or do i have to edit the die number in
each of the 400 cells.

Any suggestions?

Thanks in advance

Simon

Simon,

Don't understand the formula, but with indirect you can use the row number,
like so

=INDIRECT("A"&ROW())

simplistic but hopefully you get the idea

--
HTH

Bob Phillips

"simon_pykett - at - dynexsemi.com" wrote in
message ups.com...
Hi,

I need to fill an 20x20 block of cells with a formula based on the
following......

=(indirect(WaferNum) Die1)

where the die number changes from 1 to 400. is there a way i can
generate the formulae easily or do i have to edit the die number in
each of the 400 cells.

Any suggestions?

Thanks in advance

Simon

Sorry Bob,

I'll try and explain a little further.

I have a list of 400 test results from a number of wafers. The region
of the spreadsheet containing the test results has ranges named as
follows
Wafer1 = A1:A400, Wafer2 = B1:B400, Wafer3 = C1:C400
Die1 = A1:C1, Die2 = A2:C2......etc to Die400

I'm looking to put the results in a 20x20 array representing the wafer
with conditional formatting to show pass/fail based on the test result.
In the past when i've only had a small number of results (32) i've used
the =(indirect(WaferNum) DieNum) formula and manually changed the
reference to each DieNum (1 to 32).

WaferNum refers to the value of a dropdown listbox containing the names
of the Wafer1...Wafer3 ranges.

Hope this clarifies things a bit.

Simon,

I think I get it, but can you send me a sample workbook, with your data and
what you want to see?

--
HTH

Bob Phillips

"simon_pykett - at - dynexsemi.com" wrote in
message oups.com...
Sorry Bob,

I'll try and explain a little further.

I have a list of 400 test results from a number of wafers. The region
of the spreadsheet containing the test results has ranges named as
follows
Wafer1 = A1:A400, Wafer2 = B1:B400, Wafer3 = C1:C400
Die1 = A1:C1, Die2 = A2:C2......etc to Die400

I'm looking to put the results in a 20x20 array representing the wafer
with conditional formatting to show pass/fail based on the test result.
In the past when i've only had a small number of results (32) i've used
the =(indirect(WaferNum) DieNum) formula and manually changed the
reference to each DieNum (1 to 32).

WaferNum refers to the value of a dropdown listbox containing the names
of the Wafer1...Wafer3 ranges.

Hope this clarifies things a bit.