Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

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

Never heard of it. Can you tell us more?

helpful

Select based on content is huge! Also can quickly clean up text with excessive spaces (helps with vlookups)

like

It’s essentially a program that runs as an Excel add-in and does a lot of different functions via pre written macros. Pretty much anything you can think of it has an option to run that.

I loved it. My current firm blocks it though it drives me NUT

I actually removed it because I felt like it slowed down my excel (to be fair I already have like 5 firm-specific add-ins running). It had some great functions though

It can cause Excel to be buggy when running in other programs, but it’s worth having in your toolkit.

Related Posts

Vasya is sending big fluffy hugs and kisses to everyone on this beautiful Wednesday morning

Post Photo
likeupliftinghelpfulfunny

I was just contacted by a recruiter and he saw my LinkedIn and said "oh I just saw your picture, you are so pretty"

What's going on with people these days 💀

likefunny

Trying to find recruiting firms to help me find my next project / program management role. I'm struggling to determine which firms can help with PM roles AND I'm struggling to get the ones I do find to respond to me.

It may have something to do where I'm at in my career - 15+ years of PM experience & director-level roles at my last 2 companies - so more exec level but not quite C-Suite. Have one-off recruiters hitting me up on LinkedIn about contract PM roles but that's not what I want.

likeuplifting

Laid off after Thanksgiving. 54. Not done yet. Plenty to offer. In Detroit but ready and able to move anywhere. AD/CD. Hangin in there. How bout you?

like

Hi strategy 🐠. If someone were doing a research project involving the strategy community, what would you hope it focused on? What do you want to know about your fellow strategists?

like

Hi Sharks,

Can someone please provide the details on the insurances provided by oracle India ?

like

Does it make sense to move from one business unit to another at same position? What sort of pay raise one usually gets with that kind of move? Currently at B30 (Senior Analyst). Also, will it also affect current year’s rating and bonus? Does one have to serve notice period for an internal move? If yes, then how much?

like

Does anyone have recommendations for a trip to Alaska?

like

Been a rough 2 weeks. 😥

Post Photo
likefunny

Top housing specials in ATL rn?

like

LinkedIn question: I’ve never seen this before - someone shows up in the list of employees at a company. But, the button that normally says “follow” or “connect” is sunken/darkened and says I’m “following.” I (as far as I know) never followed nor requested to connect with this person and they do not appear in my list of people I follow. Is this a privacy setting or did they block me?

like

Has anyone had a client request zoom and virtual house showings?

like

Whyyyyy do people think getting a COVID test is a free pass to do whatever they want?? Especially if it’s a rapid antigen test, not a PCR test, and without at LEAST 5 days of quarantining (should be the full recommended 14 day quarantine). WHY. Are you just selfish?? In denial of reality? (Obviously not talking about people who need to work outside of their home. Talking about vacationers.)

like

EMI ka chakkar Babu Bhaiyaa !

Do like if you agree 😆.. need 11 for activating DM !

Post Photo
likefunny

Is it possible to sell and transfer my bike to the buyer without physical RC? I have a copy from DigiLocker.

Background story: it was a newly purchased second hand bike, before receiving the RC COVID started and I returned to my hometown. So never received it and I’m sure the RTO is not going to handover me the RC easily.

like

Can someone go from being sedentary and out of shape to loving exercise and being super active? Can people change? Or will you just always be a lazy person on the inside doing these things only because you know it’s for the best for you to live longer and have a better life.

like

How is the working environment in GSK GCC and how is WLB..

Question - does the recruitment for PERM stop due to hiring freeze?

like

Ugh! Need to switch my perfumes. I am a Chanel and Chloe kinda girl. Any suggestions folks?

like

Additional Posts in Excel Genius

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

like

What are your favorite excel macros to make you more efficient at work?

like

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like

Which add-in does your firm use for formatting charts? We use ‘thinkcell’ to create and format charts. Not sure if it’s the best add-in to rely on?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have returned some hard to follow, bad results that miss the mark.

like

Anyone have thoughts on best VBA/macro training out there? I find there are so many things I could automate and need a good place to learn the basics (particularly for excel).

like

Anyone know how to delete multiple custom cell styles at once without running a macro?

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

like

Help! I want to create a formula that calculates the % that each person is on-time. Below is an illustrative example. What’s the best way to do this? It’s like I have to combine the vlookup of Name but also count only if Yes and divided by All CountA for that person. Seems simple but I haven’t found an elegant solution and maybe did the conditional nesting wrong :(. The goal is to create a formula and not just filter and calculate bc it will new data will be added continuously.

Post Photo
likehelpfulfunny

Good day guys I’m new to fishbowl … I’m new to the USA. My old manage job didn’t require much excel . Question, which app is best recommended for me to learn excel ? Thanks guys .

like

In VBA when sending an email. How do I change the reply to email?

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Hi! Disclaimer: not an excel genius…

I’m trying to use the lookup function to grab data from a worksheet within the same workbook. I want the column to reference the cost code in one worksheet, find the cost code in the other and display the billed to date associated with it. The problem is that it repeats an amount randomly. There will be multiples then a blank cell in one that I know has a cost associated with it.
Formula=LOOKUP(D3,!Sheet!$D:$D,!Sheet!$H:$H)

like

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Flashfill not sequencing numbers when using the handle it’s just copying numbers....

like

Has anybody used the COM library and python to build reports? I'm looking for somebody to chat with about my project.

like

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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