Noxqss38242
Board Regular
- Joined
- Sep 15, 2017
- Messages
- 223
- Office Version
- 2016
=IF(N327356="A",0,IFNA(AB327356-LOOKUP(2,1/(N$2:N327356="A")/(B$2:B327356=B327356),AB$2:AB327356),""))
In this formula I'm asking it to search for "A" and how long it has been since "A" was done based off the same identifier in column B.
What I'm wondering is, can this code be modified to look for "A", "B", "C", "E", and "I" at the same time? So instead of possibly 200 days lapsed just for "A" it will show 45 days lapsed based off this new information it is also looking for.
Column B = Numeral Number Assigned to a Truck
Column N = Work Code. ie: A, B, C, D, E, I
Column AB = Date Work Done
In this formula I'm asking it to search for "A" and how long it has been since "A" was done based off the same identifier in column B.
What I'm wondering is, can this code be modified to look for "A", "B", "C", "E", and "I" at the same time? So instead of possibly 200 days lapsed just for "A" it will show 45 days lapsed based off this new information it is also looking for.
Column B = Numeral Number Assigned to a Truck
Column N = Work Code. ie: A, B, C, D, E, I
Column AB = Date Work Done