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

I didn't even know this was possible, I'm excited to try to save some of my most used formulas!

Wow this is awesome thanks for sharing

Will have to try this out

I use VBA often for automation

Related Posts

What does a good earned media strategy look like to you?

like

I need contacts who are into bank instrument and MT103 transfers within USA and Europe. If you are a good sender or receiver let me know.

like

6 $28 strike PTON calls expiring friday. Premiums crazy cheap, i think it goes up regardless of what we see. If cases surge its more incentive for home fitness, if not, could lift with the market

like

Pregnant with my second and I have no will to work. I use to be passionate about my work, but now I m forcing myself to complete the bare minimum tasks needed from me. Not taking any proactive assignments.

Has anyone else felt similar during pregnancy or postpartum?

like

Has anybody stopped paying Canadian CPA dues and let their membership lapse? I'm working in the US and I recently got my US CPA. I can't think of any good reason to keep paying these high annual dues, from what I can tell I'm not getting anything from being a Canadian CPA. Any advice?

like

Who’s the best sound designer in NY

I am interviewing @ Stripe for PM role and they have a written assignment. Do any of you insiders have any tips to share?? I have heard they use Basecamp's shaping method. Are there any examples of what they expect? Appreciate your help!

like

Looking for a producer for helping me to scope a branding (traditional+digital) and digital experience (mainly UI look and feel) project. Will need help with creating timelines as well. Would appreciate hearing from people with experience on these areas.

likesmart

Bowl etiquette questions for all you early joiners of the Bitcoin bowl (options in thread). Would love feedback.

like

I JUST LANDED A PHONE INTERVIEW WITH GOOGLE!!! can I get some google phone interview tips, advice, etc.? (Forever grateful) 🙏🏾

like

Tip for anyone taking the CAIA exam, get UpperMark. Was using willey and was abt 1/2 complete and borrowed a friends test bank … night and day much harder and honestly was more like what I expected

like

Hi folks,
Need a small help. Can anyone please tell what is the C1 level in Capgemini and what is the median salary package for the post?

like

Hey fam! I’m looking for mentors high and low and trying to find good platforms for mentor matching. (e.g. I used to be a part of NYC’s Women Who Create until I moved abroad) Anything good you know of? Or, perhaps, if you’re interested in mentoring/being mentored, say hey below.

like

Anyone stuck in an unhappy marriage? How do you deal with loneliness of this profession and complicated family life

How much difference does have a LinkedIn profile pic have vs not having it?

Is it difficult landing an in-house position as only a second year corporate associate in big law? I know some people who went in-house straight out of law school and some who had no transactional background but went in-house after just a year of practice. Not having that same luck on my end.

like

Hello everyone,

I would like to know that how long it will take to generate the offer letter on workday portal?

like

Hello! I’d like to share an experience and hopefully receive guidance.

I spent two years as an executive, and while I was providing what I believe was impactful work, and receiving praises across the board, I got fired from one day to the other without any explanation.

After a few weeks, some managers (who were under me) shared that there had been a while campaign raised against me for a couple of months by others VPs and shareholders. 1/2

like

I am going to speak with a recruiter at Houlihan Lokey TMT in LA. I would like to know more about the group and its culture. Would love to connect and network🙏

like

Additional Posts in Excel Genius

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

likehelpful

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Would anyone be willing to teach me vlookup?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
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?

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!

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

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

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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