Forum Discussion
ZoroBK
Apr 14, 2022Copper Contributor
autofill date a training was completed by item/person
Hello, how are you doing? I have been trying to do something in excel for a few days and I have not figured out a formula that works well. On sheet 1, column A, i have a big list of training item...
- Apr 14, 2022
Here's a possible solution. It does take advantage of the FILTER function, which is new and requires the most recent version of Excel.
ZoroBK
Apr 15, 2022Copper Contributor
I could not manage to get the MAX and FILTER nested. I always get zero. I found an un-elegant way of getting the most recent date, however, it would be cool if i could get the max formula to work.
mathetes
Apr 15, 2022Gold Contributor
Are you able to attach a file here on these boards (without real names)? I'd be happy to take a look.
If not here, maybe in OneDrive or some place similar. Or send me a personal message here at the microsoft site...click on my name and select "Message" up at the top right corner; you can attach a file there that only I will see.
If not here, maybe in OneDrive or some place similar. Or send me a personal message here at the microsoft site...click on my name and select "Message" up at the top right corner; you can attach a file there that only I will see.