| Book1 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | Unique ID | Number | Gate | Present | Week | Month | Year | 4 to 5 | 5 to 6 | ||||
| 2 | HDYUIPMN | 4 | MLC | 12/24/2021 | 52 | Dec | 2021 | 0 | 0 | ||||
| 3 | HDYUIPMN | 5 | MLC | 1/1/2022 | 1 | Jan | 2022 | 2 | 0 | ||||
| 4 | HDYUIPMN | 6 | MLC | 2/2/2022 | 6 | Feb | 2022 | 2 | 1 | ||||
| 5 | GLHLOOP | 4 | GYT | 1/1/2022 | |||||||||
| 6 | GLHLOOP | 5 | GYT | 2/2/2022 | |||||||||
| 7 | ITPPPJK | 4 | MLC | 12/24/2021 | |||||||||
| 8 | ITPPPJK | 5 | MLC | 1/1/2022 | |||||||||
| 9 | UUFOOO | 4 | MEG | 1/1/2022 | |||||||||
| 10 | UUFOOO | 5 | MEG | 2/2/2022 | |||||||||
Sheet1 | |||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| H2:H4 | H2 | =TEXT(D2,"mmm") |
Hi guys, I need the data as in green highlighted area, source will be "A1:D10"
Need the number of ID's which numbers got increased from number 4 to number 5 as well as number 5 to number 6 from column "B" respective with the date.
Thanks in advance.
