I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

Sharing a motivational story for all early career folks who feel rejected/depressed/hopeless… Journey from 2.7 lakh fix to 75 lakh fix in 10 years , Tier 3 Eng. College . Domain- Data science

My school friend who studied with me joined an engineering college in Rajasthan ( Tier 3) 2008-12 batch. He couldn’t secure a campus placement and after taking some external training joined some boutique analytics firm in Bangalore in 2013. In the period of 2012-14 he was depressed. Continued in comment…

I have done analytics and operations consulting for 9 years and I don’t like anymore. If there is even a remote chance of getting hired for product management role, I would like to take it. I am reading the books on PM and polishing my resume, are there any other things that I should keep in mind?

"Fit for amazon but not fit for this role". Feedback after onsite interviews? what can I expect next?

How to land an internship in JP Morgan?

Currently pursuing an MBA with 5 year working experience. Is there any tips on how to get an internship opportunity in JP Morgan?

I got bumped back to platinum elite on both Marriott and SPG.. after being gold for a few months now (have been on a local project for a year now)
Strange.

How do I find myself a mentor at work?

Anybody knows about Bosch account in Nous infosystems or T-Mobile client in Prokarma.

Please suggest which one is good for wlb and job security. Nous Infosystems or Prokarma

I keep getting feedback from managers and interviewers that I am strong in product strategy and business mindset, but weak in technical skills despite my CS undergrad and 2 YOE as a software engineer. Granted I have not coded in many years but I am knowledgable enough to understand and discuss technical questions with my dev team. what should be the expected level of technical knowledge?

Cram studying for CFE. Is it recommended to study for one test and take one at a time, or study for all and take the 4 on the same day?

If IBM nominates for H1B, how long does it take to know the status?

I find it hard to have hookups and simultaneously look for a relationship. If I’m hooking up with people, I reject anyone who has feelings for me because I would be letting them down. If im looking for a relationship, I feel grossed out by hooking up with someone since it feels meaningless. It’s like a switch flips in me and I don’t know how people are able to do both at the same time.

You’ve got to leave before you get left.

I find it hard to respect devops engineers. They’re software engineers that don’t know how to code.

Planning ahead - my roommate gets married in December and owns the lease. Anyone likely looking for a roommate around that time?Will be looking at a luxury high rise with nice views and access to lga.

GAAP CHECKLIST 🙈😢🏃

What steps should I take to become a marketing manager in 4 years? I'm currently a coordinator but I'm very goal-oriented. Determined to achieve this!

I recently graduated college last year and am trying to pursue certifications to help build up my resume. I currently hold an AWS SAA certification and Azure AZ -900. I am looking to try and obtain the CISSP next. Is there something else I should start with before diving into CISSP or should I direct my studying and focus in that direction?

So xlookup? How is it going for you? Still haven’t use it.

Anyone know the shortcut to format selected cells as short date IE mm/dd/yyyy?

Too many format error, already tried the XLStylesTool. What next?

Is there a trick to analyzing more than 1MM rows in excel?

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

Best way to learn Spotfire? Just watch YouTube videos?

Hello Excel Genius!
How do I calculate the monthly average of items returned and credit return by each division in a year?
Thank you!

Anybody know if you can access an older version of an excel file (like from version history) using vba?

Trying to write a script to compare old versions and list changes since a given date

Help! Excel won’t let me navigate using my keys anymore, arrow keys and enter will not move me to the next box. This is happening on multiple docs. Please explain how to fix this as if you’re talking to someone who is excel dumb (because you are).

I have a workbook with a couple of custom lists that we use every month in my department. I'm handing off this responsibility to someone else who will be using their own laptop to do it. Will the custom lists pull over to their version, or do we have to set them up in their version of excel on their laptop?

What’s the shortcut to move between tabs? I try ctrl+up or down and it just goes to the top or bottom cell

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

Hi all - quick (and sadly really urgent) question for my excel folks. My computer restarted yesterday evening, I opened the excel file I had been previously working on this morning and I noticed the developer tab was gone. I added it back via the toolbar but now in that same file some of the specific commands within the developer tab are greyed out and I cannot use them. I’m unsure why this is happening because if i open a blank workbook everything is available?

I’m 26 y/o and working as a sales coordinator (basically an assistant) for 5 national account managers in the investment banking industry. I have a BS in Finance and am series SIE, 7 and 63 licensed. I’m only making $50k a year (before taxes). There are a lot of aspects I enjoy about my job but the pay is not cutting it. Recently, I have found a passion for working with data in excel and I want to try to make a career pivot into business analytics but not sure where to start. Advice?

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?

How do I use formulas that reference a pivot table without copying and pasting the pivot as values?

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

Not really excel - trying to convert a “text formula” result into a number result but I’m stuck

IF (AND(Monthly_Unique_Visitors__c  >= 0, Monthly_Unique_Visitors__c <= 50000), "-50",
IF (AND(Monthly_Unique_Visitors__c  >= 50001, Monthly_Unique_Visitors__c  <= 100000), "-20",
IF (AND(Monthly_Unique_Visitors__c  >= 100001, Monthly_Unique_Visitors__c  <= 250000), "0",
IF (AND(Monthly_Unique_Visitors__c  >= 250001, Monthly_Unique_Visitors__c  <= 500000), "7.5",
IF (AND(Monthly_Unique_Visitors__c