What is your favorite new or recently discovered formula? One that I’ve been using a lot recently is MAKEARRAY. I’ve found it to be incredibly versatile in making dynamic worksheet features that were never possible before without VBA.

Hi everyone!
I am looking into doing a Masters in Social work I have already have a social science background and have worked as an international development professional but I’m considering getting into medical social work. What are the pros and cons of being in this field

Does anyone here know anyone who has left their CM role? What was the next step in their career?

Apparently I drunk ordered 4 Blanton's Golds last weekend. Just got the shipping notification 😂🤦🏼‍♂️

Have been offered 07B grade in ibm..
Wat will be the roles and responsibilities.?
Stack : Oracle ERP
YOE : 7.5

Hi there. I am an Operating Room Nurse thinking about pursuing my Masters in Healthcare Informatics. Is there a position for this career path that I can take while completing my graduate studies?

Hi

Is anyone able to access prudent mediassist portal to submit claim after new entollment ?

I need help from an accountant or a financial analyst. I need to compare fed vs private company retirement and help me create a retirement plan. I will pay for the services. Thank you

What actual stocks you all buying today? Got some cash from settled trades I want to deploy

Any recommendations for a good, no fee business checking account? Online only is fine.

Anyone made the jump from EY DnA to Bain AAG (or vice versa)? I’m wondering how they stack up across technical capabilities, project mix, WLB, etc.

Hi fishes,
Please help me with Natwest relocation thing. I tried to understand through offer letter but it’s not clear to me. How can I claim Goods transfer, and if I am staying at my friend’s place, how can I claim accommodation allowance. Thanks a lot

Any one here at HIMSS this week? Anything exciting to look out for?

I’m burnt out and planning to leave my job soon to recharge and freelance for a few months. Am I crazy? I feel good about it but once in a while I second guess if I am doing the right thing...

Wishing all a happy holiday and thank you for all you do

What is jl of applications architect in tcs...is it C3b or c4 or higher??

Is it true for Assoc 602 level who hasn't completed one year, can't have S. My managers(functional and local) gave this reason for my OOO?

My functional manager personally messaged me later and said his recommendation is SOS but they cannot work past through the rules of less than 1year

Any book recommendations on excel modeling for real world business applications?

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

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?

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

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)

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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

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

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.

How do you fix microsoft excel cannot paste data error?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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.

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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.

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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.

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?