baigshehzad
New Member
- Joined
- Sep 24, 2006
- Messages
- 9
I have prepared data for 140 agents but when i apply the rank formula it gives me rank 1 in the first cell but when i drag it down it still gives me rank 1 with a green colour mark on the top right hand corner of the cell. When i click the cell some sort of mark comes there and when i click on the mark there are several option like Update formula to include cells, help on this error. So if a want a proper ranking i have to click it one by one and do the ranking which is very tidious. Is there any other simpler way for this? How do i come out of this error? Please advice