Excel Genius

Any tips on creating a formula that counts the specific iterations of a value? I.e designate a 1 the first time the value appears in a list, a 2 the second time it appears and so on?

Anyone have any helpful prompts using Copilot yet? What were you doing and how much time did it save you?

Anyone have a good framework for an NPS dashboard, retail focused.

Looking for inspo

Does anyone have a template for a Vendor performance scorecard? Or can you point me in the right direction to find one?

I'm trying to learn Accounting and Finance Analytics.
Can someone suggest good YouTube tutorials which solve problems and teach concepts?

I need some help . I’m trying to find the formula that will help me create a calculator of some sortes . Im trying to take my current cost add my margin % then add taxes and fees . After that I would … more

Is it a norm to have an excel file to have 50+ tabs utilizing 2+ million cells with formulas?

I moved from excel to excel online and my formulas broke :(

I have a column with names, ~1000 rows, the names of the individuals shows multiple times as it is a list of PMs for all projects in my department. Is there a formula that allows to copy paste all the names into … more

Since a recent MSFT update my Microsoft online products have been wonky. Getting logged out, slow response, lagging emails in outlook. I’m on Mac. Is it just me?

I have a table that shows values slowly increasing over a three year period. In a separate sheet, I am trying to only sum values that are larger than those previous in a given array. Once I sum those … more

Hi,

Does anybody knows of a formula to bring in the previous quarter in format “QX” based of another cell with a format “QX”?

This is for a live formula and I will need it to work for the 4 preceding quarters. My l… more

Anyone has a simple task tracker template that has different tabs for different team members that all pour into one main tracker tab? I tried creating one using power query to link the tabs but it'… more

Hi, does anyone have a simple task tracker template, which includes priority, due date and % completed?

Please and thank you! I’m trying to keep track of all my to-do items for work at a new job and I’m dro… more

I get an error that says “file cannot open because file format or file extension is not valid” when I try to open some of my excel files. My colleagues can open the same file (since it’s on share poin… more

Anyone got a good form to count distinct values in a table with conditions? I can use countifs to get the total number of rows but I also need one that gives me a number of distinct values in another column… more

Not Excel related per se but how is there no Power BI bowl?

Does anyone know how to do macros with VB script without having the Developer tab?

I don't have a school or work account to create the macros properly. (Excel keeps giving me this error)

Suggestion… more

“there is data here do you want to replace it?”

is there any way to disable this feature? i have never wanted to replace it 🙃

Any Scrum Masters here using excel to help organize your teams work? Capacity etc?!

How hard is it to get your Mous certification and once you pass what jobs can you get with that?

Maybe someone can help me. I am trying to count the “yes” in my column. I did the countif function and still comes out counting all cells that have something in them. I thought maybe it isn’t recogniz… more

We're hiring for remote work positions in Data Entry, Remote Customer Service, and Records of Patient Administrative Assistant, offering flexibility and a $17/hour pay, with strong communication s… more

Hi! I'm looking to merge/ reconcile two sets of columns and I can't figure out how to do it. Data will either be populated in column A or column B, but never in both. I'm guessing the logic shou… more

Is there a way to do keyword searches for a pivot table?

Like, say I have a comments/feedback field, where employees can say anything they want to. I want to do a keyword search for things like "pay", &q… more

I'm having problems with VLOOKUP formulas that look to external workbooks.

Some of my VLOOKUPs to other workbooks work fine, but others in this file (looking to the SAME external workbooks as the properly working formula… more

Hi! I'm new to Excel. I'm using a formula to send out emails from Excel. It appears there is a character limit for the body text of my email. Does anyone know how I can add more text without g… more

Best way to take the weighted average total net leverage for a group of investments (companies) based on the amount invested per company in comparison to the total dollar amount invested?

Essentially, … more

Having major issues with circular references and iterative calculations, is there a good way to sidestep this?

Also, is there a way to print to pdf without showing the annoying blue tracing of circula… more

I have been asking *so many questions* this week and for that I am sorry lol.

Now, regarding power query in Excel, does anybody know what specific situation would entail XML mapping?

I am asking because… more