I have data for a greenhouse - specifically each time a bulb or ballast is changed. There are over a thousand lights, each has a unique identifier. Each week the data is updated. There are hundreds of rows. I want to add a column that looks up the unique identifier, takes the most recent repair date (another column in the file), and subtracts the previous repair date for the same unique identifier. This would give me a time between repairs. Make sense?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Same occurence and the time that elapsed.
- Thread starter chipgiii
- Start date
Vaskov17,
It isn't working. Not sure why though. I broke the formula in half and just went after the Large, 1 to see if it selected the largest date. It does. I then went to Large, 2 to see if it selected the second largest date, it doesn't. It continues to select the largest.
Beginning to think this might be more difficult than first thought.
It isn't working. Not sure why though. I broke the formula in half and just went after the Large, 1 to see if it selected the largest date. It does. I then went to Large, 2 to see if it selected the second largest date, it doesn't. It continues to select the largest.
Beginning to think this might be more difficult than first thought.
The difficulty is it is selecting the largest date in the data sheet regardless of unique identifier. I even tried Large, 1, 2, 3, 4, etc. There are multiple lights replaced on any given day so there are always duplicate dates, but not duplicate identifiers. I was hoping a formula would be possible. My first thought was a sumproduct type thing. Right now I have the data in a pivot so I can see each time according to date when there was "same" light replaced. I may just go with this, not what I was hoping but it's doable.
Thanks for your help.
Thanks for your help.