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.