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

like

Hi Fishes, I have 8 years of experience in testing. I am looking for jobs abroad. Any inputs on where I need to start like that .....

Do you think I could file this in lieu of a motion for extension?

Post Photo
likefunny

Happy Friday to all the "super lawyers" out there.

Never forget that you're not just super. You're super duper!

Post Photo
funnylike

Hi all,
What is the Pay band for Senior within the KGS FRM team?
YoE - 3.5years
Background- MBA

Western nc CTE interview questions? How do I prepare?

like

Hi
Has anyone used/given coderbyte sql assessement.
Just trying to get a little more understanding on it.

Hello everyone!

Is there any vacancy in Audit profile in Fidelity International. Any leads would be really helpful. Thanks in advance.

Does anyone use Power BI in their analytics?

like

He yelled jubilantly just before jumping. I hope he doesn’t think it’s okay because of how much we were laughing when he did it.

Post Photo
funnylikeuplifting

Do you think people working in the pharma industry will gain more trust, respect, or positive vibes in 2021 after vaccines are widely distributed? Right now it’s the industry with one of the lowest perception scores

likefunny

Dang. URI just beat Okla. 😭😭

like

I’m an experienced candidate who recently got an interview at BCG. Assume I’m not successful and I were to go for a one-year MBA starting in the fall, will I get an interview even if I don’t do the GMAT? I heard MBBs like the GMAT for MBA candidates, but if I can get the interview without the MBA, will the gmat make a difference while I’m in the MBA?

like

LA! Hiring mid-level CWs and ADs! Must have video prod. exp. and be very conceptual.

Solos and teams apply!

LINKEDIN ME (I’m bad at fishbowl)
Samantha Schneiderman (director of creative services)

like

For those of you taking Nutrafol, do you also add in collagen supplements to your routine or has the Nutrafol been helpful in itself? Thanks!

like

How bad is Yosemite on 4th of July?

The bird whispered that season 8 shall premiere in 2019!!

like

Hi Everyone ,
I need valuable suggestions from you all , I'm working as an SAP ABAP developer in a product based company with 6 years of experience
Current CTC - 11.4.
I'm looking for a company switch.
How much i can ask for during the next switch , please suggest

like

Additional round after the last HR round for TikTok, anyone else had this? It was informed 3 days after the HR round with TC negotiation. No hints on progress of offer letter. 

like

Additional Posts in Accounting

So FTX, a multi-billion dollar business, was running on quickbooks per the Financial Services Committee meeting going on right now 😂 Man their auditors gotta be sweating

likefunny

Hoping for help w/ studying. TRANSACTION CYCLES?? I see inconsistent lists online and in books: (Revenue, Purchasing, Inventory, Payroll) vs (Sales, Purchasing, Payroll, Financing) vs....

like

Anyone want to sell me their CFE books ?

like

Is the CPA designation worth it? For me it would take me 1 year of PREP courses and 2 years of PEP until i can write the CFE. And I am 27 years old right now. Also wondering if it would be crazy to pursue the CPA while learning how to code to be a developer as well?

like

Good morning to all those who are still in busy season for another few weeks. Go get'em!!

like

How many of you are receiving requests for feedback from people you hardly worked with this cycle?

like

Any ACCA students register for an exam using the new website? No combo of dates or locations ever works under 'Add Exam'.

like

Who is going to Discover in December?

like

Struggling to feel fulfilled in this job. Thinking of making a career move to skilled trades. Torn though since I put so much effort into a master’s degree/CPA exam already. Thoughts?

like

Friendly reminder with flu season right around the corner: please cover your mouth or stay home!

likehelpful

Has anyone worked for an accounting advisory (technical accounting) practice and FDD? Which did you like better and why?

I'm in an AAS practice but wonder if I'd like FDD more.

like

At what point do you folks just give up on working through an excel problem? I swear I could have saved time adding everything individually, but it would be a blow to my excel ego.

like

What is a decent offer, I.e raise, bonus, to go to another big 4? From assurance to advisory

like

With House Tax + HOA + Maintenance + Home Insurance + Security System + 4% mortgage, is it even worth buying a home especially at these levels? (NY/NJ area)

like

Is it possible to work at Deloitte & still have a life at the same time *sighs*

like

What is this "Tax Tech" I keep hearing about?

like

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

like

Anyone in the mutual funds group for tax? What is it like?

like

Thoughts on the mid-year staff/senior early promo? It would be getting promo to staff effective in April, so after 1.5 year instead of normal 2

likehelpful

Been having so many issues with our most recently class of new associates this year - like no class before. Laziness, entitlement, and no pride in their work. Anyone else experiencing this?

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