Change my mind

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

This is true, and “my clients run Windows 95” is not a valid counterargument

likefunny

Sounds like cross sell credit on a “DiGiTaL tRaNsFoRmAtIoN” to me 🤷🏼‍♂️

HUGE day for me, an update just pushed thru and i now have XLOOKUP()

like

Welcome to the future

like

PQ is better than Xlookup. Change my mind.

like

Offset(,match,match) here.

Super easy to error check with F9 and still doesn’t reference too many cells.

In reality I rarely use offset(match, match), and it’s when needed

Related Posts

Are we taking the long way?

Post Photo
likefunnyhelpful

Epic is so annoying! it’s like a mainframe that modern technologies cannot easily integrate with. how does this company remain in business?!?!?

like

Hi Sharks,
Please suggest as hiding wont be possible because pf is created. If i am truthful about my absconding will companies hire me ? Please clarify

Post Photo
like

Just joined a new agency. I contribute good ideas. I write relatively well. But sometimes I feel that I just get swallowed up by creatives who speak louder, present better. Any advice?

like

How is asset and wealth management service line in EY GDS? How much work pressure and growth opportunity we can expect?? EY EY India

like

It's pretty exciting to get a sneak peek into these concept designs for Glassdoor's new look and feel, but is anyone else gonna cry a little if the brand actually ditches "Glassdoor green?" 😭

like

Found out my crush isn't really into physical touch. But I'm really into it. Idk how this can work 🥺 I'm constantly doubting that he's into me because the physical isn't there even though he shows it in ither ways. And it's hard to want to touch him, but not being able to whenever I want because I don't want to make him uncomfortable. It's a big adjustment :(

like

Current working as a Director of Sales and Marketing at a large hotel chain. I am now trying to branch out to a work from home position as I have a special needs bonus daughter who we now have every other week 💜. Would love to find something full time from home within the industry, or in the travel market so I can be with her.

like

Hi Folks,
What's the hike one gets on promotion from Systems Engineer to IT analyst in TCS?

TIA for your inputs.

like

Any advice for the anatomy scan? Any questions to ask / be prepared for? Excited for the upcoming milestone!

like

I’ve been reading Walker’s book “buy then build” for acquisition entrepreneurship. Anyone here consider themselves and acquisitions entrepreneur?

like

How is work life balance on DOD consulting projects? Same pace as any other government projects? Thinking of jumping from commercial.

like

Does anyone know a good firm that provides benchmarking of commercial operations in pharma? Other than PharmaForce?

likesmart

My secretary’s birthday is coming up, and of course Christmas. Any good gift recs? What is an appropriate amount to spend? In the past I’ve just done cash/Amazon gift card, or a spa gift card.

like

Hello Fishes,

I'm looking for AWS DevOps roles, if anyone has any referrals,
YOE: 6 yrs
Stack: AWS, GITLAB, TERRAFORM
For Delhi NCR/Remote

Anyone has any referrals?

like

Hi all! Relocating and looking for someone to takeover my apartment in East Somerville near Assembly Square. $2,400/mo for a 1bd + office, private balcony, and shared backyard - DM me if interested!

likehelpful

I have 400 CRS score and I don't see it increasing much. Is it advisable to move to Canada on ICtransfer. Not sure if i will hit PNP. Have EB2-2015 priority date in USA. Already in USA from last 10 years? Appreciate any comments.

like

Can we stop attaching unpublished cases yet?

like

How to get freelancing opportunities?

like

Hey gang, what's a fair salary for a Sr. Writer moving up to an ACD role in San Francisco?

like

Additional Posts in Excel Genius

Is there a way to wrap your header text within access database?

like

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

like

Thoughts on learning VBA? Is it useful in consulting? Many people argue Python is better to learn overall?

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

I have zip-zip routes for a trucking company. Most of them have price info but some are blank. Is it possible to do a count of those with price and without price in two columns of a pivot? I want to show that prices are missing across the board and that we can use the majority to replicate the missing few.

like

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

like

Looking to expand my Excel skills by learning Power Query/Power Pivot & VBA & then expand my learning towards certain programming languages (not Excel related).

I currently have access to LinkedIn Learning, but curious about Udemy and Coursera. I know about the differences between them, but content-wise, anyone have a better experience with one over the other out of three? Other recommendations?

likehelpful

How do you add this to a worksheet? The extension button on the side of the worksheet see below

Post Photo
like

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

like

I have historical quarterly TTM values for a number but not the value for that quarter itself. Is there a way to back into a given quarter’s value?

like

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

like

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

like

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

If I have NAME, REF etc errors in different spots of a very large worksheet, is there a quick way to delete all formulas that are bringing errors?

like

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

like

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

like

Hi! I’ve got a number thats 6 digits and I’d like to make this 4. However, everytime I do my beginning and ending zeros disappear. Any suggestions? Or how do I shorten to 4 and keep zeros

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