Coping rank for whole dataset in excel
Solved/Closed
Related:
- Coping rank for whole dataset in excel
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Kernel for excel - Download - Backup and recovery
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Apr 9, 2010 at 06:25 AM
Apr 9, 2010 at 06:25 AM
To keep address of a cell constant you need to use $
$A$1 is absolute to A1 always
$A1 is absolute column A but row will change
A$1 is absolute row 1, but column would change
=rank(A1;A$1:A$166,0)
$A$1 is absolute to A1 always
$A1 is absolute column A but row will change
A$1 is absolute row 1, but column would change
=rank(A1;A$1:A$166,0)
Apr 9, 2010 at 06:36 AM
you saved my life:)