Have You used Office Scripts in Excel instead of VBA? If yes, what kind of procedures did You replace?

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

Related Posts

How does the KPMG annual performance reviews work? At what month are the reviews done?

like

Hi All, How much to expect at Manager level at Cognizant

like
like
like

Hey Amazon @ employees!
Just passed my phone screen for Escalation Engineer. Any tips for the technical interview?

like

Any tips on where to apply for a job as a non-french speaker in Paris?

like

Please tell us, since COVID started:

-weirdest thing you've eaten
-weirdest thing you've watched
-weidest thought you've had.

likehelpful

Have you, or anyone you know, gotten covid twice within weeks or months? I’m being told that you can catch omicron 2 weeks after recovering…

like

We were not trying to conceive. And I was drinking alcohol like twice a week.
Now I missed my period and pregnant. I am panicking a lot, not sure if I want a baby right now. Definitely i cant deal with pregnancy constantly knowing how much u drinking could have affected the fetus and if i could ever endure the consequences it would bring upon the baby
Help me understand if my baby will be fine or not.

like

I just started meds yesterday and the change in my focus and attention to detail is mind blowing. My only concern is, just yesterday I had a tough feedback session with my manager around how I’m taking too long to complete my work, giving them anxiety around close deadlines. I’m new in the job (3 months in). Should I explain anything about my adhd to my manager or just wait for them to notice the change in me?

like

Hello All,

Please help me to unlock DM features.

Appreciate your help. Thanks in advance!

like

Anyone from DUSI Tax consulting CLM?

A lot of Cougars in this bowl. The question is how sexy and salty are you? Feel free to DM

likefunny

How is this different from the love is blind bowl?

like

Very quiet in this bowl🤔

like

Do we have work from home option or Hybrid culture in DBS?

Wondering what other high paying (6 figure) jobs might be out there that have the same level of intellectual stimulation as consulting without all of the schmoozing and social obligations. Any ideas?

like

Can anyone help me understand what c9 grade means in NatWest job grade? what are next two grades after c9?

like

In one interview today with Kundyl. Their expectation is to be available oncall 24*7... With work from office.

They literally got offended and stared at me for asking about WLB...

Seems companies are not learning, even after the great resignations.. the big names... Like TCS, ibm.. are not doing any changes to their work culture and ethics to improve WLB.

like

Hello Fishes,

Is it good to join Kyndryl from current organisation NTT Data for location Bangalore ?
Is it possible to discuss regarding Work from Home or work from nearest reporting location ?

Need suggestion and your help!

Thank you in advance!

like

Additional Posts in Excel Genius

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

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!

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Anyone know what these badges are?

Post Photo
likefunny

Still don't have xlookup. #fomo

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

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