Anyone have a niche pet excel formula that makes them feel like a genius or have a super power for using?

Mine is the MOD function. Use it to identify what quarter you're in by using a 3 base, or use it to find high risk JEs by using a 1m base with the remainder being 0 or 999,999 excluding numbers that round to 0 or -1.

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

Colorsum

like

Nice. I might look into that.

Copy & Paste

like

=CHOOSECOLS(MATCH())

like

=A1+A2

Wrote a formula years ago that does a variable DDB that converts to straight line depreciation. Later i modified it to cover each year of the asset’s life and can quickly check against exports from BNA or FAS on acquisitions. I use it 2-3 times a year still.

Well, i wrote it in 2004 or so, so we had bracket functions and *.xls only files. So a long file, but it always works-i had to worry about saving down to old excel versions at the time.

CUBE formulas

=if(mod(number,devidor)>0,""")
Then filter and find the value.

Related Posts

How do I negotiate a later start date? I have offer in hand and am coming from big law but would really like 8 weeks off between jobs because I am burnout and need time to rest. Is 8 weeks excessive?

like

How can we integrate retry api call 2 times if it fails and log exceptions only once in .net core. Infosys Tata Consultancy Cognizant EPAM Systems EPAM Anywhere Microsoft Amazon i don't want to change existing logic and add code to multiple api for the retry logic

like

I had a panel interview two weeks ago. I sent the recruiter a status check email last Friday and haven't heard back. I'm really interested in this company and still see the role posted on their site. I'd like to send another email today (to the hiring mgr and recruiter) reiterating my interest along with a list of references. Thoughts on sending the references without them asking? I don't do well with panel interviews and I'm hoping they look past that and check my references.

like

Looking to grow and network with people in different industry. Has a young person it can be a little tough to get your foot in the door. DM if there’s any opportunities.

like

Anyone here from Hitachi Vantara NICE Ltd Larsen & Toubro Infotech

I have offers from above organisations and have some queries. Please help to understand which organization to join.
Tech stack: .Net FS. YOE: 6

like

Hi Fishes,
Many peoples saying product based company will pay more than service based company.
But I think nowadays service based companies are paying more than services based.
Actually
Tiaa global business services is product based company but not even ready to match the offer. Before interview they are ready to give package but once interview get cleared they will not ready to pay package based on your expectation.

Hello Fish,
I have cleared all round for MTS1 in PayPal.
I have only two days left in my current organization.
My current salary is 47.5 LPA 32 fixed +7.5 variable+7.5 stock.

Offered from SAP 47.8 fixed+ 5.2 variable + 15 RSU vested in 3 three years.

Offer from Paytm 60 LPA as fixed + 10 joining bonus+ 20 RSU vested in 5 years.

How much I can expect from PayPal

like

I am trying to land a role as a human resources business partner and I'm wondering which certification would be the best for me going forward. Phr? Shrm? Thoughts? Thanks!

like

Hi All,
How's the Job security and WLB for JL 8 (AM) employees in Accenture?
I know it has got a lot to do with the project, I'm assigned to, but just wanted to get an idea. Any insights?

Skill ~ SAP
YoE ~ 9

Hi all,
I m into QA as functional test planner for more than two years and now i m mood to change my role to automation, but after certification in selenium and Tosca my lead was not able to provide me the project based on automation so they are rolling me off from the project. Telling u will get automation project on bench.
Now i m confused what had happened and what to do on bench.
Please help me out here cause I m finding it too difficult here to change the role.
#accenture

like

Any good recommended books on how to build a scalable product and team? I'm looking for recommendations for two areas: 1) in general laying the groundwork in a startup to have the tools and especially processes in place to scale, and 2) tactical focus on building a SaaS project. I've been promoted into a management role from Dev roots, so need to learn more PM processes to be an effective manager in day job, plus would like to start building my own SaaS solution.

like

What do you want for Christmas?

Hi Fishes

I have recently resigned from accenture during probation period due to another offer and I have not got any resignation acceptance mail and HR is not at all responding but the new company HR is repeatedly asking for confirmation mail which I am not getting....Is there any idea when I will get the resignation acceptance mail. My LWD is 16th feb and till now I have not received the confirmation

like

4th year at a mid size PI firm. Got pulled from litigating MVAs to help this solo we hired start a med Mal/nursing home practice. 1 year in and it looks like I’m two steps backwards in terms of getting paid because we’re a year or more out from a lot of the fees hitting. I respect the solo a lot, he’s a mentor, but I’ve got kids and I gotta get paid. Trying not to burn bridges, but I can’t wait years to get cut in. Advice?

like

Invited to a recruiting/networking session for an analyst level role at a Bain Capital. Excuse my naivete, but is business professional (full suit) the expectation here? Unfortunately my only well fitting suit was torn recently so trying to see if I can get away with another outfit

like

You’re either not valuable to your company and/or your job isnt that important if you’re able to take PTO and not at least send some e-mails.

funnylikesmarthelpful

Creative Director and Adobe expert here, InDesign, Photoshop, Illustrator, Premiere Pro… I’m looking to teach, tutor, train interns or pros how to create. Creative training since 2013, I teach remote 90% of the time - looking for a new opportunity to teach, train and learn something new!

like

CFP thinking of taking a few month career break to search for a new position. Need a recharge and to reevaluate, not to mention time to search. Would this be a mistake? Thanks

like

How do you give notice in big law?

like

Hello guys, I am looking for a job change. I have 5 plus years of experience in vendor management, MS office , SAP, Payroll management, MIS, Data analysis, Customer management, Office admin work, Documentation. I am a immediate joiner and looking positively for your response.

like

Additional Posts in Accounting

Pittsburgh big4 audit senior salary?

like

Has anyone transitioned from working in a company to being an independent contractor? How long did the transition take and what are the pros or cons from working solo?

like

Best advice for someone looking to get out of tax? Would prefer a role that deals with financial/strategic analysis and financial modeling in order to assist in making strategic business decisions

like

Just heard EY is about to make more layoffs in audit too

like

Considering obtaining a CFE certification. Can anyone share their experience vs experience obtaining CPA? I’m already a CPA. I just want a comparison of study time requirement and difficulty of exam.

like

Quarter life crisis: was in B4 audit for 4 years and took a financial reporting role in industry. It pays well, but kinda want to get into TAS. If I were to go into TAS could I be a senior 2-3?

like

Do you ever stop and realize what you're doing/earning is more than you ever thought realistic for yourself?

likeupliftinghelpfulfunny

Anyone else feel like that if they aren’t doing the work themselves then it’s never done correctly? Doesn’t matter what it is - admin to client work - always materially incorrect. Also, doesn’t matter what training I give them - a quick overview or an in-depth working session. And then the Partners ask why I’m exhausted all the time.

likesmarthelpful

Constantly bugging partner to sign off my CPA experience... what's the point of incentivizing the license to get promoted if I have to keep nagging you to sign off

like

Got hired 3 years ago- newly created staff accountant role with the plan that it’ll go into a senior and then manager role. 1.5 years in I get a title promotion to senior, told I’ll get more duties, start supervising AP, and get monetary promotion to match next year. Got way more work, but nothing else promised within that year. Told next money bump would be manager role (no raise for senior still) and I need to take on more and start supervising AP. Again, seeing nothing…time to leave?

like

Bain & Company Got an offer with PwC as M1 in fdd Chicago. How much should i expect in salary?PwC EY KPMG Bain & Company Mazars Deloitte

likesmart

Does anyone have experience or know of someone who went on a FWA (part-time) but didn't have kids? I'm unmarried and no kids but considering a move to 30 or so hrs/week for my sanity.

like

What industries is the CFE certification used for? How does it compare to CPA in the length of the material and difficulty? Do most firms pay for It?

like

Does your coach see when you get a real time recognition award?

like

Does anyone else make small mistakes here and there because this job makes you anxious? I feel like I triple check everything and still get pings from my manager that I missed something

likefunny

I’m pretty sure I make more than my first year manager. Should I feel guilty?

like

I feel like so much of my job is planning and scheduling that I have 0% left to plan and schedule my personal life. Is that normal? Do I need a Microsoft to do list for normal life 😣

likefunny

Thinking joining Deloitte New Jersey office… any thoughts/reviews from anyone that works there on culture/people/workload/etc?? Deloitte

like

If you have 4 days PTO, would you rather use it together in one week or take 1day off for 4 weeks ?

like

currently in tax, thinking about trying to switch to advisory. anyone done this and have any advice? would i get a pay cut and/or lose my senior associate title?

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