![]() ![]() Returns a value you specify if a formula evaluates to an error otherwise, returns the result of the formula Returns the serial number of a particular dateįinds one text value within another (case-sensitive) There has to be a better way to do this! While having all of the information transferred over would be very handy, the top priority is that I can see if the package has been deliver yet, and if so, what time that occurred.Īcronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: Fewer Letters Local Scan TimeDestinationOthers TIME ZONEWednesday, July 21, 20218:06 AMTolleson, AZDelivered3:57 AMPHOENIX, AZOn FedEx vehicle for deliver圓:52 AMPHOENIX, AZAt local FedEx facilityTuesday, July 20, 20219:10 PMPHOENIX, AZArrived at FedEx location3:04 PMPEORIA, AZIn transit3:02 AMSPARKS, NVLeft FedEx origin facilityMonday, July 19, 202110:01 PMSPARKS, NVArrived at FedEx location3:10 PMShipment information sent to FedEx12:00 AMSPARKS, NVPicked upCollapse History GET STATUS UPDATESOBTAIN PROOF OF DELIVERY FROM I typically take a tracking numbers such as these-Ĭopy over the below information into individual columns in excelġ88899668192 ADD NICKNAME DeliveredWednesday, Jat 8:06 am DELIVERED Signed for by: CCONWAY ![]() Does anyone know of a way to use VBA/PowerQuery/maybe PowerBI so that I can have all of my tracking numbers listed in column A, run the query, and populate columns b,c,d. I need to look up hundreds of shipments via their FedEx tracking numbers to find their shipment status. I am trying to figure out a way to automate a tedious process I must complete for my job. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts. ![]() Use the appropriate flair for non-questions.Post titles must be specific to your problem. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |