I wasn`t able to update my works PC for up to date Excel version. But I have been using Excel subscription on my personal PC through my UNI`s account. At least it did recognize XLOOKUP functions. But it looks like it still missing something. I have added a screenshot with the current Excel version which I am using. It is strange that it seems like it does update only one cell H20, when I filter for USER2. When you update the data, are you then selecting USER2 through G2 filter and it updates all the times on the right side?
Hmm.. It seems like I might need to purchase a current, up to date Excel version? If that is the case can you please advise which version I should go ahead with?
Many Thanks
Kaspars
Hi Kaspars,
That version you have on your Uni PC should work. Please send me the file you're using that you've added the user 2 data to so I can test on my PC.
Mynda
Hi Mynda,
Added as requested- 1.Initial Template with user1, 2. Data from 2nd user 3. My outcome when I add data from user 2 to Template 1
Many Thanks
Kaspars
Hi Kaspars,
It appears to work fine for me. However, there's only one value that's different and that's on October 26 for the Minutes past target confirmation time of 14:00.
Is it that you're expecting different values for the different users and that's why you don't think it's working?
Mynda
Hi Mynda, yes you are correct- I was expecting the values to change. I did start everything from the beginning and added another users data and it worked correctly! 🙂 All the values updated and user filters worked as well. Sorry for taking this long, and thank you for all the help and patience 🙂
No worries, you're welcome 🙂
