User Profile
RobMac14
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Extracting the latest data
Hi I need to construct a data set from a data dump out of an database that will be loaded onto a webportal. At the moment, I have to do it manually, which is time consuming and I'm hoping that there are formulae within Excel that can help me speed this up. In picture below is a sample data set on the left and what I need to extract is the latest entry for a client, their role in column C and present it a a new table/dataset. The latest data is highlighted in gold and that's what I need extracting. I'm aware that I could use the MAX function to select the latest date, but that only produces the date and not the name and category. If anyone can offer some assistance on this I'd be grateful.OneDrive not synch'g folders - about to give up!
Hi, I work in a small, new company and I recently bought our first Microsoft 365 account for the 3 of us. We're all working from home and Teams has been great to connect work together. I've been testing OneDrive for business as we need all access to a series of folders. Previously, we have all used DropBox and have our own DropBox accounts but we wanted to start afresh with central folders for our new company. So we started testing with OneDrive and, quite frankly, it is doing my head in! Despite us all being logged into our 365 accounts, one member can't synchronise anything and another hasn't had a synchronise since 11 November and hence has not changes or additions to the folder structure that I've been working on - yet OneDrive says it's up to date! I'm either missing somehting really simple or OneDrive just isn't up to the job and we'd be better buying a new DropBox account for all of us and ditching it. So as a last ditch attempt to oversome this, I thought I'd post about my experience with it so far in the hoep that someone may be able to point me in the right direction for a fix to this issue. Thanks for reading my post and thinking about how you may be able to help us.
