Hi,
I have been struggling with the following:
The example workbook contains a list of employee#'s and the amount of times that they worked (days employed).
I want to categorize the employee#'s by giving them a value in a new column from 0 to 6 depending on the amount of days that they were employed.
Please find attached an example with the category table and data.
Last edited by Melon6; 06-08-2015 at 04:33 AM.
For C2 cell
pull down
Please Login or Register to view this content.
Alternatively,
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thanks, that works like a charm.
Didnt know it was that simple
Or this...
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Glad we could help.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.
In addition, the columns A and B are in the real spreadsheet a pivot table. If i try to pull the formula down with a reference to the first cell (B2) it won't change. All the rows keep linking with B2.
So, how do I make the formula responsive to other rows if I pull it down when linked with a pivot table?
I'm applying Ali's Lookup formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks