Time to convert to xlookup

Post Photo
likefunny
Posting as :
works at
You are currently posting as works at

Have you heard the gospel of Power Query of Later Day Excel?

likefunny

Correct S2 — thanks SA2

Waah index match waaaahh

likefunny

Ill always be grateful to index match for letting me feel superior over vlookup plebs, but xlookup is bae now.

like

Why would you want an alternative to the lord’s lookup?

like

More like XXXlookup

like

You’ll have to pry index match from my cold, dead (and muscle-memory driven) hands

funny

I'm a bit ashamed that I always have to look up the index match formula because I keep forgetting which array goes where ..

As someone who never learned index match, I feel justified ;)

You're like a meme stock investor: you've reaped the rewards, but not because of a good decision 😂

Related Posts

If anyone is plooking to break into product but doesn’t have enough experience - I have a volunteer opportunity that needs product managers for civic technology products.

like

Would anyone be willing to provide a referral link for Optum? I am open to discussing the role I would like to apply for and my background. I know it’s difficult to maneuver into companies this large without a referral. Many thanks in advance!

like

Hi Guys, I need a referal at Microsoft for Product Manager role.
Can anyone help please ? Microsoft

like

For those that work at an agency: what does your team structure look like? As UX or UI contributors are you on a creative team, product, something else? And I'm curious about reporting and management structure as well.

I have 1 YOE in strategy consulting at a Big 4, planning to apply for BA/AC roles at MBB. I’ve read they prefer you to list test scores on the application. I’ve never taken the GMAT, so is my ACT still ok to include even though it’s nearly a decade old? 99th percentile fwiw

like

How many of you were direct admits to Partnership? From other consulting firms, or from industry? Was it a lateral move, or a step up/down?

The reason I ask is: I’m a Y3 Director at Big 4, always been a consultant and probably 2 years away from Partner. I have an offer from industry for VP at a F50 company, but am wondering about how difficult it’d be to boomerang back if it doesn’t work out.

TIA

likehelpful

I am trying to connect the dots between my current role in industry and a product role. Are there any product managers here that could spare 20-30 minutes to chat with me?

like

Starting date at Apple: offer letter is 11/29 but I am working with the recruiter to alter it, and it's still not finalized. Is there a workaround, say can I work with the HM directly to finalize the start date and arrange laptop shipping? Will this be frowned upon?

like

So we really need a president ? Let the states and towns manage their affairs. In any case Don-the-con doesn't have much to do beyond spending 12 hrs watching TV shows and dialing into moron friendly shows - fox and friends, Hannity and Tucker

likefunny

Will the firm know if I secretly work outside of us..?

likefunny

Trump learned a lot. So did I. I’m 💯 convinced that he is an unhinged 🤡 willing to endanger everyone to feed his ego.

likefunny

Anyone ever become friends with an online dating match? 90% of my first dates don't have the (romantic) chemistry but there are often friend vibes where I'd be interested in keeping in touch.

Curious if anyone has actually made platonic friends from "failed" dates or if the first meeting being date-oriented makes this weird.

like

Does Boston Consulting Group have the following?
- HSA
- After tax contributions to 401k w/ in plan Roth conversion

I’m joining in a few weeks and doing some planning on how to adjust my existing accounts/strategy.

Thanks!

like

I have heard from a lot of people in many sectors that one should change jobs / companies every 2-3 years to increase salaries and benefits etc… is this also true for healthcare? Or should I stick it out. I am a few weeks into year 3

like

Senate confirms Kavanaugh 50-48. Congrats to Justice Kavanaugh 🇺🇸🎉🥂🇺🇸⚖️

likeuplifting

I seriously wonder how many PR firms post on this bowl to test their political strategies and push their agenda. The Joe Biden thing is a good example and probably not the only one.

like

Early 30s, Female, Texas. Indian Ethnicity. HMU!

like

Good reminder.
To get nations back on its feet we need to first fall on our knees and pray.

Post Photo
like

Feeling like I’m the only FDD senior who isn’t interviewing or hasnt already quit. Where have ppl gone who have been happiest? A&M? RSM?

likehelpful

Do you think the military industry will cease to exist in the future? Costa Rica has no army, and I think it's a matter of time for more countries to dissolve their armed forces too.

like

Additional Posts in Excel Genius

Anyone know the shortcut to format selected cells as short date IE mm/dd/yyyy?

likesmart

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

Experience a lot of downtime because I deal with massive amounts of data and need to constantly filter and delete records that are not relevant. Is there a workaround for this?

like

In a usage based ARR model, how would you build out the revenue model for an example customer: March, customer is new and generates 3k rev for company, April: $4k Revenue, May: $5k Revenue, Customer churns June.

From a quarterly perspective, how would you recognize the following? Q1 & Q2 New customer revenue, Q1 & Q2 Change in existing customer revenue, and Q1 & Q2 Lost revenue from customer churn.

I'm stuck on how to recognize Q2 change in revenue of existing customer, & Q2 revenue churn

like

Anyone know of companies allowing there employees to work remotely in another country?

likehelpful

Not sure where this post belongs because I don’t think it’s an excel solution, but I want to be able to pull data from various direct datafeeds (and be able to pull in reports from say excel as well).

Once I get all the data in the same place I want to make sure all the data looks the same before I begin manipulating it (consolidating/mapping fields essentially)

What’s the right software to do this? Is it as simple as having direct feeds integrated with Access or is it something else entirely?

like

Anyone have recommendations for a 5 year forecast model and/or template for a private company? (For a small fintech company)

like

Job Opportunity
I'm assuming people in this group are either really good at excel or are really interested in excel - either way, I am looking for anybody who would be interested in being a Junior or Regular Compensation Analyst. I need a person passionate in excel for this job. Please DM me !!

like

I truly appreciate this group.

Post Photo
likefunny

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Is there a way to color a cell based on the color of another cell? I have Sheet one with green, yellow, red used to denote progression status on 20 tasks, which constantly changes based on client input. Sheet 2 is a summary dashboard of each of those 20 tasks. If sheet1 C3 is green, how can I get the respective sheet 2 dashboard cell to also turn green?

like

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

Not really excel - trying to convert a “text formula” result into a number result but I’m stuck

IF (AND(Monthly_Unique_Visitors__c  >= 0, Monthly_Unique_Visitors__c <= 50000), "-50",
IF (AND(Monthly_Unique_Visitors__c  >= 50001, Monthly_Unique_Visitors__c  <= 100000), "-20",
IF (AND(Monthly_Unique_Visitors__c  >= 100001, Monthly_Unique_Visitors__c  <= 250000), "0",
IF (AND(Monthly_Unique_Visitors__c  >= 250001, Monthly_Unique_Visitors__c  <= 500000), "7.5",
IF (AND(Monthly_Unique_Visitors__c

like

Hi all - quick (and sadly really urgent) question for my excel folks. My computer restarted yesterday evening, I opened the excel file I had been previously working on this morning and I noticed the developer tab was gone. I added it back via the toolbar but now in that same file some of the specific commands within the developer tab are greyed out and I cannot use them. I’m unsure why this is happening because if i open a blank workbook everything is available?

like

Is there a key to press to go to the bottom of the row you just copy and pasted into? Ctrl +shift + down goes to the bottom of all the text but I want to see where i stopped the pasting.

like

I’ve got some lookups to do but inconsistent unique identifiers (names with Bob G01 vs Bob G1). More experienced fish, what’s the best way to perform look ups with this kind of unclean data? Got a few

like

Too many format error, already tried the XLStylesTool. What next?

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.

like

This is the 🐐 bowl. No fuss and nonsense just all business

like

Hello Excel Genius!
How do I calculate the monthly average of items returned and credit return by each division in a year?
Thank you!

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