Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make a formula refer to given data even if I do a sort f.
I want to create a formula in a spreadsheet that refers to specific cells of
data. However, I also want to be able to sort my data but keep the formula refering to the same information. IE, say I have a collumn of ten numbers. I would like to be able to have a formula take the average of the first 5 listed. If I then did a sort function of these ten numbers that changes the order of the numbers, I want my formula to have the same result because it is still referencing the correct information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
matching data formula? | Excel Worksheet Functions | |||
What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions |