Hi,
I see my latest post remains un-answered. Never mind. Got another question then.
Id like to give my greyhounds rating (rank) but the problem is if copy and paste its not working.
Using this formula:
=RANK(Y2,$Y$2:$Y$7,0)+COUNTIF($Y$2:Y2,Y2)-1
I understand its because the range is fixed but how to make it work ?
Any ideas ?
Cant copy and paste "RANK" formula
-
ilovepizza82
- Posts: 493
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
You do not have the required permissions to view the files attached to this post.
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
This ranks the bsp but you'll use your own col refs...just fill it down (alt e,i,d)
You do not have the required permissions to view the files attached to this post.
-
ilovepizza82
- Posts: 493
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Shaun...you are awesome !
Thank you !
Thank you !