Auto filter -using output
Auto filter -using output
(OP)
Hey all
I have a spreadsheet with a column of beam sizes with their respective data in the columns beside them.im using auto filter so that i can select one particular beam and bring up all that data in one row. I then wish to perform calulations on the row. How ever when i select a new beam size my formula values do not change.
Can someone please tell me how to get my formula to reference the respective beam im selecting?
Thanks
shane
I have a spreadsheet with a column of beam sizes with their respective data in the columns beside them.im using auto filter so that i can select one particular beam and bring up all that data in one row. I then wish to perform calulations on the row. How ever when i select a new beam size my formula values do not change.
Can someone please tell me how to get my formula to reference the respective beam im selecting?
Thanks
shane





RE: Auto filter -using output
try using the index function instead. the input array is list of beams, but have the row/column return the value of the respective beam data. then have the formula referencing that particular beam be the cell returning the beam criteria.
hope this helps . . .
good luck!
-pmover