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

And definitely let me know if you have any questions or feedback.
I’m focused on making content that is entertaining and instructs effectively. This is video 3 of 50, I’m not great yet, but getting much better and quickly.

like

This is great

like

I love your content! Super clear and funny! Great production too! Thank you!

likeuplifting

Thanks for watching and the kind words! I’ll keep these coming out every week or two. Goal is to get to one a week.

This is great!

like

Heck yeah, thanks for watching!

Impressive! Thanks for sharing!

like

Thanks for watching!

like

I love it - I didn’t know this function existed and it’s way better then creating my nested if statements. Can’t wait to try it.

And you’re in good company! I remember being surprised that the function had already existed for a while when I first learned about it. Do you use Excel a lot?

Thanks for watching!

How is the performance on this compared to a series of if’s in a large data set 100k+? I have broken my if’s into a series of 7 different cells to try and get it to fail the data set as quickly as possible or arrive at the most common scenario as quickly as possible. I’m wondering how using IFS would impact the performance. We’re still stuck using 32bit office, so I do not have a large amount of memory to play with in the application. If it improves speed/responsiveness it might be worth me switching some of the formulas.

Related Posts

Hi Sharks,
Can anyone please refer me in Deloitte India pune ?
I have 12+ years experience in telecom domain.
Skills Unix , shell scripting, SQL,plsql, microservices , keycloak,apiman,kibana,redisrabbitmq installation and configuration, problem solver and good communication skills , project deliveries in agile methodologies and consumer interaction.
I am looking for senior business analyst or senior technical lead position.
Appreciate any help!!

like

Hi all,

I'm currently working at Infosys as MSBI developer and looking for opportunity in any of Big 4. I noticed there is a job vacancy for the role I fit in PWC in Linkedin and here to check if anyone could help me with referral.

TIA.

Valuation people, how long until you got good at your job? Im 5 months in and can still barely follow..

like

Does PHR certification help in India, as this is globally recognised how much valuable is this currently in indian job market.

Do we got some good offers or its another certificate just to add to CV after so much of investment & time I don't want to get this wasted !!

Need suggestions ??

Considering acquiring a blog/website that has good SEO value (DA, etc.). My site is complimentary (more product focused), but same niche. Is there a way to best integrate with my own site to retain/maximize SEO value between the two?

I am thinking perhaps I could simply redirect users to the new website when they click the "blog" section on my own website, but not sure if that's the best way. Any advice is greatly appreciated. Thank you.

like

Convo about mentoring came up recently. I suggested on a whim to a SE to find a sales rep mentor to learn about the mind of a sales person. Never tried it and now I am. Has anyone tried this?

like

Do you agree or disagree that email marketing is still king?

like

Hey everyone,
I’m currently a Market Analyst for a small consulting firm. I’m looking for a new role with room for growth. I bring enthusiasm and experience in modeling, forecasting, and research. I would be grateful to be connected or referred for any open roles you might know of. Thank you!

like

Tips on looking for a remote position in the communications, Public relations, or marketing field? Everything I find seems to be a scam, way underpaid, or a 100% commission based role.

like

Any recommendation on under eye cream for wrinkle??? Thank you!

Hi Everyone! I have been working in Salesforce for about a year now. But I am not enjoying my work as it's mainly on backend. I have been wanting to move to Web Dev. But someone suggested that like if I like frontend I should try LWC instead as I'm already into Salesforce. So I'm quite confused which way should I go. Can anyone help me with the same Tata ConsultancyAccentureDeloitteZS AssociatesInfosysSalesforceSalesforceAmazonMicrosoft

like

If anyone needs referral for Novo Nordisk hit me up

like

Is it a good idea to resign first from current company and start searching for another job because my notice period is for 3 months and most companies won’t wait for you for 3 months.. Not Even getting calls if I Update as 3 Months NP ? And please let me know when is the good time to resign and search since I heard hiring will slow down now in the Year End

like

It is elementary that the development of a theory is based on completed and finished works or theories with a sufficient basis to be possible. But what were guys like Plato based on? He could only rely on what his mind told him. It must have been very difficult but at the same time, they were very brave in defending their ideas.

like

Looking for some boutique firms (healthcare/public health sector) that do work relating to social determinants of health, community health centers, population health, community hospitals. Any suggestions?

like

If you were to transition from bedside which path would you choose?? Education, Quality management/coordinator, Administration?

like

Can NY RNs apply for compact license if they want to work in NJ?

Hi folks, how is thoughtworks as an organisation?

Asking because I don't know much about it and have received recruiter's call today. Currently I am working in
Deloitte. How is thoughtworks hikes, wlb, does it provide any benefits apart from fixed pay? My research gives me a mixed review: some say it's good, some say that thoughtworks is not stable enough like big 4 or other organisations. Pls help Thoughtworks Deloitte

like

I feel like I can’t manage all of the expectations all at the same time and I’m constantly dropping the ball. I’m so overwhelmed and under supported, I’ve reached out to my manager that I need help...

Additional Posts in Excel Genius

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

Post Photo
likehelpful

Would anyone be willing to teach me vlookup?

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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 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

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

How do I compare two sheets to make sure they are identical?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

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

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

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

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

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 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

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