Hi, and thanks for your time. Hope the title sort of makes sense.
I've attached a spreadsheet showing the effect I'm trying to achieve. A list (which changes weekly) contains employee details and length of service. Based on the length of service I need to build a new list grouping the employees based on the service length.
Any help would be much appreciated.
Many thanks
An option would be a solution using 2 helper columns. Are you interest?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Absolutely - don't understand what helper columns are but I'm willing to try anything. Thank you
Ok then. Pls give me some time for this!
Ok. Here we are.
In F2 and copy down.(Column F will be a helper and hidden column)
Then in G2 this ARRAY(Meaning that you have to confirm this using Control+Shift+Enter-Not just Enter) Formula.
=IF(C2<=13;"A";IF(AND(C2>13;C2<=26);26;IF(AND(C2>26;C2<=39);39;IF(AND(C2>39;C2<=52);52;IF(AND(C2>52;C2<=104);104;150)))))
Drag down. Same formula for the other colums changing the bold red number.=IFERROR(INDEX($D$2:$D$18;SMALL(IF($F$2:$F$18=13;ROW($D$2:$D$18)-1);ROW(D1)));"")
In all my formulas here you need to change semi colons to comma. But in The example sheet is OK!
Wow! I still have much to learn! Thank you.
You are welcome!
All of us, always learn something new every single day.
Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks