HELP! Excel gurus, is there a way to allow filtering but turn off sorting on a worksheet?

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

Honest question - have you asked ChatGPT? It’s been good for figuring out formulas for me.

Asked copilot, took a couple of back and forth but got it

Great now I have to ask copilot myself

This is probably a vba problem. Assuming macros aren’t blocked at your company

Isn’t this something like personal views and not sorting/filtering?

Add slicers

Ah that’s what it’s called. Personal views is for google sheets I think.

Related Posts

Hi got offer from Virtusa onsite for Emirates NBD, recently joined ibm gbs. Which one to choose

like

28 F... Not a PPMD but open to dating one

likefunny

31 F based in Chicago. Does anyone want to talk?

like

I wish this app had a job title for nurse informaticist or analyst.

like

Anyone have insight on how to move in-house at EY?

like

Has anyone else seen ads for the musical “Shen Yun”, EVERYWHERE??? To date I have seen billboards, social media ads, posters, and received a mailer yesterday. Their media budget must be massive.

My gorgeous baby Merlin

Post Photo
like
like

Need suggestions
Any idea about Mott MacDonald company need to know the work life balance in there and the people?

like

Can some tell me how much your premium for malpractice insurance was when you first signed up?
I’m in NYC 3 years in practice need insurance.

like

Has anyone moved from antitrust private practice to a non-antitrust in-house role? If so, what kind of role?

like

I have my last working day at IBM GBS in the month of july. Wanted to ask what documents should I carry to the office for asset return, what documents I will receive on my last working day and which ones I will receive after my lwd? Any action item to be done before my lwd apart from returning id badge and laptop ? IBM

like

Hi Fishes,

Anyone from Dr.Reddys Laboratory here?
I wanted to get an idea of few things/policies.

Please DM me if you have any idea

like

When Parents want you to see Baghban with them, show them chhichhore instead 😁. #mondayblues

like

Is Elon Musk's image finally breaking apart?

like

Has anyone heard of The Next Step program at Dartmouth’s Tuck school of business? I’ve been Encouraged to apply

like

Is Barclay's a good bank to work for? I'm looking for all feedback - the good, the bad, and the ugly

like

Ryan Murphy is the new Aaron Spelling. Big rich producer making money off of cheesy shlock. I guess you can’t take the Indiana out of the boy. Heart’s in the right place though. Bless his heart.

like

Hi Folks. Switching from product base to service base at level 9 in accenture in SAP Domain .
Can some1 explain how the journey starts from day 1.
Heard Noise abt client interviews , bench process,layoffs etc etc.
Need Serious Comforting advise.

like

I have joined TCS as graduate trainee. I have been trained with Automation anywhere tool.i. am on bench.
I have knowledge of Html ,css, little bit of javascript and Java. What should I do or learn to grow in my tech career.

Additional Posts in Accounting

True or false?

Post Photo
likefunny

Anyone here a manager in PI at EY? Could you please PM me? Looking to talk more about the practice.

like
like

Best tips to manage another person that's on the same level as you, but knows everything about the client and you don't - since you are the new guy.

like

How much does a big 4 marketing director make in the Bay Area?

like

Estimated tax payment question:
I converted $30k of rollover 401k into a Roth IRA and have $26k of realized ST Capital Gains this year (Roth conversion in end of Q1 and most capital gains in Q2).
My total federal withholding tax last year was approximately $12k and this year I will have 40% more in reported income on my employer W2 and anticipate higher that $12k federal withholding for my new job. Given this, what is the best way to go about making est. tax payments for the income (continued.)

like

Anyone from EY-Parthenon, what does a typical senior consultant look like resume/experience wise? If I have audit and FDD experience as a Senior for 3 years (currently in FDD), a CPA, no MBA, is that enough to get in to EY-P? Or is the MBA basically required? What would I be missing? Thanks!

like

How prevalent it is that folks have anxiety depression at big4 nowadays.

like

I have been interviewing for a few accounting firms, however, I haven’t heard back from Pwc and I’m really interested in the Chicago Branch, would anyone be able to assist me?

like

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

like

One of my senior managers is a boomerang and told me she was laid off when she was 7 months pregnant about 10 years ago. I think she was a senior or manager. She was in a specific group and everybody was laid off. It wasn’t performance based.

Would you work at your company again if you were laid off?

like

Highest number of billable hours you have seen in a year?

like

Can anyone share recent sign on bonus trends among big 4 firms for experienced senior audit hires?

like

Has anyone on here ever taken an unpaid leave of absence?

like

What can I do with my 3 year experience at big 4, if I exit now? My aim was to always hit 6 figures after 5 years of work but I can’t stand the big 4 workload and stress levels that much longer. Always willing to work hard and long hours. But that is spilling over into Saturday and Sunday’s. My mind does not rest. Persevere or start looking elsewhere?

like

Has anyone ever turned in your 2 week notice, leadership said they would make things happen for you, so you stayed, and then they didn’t do anything about it? Or what has your experience been

like

Boomerangs, did you guys come back to a different firm and/or group after your industry detour? How hard was it?

like

Ladies, are gifts important to you?

like

Fat Joe talking about BDO robbing him 🫣

likeuplifting

If one more person uses "ask" as a noun or "champion" as a verb...

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