Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

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

Related Posts

I start studying for the CPA in a couple of weeks (July 1st). Is it realistic to say that I can get this completed by the end of the year? If so, which order would you take the exams? Audit background

like

Studying before and after work and starting to get depressed. All I do is study and work. I want to light my Becker book on fire and shove my head through a window.

like

Pass FAR and ReG in 60 days?has anyone every done this? Can they give me a study plan..I am using Becker

like

How does anyone get through the Reg material listening to Tim Gearty 💀

likefunny

Joined Accenture early May at Manager. Literally feels like I don’t even work at Accenture right now. Anyone feel the same?

like

Can anyone refer me for React js Developer position in Deloitte. I have opened their career site but couldn't find any suitable matches.
Thanks in advance

like

Just finished my book tracker from last year and wanted to share. Had a lot of fun with it!

Post Photo
like

Would be great if the Falcons would target Pitts at all

like

Hello, I'm considering moving to Tampa or St. Pete. I am 36M, born in NY, and currently live in Austin. My parents live in Naples and I visit often so I'm somewhat familiar with the area but I would love to hear from this bowl what you all like and dislike about Tampa and St. Pete? Thank you!

like

3 years out of college now. Should I be including college GPA / test scores / awards? How about internships from freshman year of college? Thanks!

like

Watch noob here and I know this is the Luxury Watch bowl, but thoughts on Citizen Eco Drive?

like

Do LinkedIn badges matter? I'm an entry level frontend developer, looking for jobs, I do have a few badges, but I want to know if that makes a difference?

like

That feeling when you try to connect with a recruiter on LinkedIn, then see that they’ve viewed your profile and photo but not accepted your connection.

like

I love to cook. I am trying to find a happy medium between one off beginner cooking classes and culinary school. The perfect scenario would be a multi week class that goes over advanced cooking techniques. Like stuff you may learn in culinary school but for people who just want to learn as a hobby. Any ideas?

like

Interviewing for BIOLIFE today and looking to gain insight from anyone who works for the company.

Need to enable dm guys , please help.

like

I’m looking at a few positions at Square. How are the benefits there. I’m the sole breadwinner in a family of 6 so healthcare is important. Do they cover any percentage for the employee or dependents? Do they offer phone allowance? Any other cool benefits?

like

What all wellsfargo check in BGV ??

How's grade 6 with 130k base salary at California?

People worrying today should read books on trading psychology! Not being patronizing- it will help you in the future, not just for investments but for doing better in life!

like

Additional Posts in Excel Genius

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

like

I have a workbook with a couple of custom lists that we use every month in my department. I'm handing off this responsibility to someone else who will be using their own laptop to do it. Will the custom lists pull over to their version, or do we have to set them up in their version of excel on their laptop?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Is there a better tool than than Excel for making models? What do you use?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

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

Is Excel extremely slow at updating/calculating formulas for anyone else recently?

likeupliftinghelpful

I have a formula that returns a value of any cell in that row is blank otherwise it says error. However I only want the formula to apply if any of the cells in the row are populated. Help?

like

Does anyone use XLOOKUP over Index Match? Why /why not?

like

Tips for fixing index match when it’s working for most lookups but some are returning NA despite being in the list?

likesmart

What am I doing wrong in my sum product formula? I keep getting an error message.

Post Photo
like

Hotkey question. Let's say I have 10 rows of data. Added a new column, want to quick fill cells. When I use Ctrl+ down, it select 10k rows because they are all blank. Any better option??

likefunny

Has anyone encountered an issue where the tabs on excel flash and excel becomes insanely slow? It only happens on workbooks with lots of tabs and only occurs on external monitors. It's very odd.

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?

like

Time to convert to xlookup

Post Photo
likefunny

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Is there an easy way to convert a manipulated pivot table to a normal table but automatically retain all the subtotal formula and grouping? For example, I have a pivot table with 3row fields (country, region, customer) And a 1 column field by month. I want to make a presentation to show top 5 customer by country and region….and group rest as “all other”….thanks’!!🙏

like

What is a website I can use that has live updates of data in tables, that occur every 5 minutes or less, so I can test the Refresh button for queries and connections? …Also, if anyone has a good macro for a button that I can insert into a spreadsheet that you can click as a short cut to the refresh all button, I’m small ears. Thanks!

like

all these years I've been converting text to number and crashing my workbooks, then find out about =VALUE () 🤯

likefunnyuplifting

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

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