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

I really love power query. It has his flaws, sometimes! but it’s a great tool.
At my client Citrix it is very slow. Is that always slow? I’m combining 100-1000 exce files.

Edit: and the best feature is. No one at my client likes to understand it so it makes me irreplaceable

like

Funny. English isn’t my first language and this was a quickly written comment. If you don’t mind. ;)

PowerQuery is probably a better way to do it but if you are looking for speed VSTACK is probably better

like

I agree with you about PowerQuery.

like

PowerQuery is a simpler and more practical tool. It's helped me a lot!

Related Posts

Inflation check @9% 🫡

like

Hiring for an Associate Data Director to join our team at Chiat LA! Role would lead Data Strategy on a couple key accounts with support, working side by side with strategy and creative teams throughout the entire creative process. 7+ years and management experience preferred.

Thanks - please feel free to reach out if interested!

likefunny

Mid year promotions, I found out you need to make your own case for it rather than the firm coming to you. If you think you’re ready make sure you speak up!

I got relieving letter from EY. Will I get experience letter also or relieving letter itself is experience letter?

like

Penchooooo... inhe believe hi nhi ho rha ki hum itne Churan kaise ho sakte hai 🤣🤣🤣EY

Post Photo
like

Do you ever just stop and think how we’ve made up this society with items and things of monetary value rather than live peacefully and the fact that we’re too absorbed with our own lives to stop and think of how if we did it together we could actually do it? 🙃

like

I am one point away from passing edTPA but can't resubmit now that schools are closed. What other ways are there to get my license???

like

Recommendations on the best podcast, book, or other medium to learn more about “entrepreneurship through acquisition”?

like

How many dress shirts and trousers do you recommend I should have? New to this and need advice. Sorry if repost.

What is your favorite dive watch around $500?

Does anyone wear ties anymore? Wanted to buy a ferragamo and a Hermès tie for Christmas but I feel like no one requires them anymore. Also how are BB ties compared to these two?

Is Gilt a good place to buy a pre-owned vintage Rolex ($3-5K range)?

like

Revolut is the new Deloitte. Thoughts?

Post Photo
likefunny

Which would you pick:

Range Rover Classic (c. 1992)

OR

Hummer H1 (c. 2003)

like

recruiters bombing up LinkedIn 😁

like

Friend: Bought the dip today?
Me: Yes, and I’ll buy more tomorrow 🚀🤝

Falling knife? Doesn’t matter, I’ll buy even more the next day 💪😈

like

Hi can you advertise here? I teach private piano-flute and violin lessons online

Do you like Angular or MVC with Razor HTML & Why ?

like

What are your favorite online strength training program sites/apps?
For reference, I want to work out 3-4 times a week and want a program that balances all body parts. I'm tired of searching videos on youtube and apps.

like

Additional Posts in Excel Genius

Anyone know what these badges are?

Post Photo
likefunny

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Would anyone be willing to teach me vlookup?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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