The Challenge for the Night - Worksheet Mayhem

[James Russell]

I've been working on this worksheet for a while now. It's generated from the basic instrument report. Basically I need to filter it but just can quite get it there.

At the moment the lights are put into categories of the same type A1, A2, B1, B4, D3, etc. These lamps need to be grouped together and if there are multiples they need to be noted a quantity in a new column at the start of the spreadsheet. This part is fine manageable I believe, throw the Sum on top of the column Fixture ID and I'm guessing although I mightn't be able to do it, create the new quantity column and then a lookup of some sort applied.

The major issue is that each of these lamps may have up to 4 accessories on them. These accessories need to be listed under each of the Fixtures ID's they are relevant to and tallied in the quantity column as well. For the example I am playing with the eventual outcome I would love is something like this:

Any help would be greatly appreciated.

Cheers

James

Edited February 9, 2010 by James Russell

[James Russell]

Woohooo

=SUM('Lighting Device'.'Fixture ID'='Lighting Device'.'Fixture ID')

Just managed to do the quantity... Now the hard part.

[James Russell]

I think that's it...!