Can some one show me how to show the cell position on the worksheet that meets a specific critieria. I tried doing "What ifs" and the formula came to a hault after 9 or 10 "What ifs".
Example: I need to show cells that are >0.
A1=1,A2=0,A3=1,A4=0,A5=0,A6=1/2
Answer:
A1,A3,A6
I would use the values in each answer, A1,A3,A6 in my calculation.
My objective is to calculate the amount of time that's alotted in a 8 hour period for a person to walk from point to point and back a pre- calculated number of frequencies.
In the case of the example, a person would walk the distance from A1 to A3 100% of the time, and walk from A3 to A6 50% of the time. If the pre-calculated time alotted to walk between each cell is 3.8 minutes / 8 hours, then the end result to the example problem would total to 13.3 minutes / 8 hours.
I hope this is clear.
Thank you.
This message was edited by BIGHAIR on 2002-02-23 10:27
This message was edited by BIGHAIR on 2002-02-23 10:44
This message was edited by BIGHAIR on 2002-02-23 10:47
Example: I need to show cells that are >0.
A1=1,A2=0,A3=1,A4=0,A5=0,A6=1/2
Answer:
A1,A3,A6
I would use the values in each answer, A1,A3,A6 in my calculation.
My objective is to calculate the amount of time that's alotted in a 8 hour period for a person to walk from point to point and back a pre- calculated number of frequencies.
In the case of the example, a person would walk the distance from A1 to A3 100% of the time, and walk from A3 to A6 50% of the time. If the pre-calculated time alotted to walk between each cell is 3.8 minutes / 8 hours, then the end result to the example problem would total to 13.3 minutes / 8 hours.
I hope this is clear.
Thank you.
This message was edited by BIGHAIR on 2002-02-23 10:27
This message was edited by BIGHAIR on 2002-02-23 10:44
This message was edited by BIGHAIR on 2002-02-23 10:47