Hello
I am working for a recruitment company and I need to sort daily feedbacks for our employees. I have a sheet with all our employees (TRS Workforce), I get a list from a program and paste it into a new sheet (called MyTime Sim) and I get another list from a different program with all feedbacks (ADAPT Sim). Number of rows differ everytime.
I want to retrieve from MyTime Sim sheet only employees from "On Premises" (L column) tab and have an X in cell (if they have an X in cell, it means they have clocked in and are inside), then if they are inside I need to sort only people from my agency (lookup into TRS Workforce) and then, if they match and are in, to lookup into ADAPT Sim and retrieve only employees with a feedback then copy into another sheet their User ID, Employee Name, Process and Level (from ADAPT Sim).
I have used an array forumula, but it takes too much and at work probably will crash my computer. At the bottom you will see what formula I have used.
Also, if there is any other way without using VBA can replay it, please?
Can someone please help me?
TRS Workforce
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:100px;"><col style="width:82px;"><col style="width:124px;"><col style="width:129px;"><col style="width:113px;"><col style="width:165px;"><col style="width:134px;"><col style="width:125px;"><col style="width:159px;"><col style="width:140px;"><col style="width:80px;"><col style="width:153px;"><col style="width:100px;"><col style="width:106px;"><col style="width:123px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
MyTime Sim
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:110px;"><col style="width:110px;"><col style="width:106px;"><col style="width:182px;"><col style="width:159px;"><col style="width:93px;"><col style="width:59px;"><col style="width:79px;"><col style="width:100px;"><col style="width:85px;"><col style="width:131px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
ADAPT Sim
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Test
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:90px;"><col style="width:194px;"><col style="width:80px;"><col style="width:194px;"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I am working for a recruitment company and I need to sort daily feedbacks for our employees. I have a sheet with all our employees (TRS Workforce), I get a list from a program and paste it into a new sheet (called MyTime Sim) and I get another list from a different program with all feedbacks (ADAPT Sim). Number of rows differ everytime.
I want to retrieve from MyTime Sim sheet only employees from "On Premises" (L column) tab and have an X in cell (if they have an X in cell, it means they have clocked in and are inside), then if they are inside I need to sort only people from my agency (lookup into TRS Workforce) and then, if they match and are in, to lookup into ADAPT Sim and retrieve only employees with a feedback then copy into another sheet their User ID, Employee Name, Process and Level (from ADAPT Sim).
I have used an array forumula, but it takes too much and at work probably will crash my computer. At the bottom you will see what formula I have used.
Also, if there is any other way without using VBA can replay it, please?
Can someone please help me?
TRS Workforce
* | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O |
1 | Employee ID | User ID | Employee Name | Badge Barcode ID | Department ID | Employment Start Date | Employment Type | Employee Status | Manager Name | Temp Agency Code | Job Title | Management Area ID | Shift Pattern | Process | Contact Number |
15 | 101248396 | kaushall | Kaushally,Klair | 11269694 | 1200050 | 06-Jun-16 | 3PTY | Active | Cole,Joe | TRS | Whse Assoc | 13 | DC4-0800 | Picking | * |
20 | 101249251 | issafah | Issafah,Muhammad | 11085494 | 1200050 | 07-Jun-16 | 3PTY | Active | Cole,Joe | TRS | Whse Assoc | 13 | DB3-0800 | Picking | * |
22 | 100794918 | weldeabk | Kefle,Weldeab | 11117768 | 1200070 | 25-Sep-15 | 3PTY | Active | Coltman,Macy Elizabeth | TRS | Whse Assoc | 27 | NA5-1900 | IC/QA/CS | * |
24 | 101249246 | annature | Turek,Anna | 11180696 | 1200060 | 07-Jun-16 | 3PTY | Active | Bickley,Connor David | TRS | Whse Assoc | 17 | NB3-1900 | Pack - Batch | * |
25 | 100827767 | grechia | Grechi,Alessandro | 11213470 | 1200070 | 09-Oct-15 | 3PTY | Active | Coltman,Macy Elizabeth | TRS | Whse Assoc | 27 | NA5-1900 | IC/QA/CS | * |
26 | 101263294 | hilitanu | Hilitanu,Remus | 212912 | 1200050 | 14-Jun-16 | 3PTY | Active | Farmer,Christopher | TRS | Whse Assoc | 13 | DB3-0800 | Picking | * |
29 | 101249238 | hayatulz | Zazay,Hayatullah | 224183 | 1200050 | 07-Jun-16 | 3PTY | Active | Cole,Joe | TRS | Whse Assoc | 13 | DB3-0800 | Picking | * |
32 | 100038829 | lhingley | Hingley,Lisa | 11084059 | 1200 | 30-Sep-15 | 3PTY | Active | Wynn,Trevor | TRS | FC Manager | * | * | - | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:100px;"><col style="width:82px;"><col style="width:124px;"><col style="width:129px;"><col style="width:113px;"><col style="width:165px;"><col style="width:134px;"><col style="width:125px;"><col style="width:159px;"><col style="width:140px;"><col style="width:80px;"><col style="width:153px;"><col style="width:100px;"><col style="width:106px;"><col style="width:123px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
MyTime Sim
* | B | C | D | E | F | G | H | I | J | K | L |
1 | Employee ID | Employee Name | Employee Logon | Schedule Group | EE Type | Manager Name | Agency Name | Location | Cost Center | Badge Number | On Premises |
2 | 101202785 | Abbaas, Hasan | habbaas | DH3-0800 | H | Gupta, Puneet Bansal | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 2813283 | * |
3 | 100721642 | Abbas, Ahmad | abahmad | NB3-1900 | H | Smith, Lee | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 3728919 | X |
4 | 101272373 | Abdalbaree, Somia | abdalbar | DC4-0800 | H | Ellis, James | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 3729029 | * |
5 | 101229682 | Abdelshafa, Haytham | abdelsha | DB3-0800 | H | Gupta, Puneet Bansal | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 4432041 | * |
6 | 100645644 | Abdullah, Mohamed | 100645644 | NN2-1900 | H | Yadwad, Siddharth | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | * | * |
7 | 101218109 | Abdullah, Omer | omerabdu | DA5-0800 | H | Farmer, Christopher | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 4431673 | * |
8 | 101207019 | Abdulle, Yusuf Ahmed | abdulley | DC4-0800 | H | Ellis, James | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 3740480 | * |
9 | 101275013 | Abdulrahman, Amaan | abdamaan | DA5-0800 | H | Stys, Artur | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 4431386 | * |
10 | 100875253 | Abnam, Mohammed | abnamm | NB3-1900 | H | Davies, John Anthony | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 3552132 | X |
11 | 101013899 | Abraha, Simon | abrsimon | NC4-1900 | H | Smith, Martin | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 3160423 | X |
12 | 101281367 | Abraha, Tedros | atedros | NB3-1900 | H | Smith, Lee | TRS-TRANSLINE | BHX1 - Birmingham, UK | Fulfillment Center | 3728916 | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:110px;"><col style="width:110px;"><col style="width:106px;"><col style="width:182px;"><col style="width:159px;"><col style="width:93px;"><col style="width:59px;"><col style="width:79px;"><col style="width:100px;"><col style="width:85px;"><col style="width:131px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
ADAPT Sim
* | A | B | C | D | E | F | G | H | I | J | K |
1 | Warehouse | Employee ID | Employee Login | Employee Name | Employment Status | Employment Type | Manager Name | Created Date | Type | Level | Status |
2 | BHX1 | 1.01E+08 | mokhalil | Khalil,Mohammed | Active | T | Gupta,Puneet Bansal | 2016-06-25T17:01:14.702Z,1466874074702 | BEHAVIORAL | SUPPORTIVE_CONVERSATION | PENDING_REVIEW |
3 | BHX1 | 1.01E+08 | stafie | Stafie,Constantin | Active | T | Tarnaud,Florian | 2016-06-25T16:31:07.969Z,1466872267969 | BEHAVIORAL | SUPPORTIVE_CONVERSATION | PENDING_REVIEW |
4 | BHX1 | 1.01E+08 | floridum | Dumitru,Florin | Active | T | Cole,Joe | 2016-06-25T16:26:55.450Z,1466872015450 | BEHAVIORAL | SUPPORTIVE_CONVERSATION | PENDING_REVIEW |
5 | BHX1 | 1.01E+08 | janototh | Toth,Janos | Active | T | Tiwana,Harby | 2016-06-25T16:07:19.695Z,1466870839695 | BEHAVIORAL | CONVERSATION | PENDING_REVIEW |
6 | BHX1 | 1.01E+08 | navakhta | Akhtar,Naveed | Active | T | Cole,Joe | 2016-06-25T15:08:02.070Z,1466867282070 | BEHAVIORAL | COUNSELLING | PENDING_REVIEW |
7 | BHX1 | 1.01E+08 | meharali | Ali,Mehar | Active | T | Farmer,Christopher | 2016-06-25T15:00:28.281Z,1466866828281 | BEHAVIORAL | CONVERSATION | PENDING_REVIEW |
8 | BHX1 | 1.01E+08 | darremcw | McWilliams,Darren | Active | T | Tarnaud,Florian | 2016-06-25T13:40:26.453Z,1466862026453 | BEHAVIORAL | SUPPORTIVE_CONVERSATION | PENDING_REVIEW |
9 | BHX1 | 1.01E+08 | hsmz | Hassan,Mohamed | Active | T | Tarnaud,Florian | 2016-06-25T13:33:58.520Z,1466861638520 | BEHAVIORAL | SUPPORTIVE_CONVERSATION | PENDING_REVIEW |
10 | BHX1 | 1.01E+08 | muhma | Ali,Muhammad Shaheed | Active | T | Tarnaud,Florian | 2016-06-25T13:24:33.218Z,1466861073218 | BEHAVIORAL | SUPPORTIVE_CONVERSATION | PENDING_REVIEW |
11 | BHX1 | 1.01E+08 | segunj | Junaid,Segun | Active | T | Ritson,Steven Lea | 2016-06-25T13:03:33.980Z,1466859813980 | BEHAVIORAL | FIRST_WRITTEN_WARNING | PENDING_REVIEW |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Test
* | A | B | C | D | E |
1 | * | * | * | In or not in | TRS |
2 | jasbin | jasbin | * | jasbin | COUNSELLING |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:90px;"><col style="width:194px;"><col style="width:80px;"><col style="width:194px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas | ||||||||
<tbody> </tbody> | ||||||||
Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER! |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4