excelnewbie
New Member
- Joined
- Aug 28, 2002
- Messages
- 2
Hi-
I have been put to the task of preparing a spreadsheet. Scary enough, but they require formulas! yikes!
Here is my plight:
I have column A, which contains employee names. I have column B, which contains the Days Outstanding. I then have column C, which will contain the rank... the ranking is 0-59 days = 10, 60-64 days = 9, 65-69 days = 8, and so on, all the way down to 110+ days = 0
what I need is once I enter in the info to columns A and B, I need the ranking to automatically pick up in column C. Is this possible????
Thank you so much for any help you can provide to a technically challenged individual!
-Gaia Marie
I have been put to the task of preparing a spreadsheet. Scary enough, but they require formulas! yikes!
Here is my plight:
I have column A, which contains employee names. I have column B, which contains the Days Outstanding. I then have column C, which will contain the rank... the ranking is 0-59 days = 10, 60-64 days = 9, 65-69 days = 8, and so on, all the way down to 110+ days = 0
what I need is once I enter in the info to columns A and B, I need the ranking to automatically pick up in column C. Is this possible????
Thank you so much for any help you can provide to a technically challenged individual!
-Gaia Marie