Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

Hey fishes!
Just wanted to know about any internship/part-time opportunities in the VC space. Currently working at Bain (Capability Network) as a Sr. Analyst. Just interested in working in this space and would appreciate any leads.
P.S.- Can devote 15-20 hours/week

Anyone else struggling? My wife is pregnant with morning sickness and we have a toddler so I am basically doing everything In between working. Feel like I’m about to break.

Anyone else feel like we are just shuffling in place? Feels like we were so fast to jump into quarantine and put solid fence posts up (rightly so) but I feel like we keep pushing the plans to get out of qtine our week after week with the same message being told without much progress.

Has anyone taken a road trip during covid through New England? Would I get stopped for having an out of state license plate?

I feel like I don't fit in with the upper middle class culture of accounting sometimes. I come from a lower middle class family, and it's hard to relate to the things my coworkers talk about - fancy houses, fancy cars, new gadgets that they are getting. I never grew up with those things, so I'm a little lost or it just don't seem that important to me. Perhaps I'm being judgemental, but I don't mean to be, it seems like we just have different priorities. Can anyone relate or have advise?

Didn't have top grades, wasn't on law review. Worked at a midsize firm and was laid off in march-- have about 3 years experience in a hot practice area. Have been applying and had some interviews at larger shops but nothing has come of it. I'm still applying to roles (not many out there) in my area but coming to the realization based on number of larger firm rejection letter that I may not find a role. Where would you go from here if you were me? Was making good money at the midsize...

I keep on reading stories about how Goldman Sachs analysts are working 80+ hour workweeks and making six figure salaries but are feeling burned out. I have a solution. Get 2x as many analysts to distribute the workload and cut their $150k salary in half. Seems like an easy fix, but I’m not sure everyone will be happy.

I work as a staffing supervisor and in the beginning it was really rough and I’ve decided two months in that I was going to quit. I advise my current job that I was and they decided that they wanted me stay and they agreed to move me to a different department that was less stressful and more up my alley. But they haven’t done anything yet and Although I’m not in a rush I’ve had more time to think and I still want leave the Company. i’m not sure I will to find hospital job in New York ..

Anyone know what’s up with the dealing that goes on near the classical music 7/11 at 451 N State? People out there 24/7 dealing; police normally posted up a block away. Users handing off what I’d assume is misc. stolen products.

Any single F in Edison, NJ up for a casual coffee date and hanging out maybe ( since everyone here seems to be married, wtf🤬 ).
I’m a single M 27, Interested in movies and road trips. 🚘

Hi! I’m interviewing for a clinical manager position on a postop Ortho floor and/or a PACU/SDS Unit. Any help with interview questions I should prepare myself for??

Any hope of the crime and homelessness every decreasing? I feel like I could never raise a family here, always have to look over my shoulder, and make sure my car is completely empty of any valuables. I miss the midwest 🥲

Hi fishes ,

Can someone help me understand on what is the salary package that we can expect at PWC SDC for the role of lead business analyst with 4+years of experience?

Hi Fishes, I've been seeing people posting on LinkedIn regarding openings in Bain & Co. for associate consultant/consultant
Can anyone working at Bain & Co. refer me for one of those?
Happy to connect with you if you're looking for specifics
Bain & Company

Can anyone provide guidance on salary band for clinical program consultant at United? Or share consultant salary. Located in Atlanta, position is in MN, 10 YOE in healthcare 5 YOE in consulting. Certified six sigma black belt and MPH.

Hey guys, did you ever encounter the following problem & know a solution:
Whenever I reference another tab in any given formula in my model, XLS first calculates everything as it should be. However directly afterwards (or sometimes only after saving) the formula vanishes and only the resulting value is left. Hence, all automation etc in the xls does not work.

Any ideas what's happening and how I can solve it without rebuilding the whole model?

What are your favorite excel macros to make you more efficient at work?

If I’m creating a comp set and a row of numbers will not adjust the number of decimals no matter how many times I adjust it in the “format cells” window, what could be the reason for this and how can I get around it

Is there an easy way to convert a manipulated pivot table to a normal table but automatically retain all the subtotal formula and grouping? For example, I have a pivot table with 3row fields (country, region, customer) And a 1 column field by month. I want to make a presentation to show top 5 customer by country and region….and group rest as “all other”….thanks’!!🙏

Experience a lot of downtime because I deal with massive amounts of data and need to constantly filter and delete records that are not relevant. Is there a workaround for this?

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

Can anyone recommend a specific video on pivot tables?

Public schools use Google for everything. So they use Microsoft Office as little as possible. Even Office 365 isn’t used much. I teach an exploratory class to 8th graders for Google docs and sheets since the school tech doesn’t support the educational MS Office 365. I like the MS Office desktop version because it does so much more than 365. I relate how Google does things similar to MS Office but not to the level that Office does.
Do businesses use Google docs, sheets, & the rest for anything?

Anyone have recommendations for a 5 year forecast model and/or template for a private company? (For a small fintech company)

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

Can anyone provide a reference to how to efficiently create and link an excel spreadsheet into a ppt (and make it dynamic). Thanks in advance!

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

Hello,
How do I randomly pick one name from a list in excel that has identical names?
Example:
Warehouses names
Ana
Ana
Hou
Hou
Aus
Aus

Every name repeats itself several times. But each of them has different lot numbers associated with them. I only need to pick one lot number number from each warehouse randomly. Is there a formula for that in excel?

why is index match superior to vlookup?

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)

Excel noob here. Can anyone help me write a formula where if a range (column) contains a particular value, then return a value in a different column of that same row into a cell?