My data tables are consistently not calculating all the values which I have encircled. The values are not increasing with the multiple. Could someone help advise

If you could take one-month off to do anything, what would you do?

This feels like a good forum as any. Looking for recommendations on a good GoPro (3) accessories kit? A little overwhelmed with all of the different 3rd party stuff that's available out there.

What does a Supply Chain Director with 20 years of experience make in Chicago?

Who works in Monitorships and Investigations? I want to learn more about this role.

Hi everyone,
Is fire engineering a good field to be in? Can someone tell me about the pay scale, growth opportunities and the future scope of fire/Safety engineering?
Asking for a friend who’s done mechanical engineering and is thinking of specializing in fire eng

Thank you

Has anyone dealt with a FIRPTA withholding on a sale? It looks like the seller of a condo I’m interested now is an international student so it would apply. Are there any specific steps to take with this kind of transaction? Is it as simple as withholding 15% of the Sales price from the seller to remit to the IRS or is there more to it?

Hi All,
Please help me with unlock DM
Much appreciated

What dress shirts do the men wear? I'm tired of the elbow in my shirts always ripping. I think I've had 3 or so shirts rip in the elbow this year. I typically buy shirts in the $30-40 range. Do I need

What’s a Digital Consultant?
Expecting answers with examples please @

Hi Everyone, I have almost 1 year of experience as Business Analyst in telecom domain ( AI poduct specialist/QA) Total experience of 3.5 years in Retail and Trlecom domain. Any referral for Business analyst role

I moved out of NYC in February and have been renting out my place in Park Slope since. Any nyc landlords have tips or warnings I should be aware of?

Has anyone rejected the LTI offer?
How has the HR taken? Can i hust ignore their calls so they get an idea?

Hi All, does anyone have information on Markel client in Synechron. How is WLB in the project.

You can’t burnout if there’s nothing else left to burn. LIFe IS greaaat, isn’t IT?!

Hey Everyone,

Can you please guide which one would be better for Data Engineering Maersk or PwC?

There is senior in my team whom I have to work very closely. He is very good at showing that he is working hard infront of Senior Management but really he doesn’t do much work and many of a time I hav

what is the salary at Standard Chartered for Analyst (transaction monitoring) with 3 yrs of professional experience?

We don't answer calls from numbers we don't recognize, we ignore voicemails, we delete emails and we'd rather interact with our phones. Is anyone else concerned about the future of finding work?

what's your best resource / website to reference when learning macros VBA?

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

Thoughts on learning VBA? Is it useful in consulting? Many people argue Python is better to learn overall?

Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

I have an idea- unsure about the execution...

I have an Excel worksheet which has a table of items, i.e., a stock count of items available.

Is there a way to link this table to Microsoft forms/sharepoint whereby someone can request an 'x' amount of stock from this summary table and whatever the requestor asks for, once approved, is automatically deducted from the table of figures and the corresponding items

I appreciate that there is a lot of automation in the above. Would welcome any advice

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

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

Anyone have any resources for improving your skills building valuation models for the purpose of CDDs in excel? I’m moving to a new firm and my old one often had our offshore team build out the majority of our valuation models. Now I’m going to be responsible and I want to prep before I onboard.