Spreadsheets help
Kelly7
Registered Posts: 218 Beyond epic contributor 🧙♂️
Hi
We started spreadsheets last week at college and have our exam next week, not much time and we've just been working through questions given to us and asking our teacher when we are stuck - which is a lot for me as I haven't done much work with spreadsheets before.
Not sure if this isn't working because I have a different version of excel at home but I have the formula...
=RANK(N7,($N$7:$N$12),0)
I have copied this down the column but they are all showing as 0. Can anyone help as to where I have gone wrong? I thought the 0 at the end of my formula set the order?
xxx
We started spreadsheets last week at college and have our exam next week, not much time and we've just been working through questions given to us and asking our teacher when we are stuck - which is a lot for me as I haven't done much work with spreadsheets before.
Not sure if this isn't working because I have a different version of excel at home but I have the formula...
=RANK(N7,($N$7:$N$12),0)
I have copied this down the column but they are all showing as 0. Can anyone help as to where I have gone wrong? I thought the 0 at the end of my formula set the order?
xxx
0
Comments
-
Hello Kelly
What version of Excel are you using? I don't think it should make any difference.
Do you have the data you are using? If so can you paste it here or send to me?
I'm not sure that you need the second set of brackets around the cell range ($N$7:$N$12).
The sort criteria can be 1 or 0 depending on ascending and descending order.
Try the formula =RANK(N7,$N$7:$N$12,0)
JC~ An investment in knowledge always pays the best interest ~Benjamin Franklin0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership