{ "media_type": "text", "post_content": "IndexMatch or DGet? My IndexMatch array lookups with multiple criteria are still taking forever even after I double my RAM to 16GB.", "post_id": "57c589fb7edd9c0e000e5b0e", "reply_count": 11, "vote_count": 2, "bowl_id": "552d1d24dc1c586b09d2d051", "bowl_name": "Consulting", "feed_type": "crowd" }
null

IndexMatch or DGet? My IndexMatch array lookups with multiple criteria are still taking forever even after I double my RAM to 16GB.

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

I'll google. This is worth my time

like

Do what ever you are doing in Microsoft access

like

DGet is one of the excel database functions. My questions is really... IndexMatch vs. Database functions

like

YouTube tutorials, Microsoft's website, internal web training (assuming D has an agreement with MS), just open it up and give it a try. If you have questions along the way you can post to Microsoft's forum or give stack exchange a try. It's a lot easier to learn when you actually have a problem you want to solve with it.

like

What's dget???

Option 1: if you're returning a number you could use a sum product and specify criteria using "--"

Option 2: you could make a new column next to both the data you are using to "lookup" and the data you are returning, and in that column you would put in all the criteria and return it as a true false. Then depending on what you want to do, you could do a lookup on first the t/f and then decide whether to return the the value, or you could try concatenating the true false in both the lookup and return areas and then doing some type of left/right function to determine if it met the criteria or not

Agree with access. If you're doing something that is this memory and processor extensive in excel, it should be done in access.

Any tips for learning access?
Also, I can already tell things should be structured different in access, than they are in excel. Tips on that?

QlikView. Much better and more intuitive than Excel and Access. Compression ratio also beats Excel and Access. Personal edition is free. I'm never using Office for complex analysis ever again.

Access for dummies is how I learned.

Additional Posts in Consulting

Any thoughts on buying XLE, FENY or any other funds/ stocks in the energy market ?

like

Thoughts on how to make got star responses. I like go blank answering these questions

like

Hi Fishes,

Looking for Job Change I have 1.6 years of experience in Cognizant as a RPA Developer specialized in tools like UiPath and Blueprism , also automated various office reports and And ITSM audit reports using python and yaml scripts, have breif idea of ansible runbook automation and also have done servicenow development. Actively Looking for opportunity pls Help for referal .

Notice period : 60 days
Current CTC : 4.5 lpa

I’m angry about the injustice towards black people, I’m angry at the destruction of my community, I own lots of guns, I don’t care about what sexual orientation you are or your gender. I. AM. WOKE.

like

Hi there, would appreciate an commercial/ enterprise AE to review my resume and offer feedback. I’m interested in learning and growing into becoming an enterprise AE and would appreciate advice and guidance 😄

like

Hello guys
I am selected in PWC KSDC. Is disclosing all out shares and MF in detail very important?
Am selected for SA1 level.
Non disclosure will lead to losing the offer ?
Please throw some light on this

like

Hi, wanted to know how appraisal/ hikes are in Legato.

Looks like RSM is planning to force everyone back to office

like

If I am getting a very good offer from a product base company on my last working day and I am willing to join the same.. Will the previous holding offer company can take any action against us..

like

Guys, I possess 8yrs experience in technical field/software development. I have done B.tech from tier-3 college & have worked mostly in service based MNCs.

I would like to know what would be the path if I would like to move to VP(technology)/CTO role in the long run.

As I have not done PG & even graduated from tier-3 college, are there any additional courses which can boost & add value to my profile?

like

How does the career graph of business analyst (for business analysis and not analytics) look like?

I have 8 yoe as a manual qa and have been offered the position of business analyst within the company. Want to know the scope before telling a yes.

Thanks in advance for your help

Those at Director level in P&T (I’m a manager), do you feel there is a realistic shot at making partner in P&T? Any pillars or roles in particular?

My current thinking: there are tons of directors in P&T and what feels like too many partners already in some pillars, plus not many new or missing roles that would make sense to be filled or created by a partner. Doesn’t seem like there’s a lot of room for making partner in P&T, despite Joe saying it’s a priority. I hope I’m wrong though!

like

Range of salaries (senior / Manager / SM) for TAS - Valuation high COL? Looking to switch careers and want to see if it is worth it from a monetary perspective. Thanks!

like

Do any guy 🐠 have weights at home to exercise? I like to workout at the gym but been slacking lately. Thinking of buying some weights to workout at home

For the ones who’ve done laser hair removal - I have tiny hair on the chin so thinking of taking the plunge and maybe even arm pits. How much should I be looking to shell in the NY/NJ area?

like

Anyone looking for female roommate?
(Downtown Manhattan/Brooklyn near subways)

like

My I-140 was approved a week back and I received an offer from another organization. Should I wait for 6 months before making the switch?

like

ladies, im giving myself a hernia trying to carry all my crap for work (especially because of this hoteling nonsense). any ideas on backpacks or purses that will help my lopsided-ness. TIA ☺

like

How many suits and sport coats do you own?

like

My mentors (partner & senior) have scheduled a feedback meeting with me on Wednesday. It’s not just me, they’re scheduling meetings with everyone so I’m probably keeping my job. Thing is, I’ve been incredibly frustrated with the firm - I’m buried in work and billing like crazy, but there’s zero transparency on financials and zero communication on bonuses (...)

like

Additional Posts (overall)

Any one planning grad school that is NOT MBA? Seriously people I fear there are going to be waaaay to many of us

like

ATL - where are the most people out on Thursday nights? New to the city. Any neighborhood with more people? Highlands was dead last week @ dark horse and hand in hand closed early

like

Cleaning service recommendations in Boston?

like

What total comp should I expect from an AWS senior engagement manager offer?

like

Why do people ping “-“ before what they actually want to say?

like

These contract recruiters are clueless about their company they represent it’s a joke… my recruiter couldn’t even tell me the amount of PTO days/basic benefits questions I had

like

Has anyone signed an offer letter and later rejected because you got a better offer elsewhere?

I received an offer from B4 and have to provide my response by tomorrow. I’m still waiting to see if I will receive an offer from a smaller firm, because that’s where I actually want to work after learning about the project and meeting the team. Also the salary we spoke about is about $20k more than what B4 offered.

like

What's your craziest work outing / "nonbillable" expense outing? #askingforafriend

like

A little bit shocked/disappointed no other airline has followed in Deltas footsteps extending status til 2022. Looks like it’s time for a status match

like

Can I collect mileage allowance if I rent a car? So I would rent a car in my home city, drive to client site, drive back home on Thursday and also collect mileage for the journey?

like

You should be watching the Falcons game

like

Anyone here ever work at grant Thornton? How was your experience compared to the big 4?

like

What questions do you wish you had asked your practice leadership before joining your practice?

like

What's this b.s. about 50hr utilization target in advisory? Is the business doing bad and they expect us to make up for it?

like

How difficult is obtaining an AWS cloud practitioner cert if you’re not particularly technical?

like

Deloitte's poor management & culture is starting to wear on me. Prob some residual resentment at how layoffs were handled tbh. Has anyone left D for another Big 4 & care to share if grass is greener?

like

Selling 2 AA SWUs - travel has to be before 1/31. Short notice I know but if you're interested drop a burner

like

In air. Any Delta drink vouchers people need to get rid of? 🙏🙏

like

How many strip clubs have you been to since you’ve been in consulting? Did you go with anyone from your team?

likefunny

I am an incoming intern to KPMG in the healthcare solutions practice. How can I stand out in a virtual internship to ensure I get a return offer?

likefunny

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

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

New to Fishbowl?

image with Fishbowl logo and arms reaching out for a handshake

Already have an account? Log in

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

For account settings, visit Fishbowl on Desktop Browser or

General

Legal