Home

Collapse data

Deleted
Not applicable

we have a spreadsheet w 127,497 rows.. This data contains the serial number and the start and stop time for various pieces of equipment.  We are interested in the number of hours a piece of equipment was used each year. There may be 200 or 300 rows for each piece of equipment.  is there an easy way to separate this by equipment - (spreadsheet is sorted by Serial Number and then  Time and Date Stamp)  - What we truly want is 1st entry for each unique serial # - last entry for 2016, 1st entry for 2017 and last entry for 2017 - for each individual serial #. 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies