Warren Egan
New Member
- Joined
- May 5, 2014
- Messages
- 2
I've got a very limited and basic knowledge of Excel. There is one main thing I would like to know and a secondary question that isn't as important. I've searched through google, these forums, Excel's help and tried using the insert function button... but can't find what I am after. I am using Windows 7 and Office 2010.
I'm the leader of a guild in a game and wanted to create a spreadsheet to keep track of everything much easier than having to update every little thing manually in a text document.
One formula I've made is:
That has been applied from K2 to K26, with the cell values changing appropriately.
From B2 to B26 is each members username.
I would like to be able to look up "Honourable Mention" in cells K2:K26, then for it to return the usernames from the same row that it occurs, as a list in a different location for easier viewing for others.
The secondary question:
Is it possible to have excel automatically re-order rows based on the values of a specific column?
I'm the leader of a guild in a game and wanted to create a spreadsheet to keep track of everything much easier than having to update every little thing manually in a text document.
One formula I've made is:
Code:
=IF(H2>=2500,"Honourable Mention",IF(H2>=1500,"Safe",IF(H2>=500,"Activity Needed",IF(H2>=1,"Serious Risk of Being Kicked",IF(H2=0,"KICK")))))
That has been applied from K2 to K26, with the cell values changing appropriately.
From B2 to B26 is each members username.
I would like to be able to look up "Honourable Mention" in cells K2:K26, then for it to return the usernames from the same row that it occurs, as a list in a different location for easier viewing for others.
The secondary question:
Is it possible to have excel automatically re-order rows based on the values of a specific column?