ran

I tried adding a basic card to my Power BI file, and what should have taken 5 minutes has stretched to an hour and half. :mad: I have one table. It has maybe 150 unique customers and 12,000 rows with all their invoices. I made a simple RankX measure: RankX(All(Table[CustomerName]),[Total...

Is it possible to have an email notification when one of my files is open by another user? I have used MsgBox and With Outmail code before but it was when someone ran my macro. I wasn't sure if it can be done with my file is opened. Thank you in advance.

I need a VBA code that will multiple column A*B and insert it into column C. Range(C:C).Formulat = "A1*B1 The reason this code is tricky for me is because the code will be ran on worksheets with varying amounts of rows, so it needs to only be ran for active rows. The data also has a header...

Hi guys, I've searched for an answer to my question but don't seem to have any luck since this is somewhat of a unique problem. I have a very extensive vba program that I've designed for my company. I figured that before I'd start adding even more to it that it would be a good idea to...

Hi I wrote a macro that suppose to count how many sheets and then rename them to hello1, hello2, hello3 etc. I ran the code and it did work for the first time. for the next time after I added a new sheet (manually) when I ran the code I got an error message saying the name is already taken. How...

For some reason my immediate window only displays the last half of my output. It's only a couple hundred lines at most. I ran a for loop from 1 to 10000 and it worked just fine. Anyone know what the problem is?

How do I make it so I can see which activities should have been completed in a certain time frame (e.g 1 month). Which ones have been completed, and then which ones have over ran, so have not met their deadline. And can these also be counted up at the end? So a total of completed and not...

I have this paper I would like to input into a excel sheet so when someone add the number to the "pcs ran" it automatically completes the rest. "Ind 1 X 2" would be pcs ran time 2 added to the current number in the line above it. How can I do this? <a href="https://ibb.co/m654yA"><img...

I did not realize Power Pivot had been added back to Microsoft Office, thank you to Power Geek for pointing that out!! I have 2 tables of data I cleaned with PQ one that looks into a network folder and creates an average of 12 different columns of data that I have. There are approx. 300 rows of...

Hi Everyone - I initially missed a value when I was typing into my data set. I then ran my pivot table and noticed it was missing. I copy pasted my new data with my correction and could see that it was there. I ran my pivot table again and it was still missing. I filtered to see if it was...

Good morning, I am trying to match all words that occur more than once in a string, for example: A1: The man ran ran down the the street. B1: If the boy goes into the cave then the boy may get hurt. I would like to return in cell A2: ran,ran,The,the,the I would like to return in cell B2...

Hello, I am trying to rank a list of minimum values but when I use the formula RANK(A3,$A$3:$A$15,1) I get weird results making it ran the 6 as 5 and the 7 as 9. How do I make the formula rank 6 as 2 and 7 as 3? <colgroup><col width="64" style="width: 48pt;" span="2"> <tbody> Column A...

Hello all, I know there are a ton of threads on calculating time and I read a bunch and tried a bunch, but not finding anything that works for what I'm looking for (or at least that I can figure out). :) I'm trying to keep track of time a machine runs. See example below End goal is to have a...

Hello! I've had this issue crop up a few times now in the same project, and I can't make heads or tails of it. The most recent time: I have 5 comboBox shapes on a worksheet, and when 1 of the comboBoxes changes it resets the other 4. Code looks something like this...

Could someone please help me with vba coding for the below excel query raw data <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> name score name score name score zen 32 men 22 ken 58 ran 45 den 23 shen 56 connor...

Hello, This may be done someway different, but I am looking for either a formula or VBA to add hours ran on a machine. I have a calendar on a spreadsheet. I will input the hours each day the machine ran. I want to add these hours in a different cell. Once we do a PM on the machine, I want to...

I have a spreadsheet that is 1.3MB big. Not a large spreadsheet in my mind?! there are alot of formulas throughout though, it was fine yesterday but today it is showing up a excel has ran out of resources error...does anyone know how to work around this/fix it/get fir of it?!

Hi Guys, I am looking for a way or VBA to check all data in a selection of cells and put them in to a table with a count of how often each word appears. Example: The Cat ran to the second cat The -1 Cat-2 Ran -1 Etc

Hi all, very much banging my head on the desk on this one. how can I write a formula that splits product we made, lets say 5000 units, over 2:08 (2 hours 8 minutes) BUT.... here is the trick, - in column A I have a list of date and time starting at Monday 5:00am - but what if we started...

Ok, so I built a spreadsheet to track my running throughout the year and I'm trying to see what my averages are on each day of the week. Through an exhaustive search, I can only come up with the following formula =AVERAGE(IF(WEEKDAY(A2:A366)=2,B2:B366)) Column A is the Date where Column B is...