Hi
Hope i can translate my problem to you guys.
The purpose of this sheet is: up to 600 namned personel can join under one contribution. Ill use sheet1 for enrollment.
A2:A600 is a roll list of groups 1 to 10.
B2:B600 is there full name
C2:C600 is there mobil number
D2:D600 is there education
E2:E600 is date of arival
F2:F600 is date of discharge.
Now, i need to put these names into groups, and il rename Sheet2 to Group 1, Sheets3 to Group2 and so on.
Under group1 to 10 ill need to see the names and mobilenumber joind to that group.
And if one of them discharge and ill change group to notting or 0 they wont be in any group.
Is there anyone that can help me? I know office365 inside got this new not relesed formula (FILTER), but i can use it on that computer.
best regards
Rickard Österlind
Sweden
Bookmarks