Still don't have xlookup. #fomo

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

Related Posts

how am i supposed to determine the number of partnerships if i keep getting org charts that don’t clearly state that entities are or are not partnerships?

like

Does anyone remember limewire and Morpheus days. My computer had so many stds from downloading all those music files

likefunny

Nagarro car rental
Hi Nagarrians, Can I give an account number of a different person and the bill/ RC of other?
I don't want to give the account number of same person of whose RC I have given..

Please help out a newbie here.
TIA

like

You talking to me?

Post Photo
like

Just got word that my position is bring eliminated, would love to get some leads in the L&D space if possible! Thank you in advance!

like

He didn't want me to leave lol

Post Photo
likefunny

No BS, no fluff, straight to the point. As anti-cringe as it gets 😂😂😂

Post Photo
like

Marsh

Current CTC - 9.5 LPA
Work ex - 2.5 years
MBA - from a decent B school
Designation - MT

Am I being underpaid? Just wanted to confirm for knowledge.

like

What is the best Change Management certification? I see Prosci everywhere but I recently learned about the one offered by Association of Change Management Professionals (ACMP). I’m currently a Sr Program Manager within the Change Management arm of a small boutique firm looking to get certified in hopes of exiting into a better role/company.

like

Will production even be fun when we go back??

like

Bain & Company What is the likelihood of getting an offer at MBB consulting firms as a GCC National with Western education? Job is in Riyadh. Are the chances higher than elsewhere?Boston Consulting Group Bain & Company McKinsey & Company

like

How accurate are the GRE practice tests?

How many days would I be able to stay If I Country if I quit (not fired) my job that I have a h1b for? Moving to Canada and need some time to close up shop here.

I have got Gurgaon as base location in offer letter. But since I lost a parent(my father) and relocating is kind of not possible for me at this moment can I ask them to relocate me to Kolkata?

PS - I am a campus hire so a fresher - Analyst

like

For shits and giggles

Post Photo
likefunny

What is up with the groups of cars that drive around the Loop with their warning lights on honking their horns? Anyone know what that is about?

like

Which HCL office is better to go out of Magarpatta office and Quadra office in Pune.
Have a choice to join any of these two. Please suggest.

like

Hi there,

I've 7 years of experience in IT working as a Java backend developer.
Not getting much call from Naukri or LinkedIn.
40 more days to serve notice.
My current CTC id 16 LPA, how much I can expect?
I've an offer letter of 20.5 LPA from TCS, is it worth to go for TCS or should wait for other interviews?

Your suggestion will be much appreciated.

like

There are few things greater than sitting at home taking conference calls in nothing but your boxers and tube socks.

like

Weezer fans, give me a 👍

like

Additional Posts in Excel Genius

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

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

Post Photo
likehelpful

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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

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

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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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