Tips to increase code execution in a user defined function in vba? I turned off screen updating and read/write only once.

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

How efficient is the algo? How many passes through the list to obtain the matches?

like

FYI: function is essentially an index match that returns each unique match instead of one

I read in the ranges I am checking for a match, store the ranges in memory, then I loop through the entire range because the matches happen multiple times

Can you use a hash table to store the data?

Assuming you're using excel, have you considered whether access could help here?

@EY1 I'll look into it and see what the options are. @ey2 It's a huge workbook that I'm helping automate otherwise I'd definitely do the analysis in access

Related Posts

When do you actually start to feel useful in FDD? I've been in FDD for 6 going to 7 months and sometimes I still feel like I'm doing the grunt work non critical thinking.

like

Hello,

I will be joining PWC AC Bangalore in couple of weeks for SAP tech stack.
I am joining from a product based company. So wanted to know how we are assigned to projects. Will there be any client interviews. If yes will it be very tough? Do we get a say in the projects we can get to work or its usually assigned and we have to take it up.

Thank You.


like

What's your morning routine before you enter the office or hospital? How do you mentally prepare for the day? I'm trying affirmations for the first time...

like

Anyone joining EY GDS Pune on Aug 17th?

Currently have chase sapphire but thinking of switching to Reserve. Should I?
Wife will also be authorized user, we do travel and will use this card for all our purchases

like

What advice do you have for someone who wants to make a quick and seamless transition from operations to creative?

Moving from T2 to McKinsey. How do vacation requests work? I have family and friends getting married this fall in weddings delayed because of covid, but I’ll just have started so wanted to get a sense of how realistic taking vacation this fall would be and how to approach taking it (e.g. mention to HR, staffing). TIA!

like

Anyone knows what’s going on in BBDO

This is why I secretly avoid 1:1s with my manager!

Post Photo
likefunny

Any associate roles available in MBB life science consulting?

like

What is the pay-scale of SDE-7 role In Mastercard ? YOE: 7, TechStack: Java + Micro services + Angular. HR has verbally said they may offer 28fixed + 10% variable. I already hold an offer of 33LPA from another company. Does variable and bonus get paid 100% annually? Tentative DOJ: 14th Nov

Y'all leaving upper deckers in the toilet stalls need re-examine your life. How can it be so tricky to hit a12inch hole while sitting down? Bathroom is out of commission thanks to a serial squatter.

like

Anyone prepping for the SHRM-CP test? I’m taking a prep course this fall and would love tips or to know if there are any study groups out there!

like

Which is more useful in a HRBP role…data analytics or project management?

like

Do you like working in thoughtworks why or why not?

like
like

I’m relocating to London and would love to hear recommendations on neighborhoods. I am looking for an “urban village” feel (small coffee shops, not very touristy, can walk a dog and stroller) with a budget of 3K for a 1-2 bdr. My commute would be into Soho. I am currently looking at Notting Hill, Chelsea, and St John Woods, but I won’t be able to visit before my move. Any neighborhood recs?

like

Has anyone used or is currently using My Perspectives ELA curriculum from Savvas Learning Company? Our district is considering switching from iReady and I am looking for honest feedback. Thanks!

like

Hyperbolic, yes, but it got a chuckle out of me nevertheless

Post Photo
likefunny

Additional Posts in Consulting

I love cool ranch Doritos, but I'm really trying to figure out what cool ranch is? Any idea?

like

Am in a club and approaching all girls. Rejections have hardened me. Something should work

like

Looking for book recommendations on strategy/strategic thinking. Something along the lines of Contagious but open to any options. Thanks in advance!

like

Jobs are not coming back rednecks. We are automating most of those

like

Hey fellow fish,
Deloitte Tax Management Consulting (TMC).
Thoughts please? Is it mgt consulting? Exit opps?

like

If I end up quitting after maternity leave, do I have to pay back any of my leave benefits? I guess I could ask HR, but wouldn't want to throw out any warnings.

like

My neighbor is an air traffic controler and makes over 100k at 23 with an associates degree. They also get a pension and a mandatory retirement age of 56. Are there other gov jobs that are this cushy?

like

Last night I was asked why I left PwC by PwC folks and I responded "because PwC is shit". 🤦🏾‍♀️ And that was before any alcohol touched my lips. Anyone else have awkward dinner convo stories?

like

Any book recommendations for the summer vacation season? What's your favorite book over the last year?

like

Is there any advice for networking into projects when you don’t know many people at the firm yet? I always to help on BD work when I’m on the bench, but it never turns into any billable work. Every time I have talked to a partner/senior manager I was told I don’t have the skill set they’re looking for, but I don’t know how to build up from there. Feeing very lost but I want to improve my approach.

likehelpful

Any audio book recommendations to listen to when backpacking / vacationing?

like

Why do the Olympian track and field competitors need to wear the paper tags on themselves?!? It's 2016, can't we figure out a better way, plus no other sports do it. Someone please educate me. 🇺🇸

like

La Guardia terminal C pre-check can suck a dick.

like

I know Mck is the top for strategy, but in terms of digital/design in top consulting firms which do you think is better? Mckinsey digital or deloitte digital? (Or another..?)

like

What's the longest you should take on deciding on an offer? (Scenario - getting offer next week from firm1 but found opp @ firm2 recently. Want to pursue firm2 but don't want to lose out on firm1)

like

Spread collar. Four in hand or full windsor?

like

It’s all I have time for

Post Photo
likefunnysmarthelpful

A first for me, after 1.6 million miles. Thankful for a delay. The delay on the connector saved me a night at ord Hilton after the ludicrous delay on the first leg.t. Truly grateful united

like

What is the best consultancy for Media and Entertainment work? Considering a move…

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

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