Sorting dynamic lists with cell references

[0ops Sorry]

For anyone who can help,


Currently I've been trying to find a quick easy way to sort cells numerically when they are referenced to other cells in the spreadsheet. this way I can keep the data in its original order and location, then just reference to sort it somewhere else.

I work with a lot of data analysis and being able to run data in and have it automatically sort would save me a ton of time instead of copy, paste, sort, add to graph.

If you have anyidea if this is even possible that would be great!
(Cell formulas would be ideal if possible.)


Thanks,
-0ops

P.S. I've looked at many attemps at solutions and have been trying to come up with my own method but I keep getting #REF in all the cells.

 

[J.Ty.]

Try this:

Book1
	A	B	C
1	11	7	2
2	4	4	2
3	6	5	2
4	15	11	4
5	12	10	6
6	2	1	10
7	15	12	11
8	2	2	11
9	10	6	11
10	19	13	12
11	11	8	15
12	19	14	15
13	2	3	19
14	11	9	19
Sheet1

Cell Formulas
Range	Formula
B1	=COUNTIF(A$1:A$14,"<"&A1)+COUNTIF(A$1:A1,A1)
C1	=INDEX(A$1:A$14,MATCH(ROWS(A$1:A1),$B$1:$B$14,0))

J.Ty.

 

[0ops Sorry]

That works great, I looked for quite a while and couldn't find anything, thanks a ton!

 

[0ops Sorry]

repost

 

[J.Ty.]

Thanks for the feedback and good luck!

J.Ty.