Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like
Posting as :
works at
You are currently posting as works at

Can you be more specific with what you are trying to do to the item numbers? What issues are you having with looking up the status?

Cool!
I have a ups or FedEx tracking number in one column
Then have some magic formula that will take that number and have another column that says like “waiting to be picked up”, “in transit” or “delivered”

Can be done with VBA. No formula exists for this.

like

Related Posts

My manager scheduled a feedback conversation and I know it's bc I've made some noticeable mistakes lately due to moving too fast, not being able to focus, racing thoughts, etc. I'm seeing a therapist about whether I have ADHD and if so, what tx looks like; we started the intake process which will be continued in my 2nd appointment, which is after the feedback convo meeting. Is it worth telling my mgr something eg I recognize the careless mistakes and I'm in the process of seeing tx to help?

like

I need 11 L to connect with friends.plz help me to get that

like

What's up with the aggressive driving in Seattle?

like

HR professionals,
If you could immediately acquire any new skill, what would it be? If you're comfortable doing so, tell us why.

like

Older, successsful FAs: How do you suggest a younger female in the business approach you and talk about joining your team? What areas do advisors like you need help with?

like

Hey fishes, aside from the obvs candidates (fjord, Ideo, snook, deloitte digital, ey Parthenon, pwc consumer bit), who else is doing good work in the UX research/service design space? UK/Europe based.

like

Oliveira vs Makhachev for the UFC Lightweight title, Sat, Oct 22 - where are we watching it? Drop the addy!

What is a good salaray range for sr data analyst in the dfw area?

Hello All,
Is anyone joined CBA recently. Is the onboarding will be virtual or have to visit office?

like

Is anyone’s company offering to pay portion of your rent as home office expense? Especially if company is no longer paying for commercial office space?

like

Is it weird that I hate attending work happy hours because all people do is talk about work?

like

Is there a "too old" stage to pursue a master's? Currently 25, 3 YOE

like

Boutique vs T2? All else equal

like

Anyone have any advice/best practices on the best way to collect feedback in a workshop?

like

I work for a small agency and manage our internal marketing acct. We had very few processes in place when I started. I’ve since created, implemented, and trained our dept. on project mgmt for clients and am trying to convince the owner to apply those principles to our internal jobs. They are resistant because they just want the work to be done and don’t “want to keep spending money on internal jobs”. I’m confused because we’re doing the work either way and “spending” in labor/resources.

like

Male 🐠, if you and a girl had a “situationship” but obviously had feelings for each other and it had to end for one reason or another, how often do you still think about the girl? Would she be on your mind as you try to move on?

like
like

Best sign up bonus right now that is not the CSP and the Amex platinum?

like

Looking for a gay woman on the east coast (yes I have given up on confining my option only to my city). I’m a clean person, funny, a good chef, good in bed and just overall wholesome. Bonus points if you are a top.

likefunny

Hey guys,

This is an embarassing question to ask but every time I go on a date, guys keep pestering me how am I single and 34. I am too exhausted to answer it.

I know the stereotype is that something is wrong with us. I have days where I can't keep my chin up anymore

like

Additional Posts in Excel Genius

Still don't have xlookup. #fomo

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

How long did it take you to become good at excel? Like fast?

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Any book recommendations on excel modeling for real world business applications?

like

How do I compare two sheets to make sure they are identical?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal