office 365

Hello fellow excel enthusiasts 😊 I’m stuck trying to figure out a working formula or creating a better method to use, and was hoping that someone might be able to lend a hand, please. I have a table, detailing the amount of water that has been consumed (in ml) thought the day, marked at hourly...

I am currently using the following formula to calculate how many days have passed since the last actioning date. =DAYS(TODAY(), [@[LAST ACTIONING DATE]]) How can I modify this formula to not return a result in the Actioning Date cell is blank? Thank you for any assistance.

I am trying to graph attendance over time for a large number of events. This data is presented by week, so I have attendance per week for each event. The events take place in multiple locations, so I want to be able to see how attendance compares at each venue by graphing the lines on top of...

Dear members, having below query with excel filter function. Given below is data set, formula 1 and formula 2. Having query with formula 2 given below. I am not getting why result of formula 2 is including item with units sold =4 when my condition for filter is unit sold is >5. (formula 2...

Hey Guys, I have been investigating for a while an issue, I have a userform with multipage (Page1, page2, Page3) . The 3 pages have command buttons and labels, but only the page1 keeps the memory of the labels as "Completed", when I try to run others codes in comandbutton in page2, not sure...

I am working with a price list and would like to select pivot table fields (column headers) based on the price level (PL) selected which is also a column headers. The price level is indicated by Z0 and Z1. This particular column header can be used or not as part of the solution because there is...

Google Forms saves responses to a Google Sheet, which can be accessed live. Microsoft Forms clearly saves responses somewhere, but I can't seem to access the Office 365 equivalent of the live Google Sheet attached to the form. The "See in Excel" link basically exports current results into an...

I am using Office 365 / Microsoft Forms to collect information from users within my organization (i.e. sign in is required to fill up the form). Let's say the goal is quality control, and a bunch of widgets are assigned to colleagues to test and rate. A specific widget (identified by...

Hi team, so I switched from Office 2016 straight to Office 365, used it for a few days and went back to Office 2016. Now a few VBA macros are not working for me, but they still work on my colleagues computers who are still using Office 2016. Could this be caused by the cache? Any idea how to...

Hi Folks, I have been asked to generate an online excel spreadsheet and automate some functions that I would normally use VBA for. I've read a bit of intro material, but Office Script seems alien to my brain right now. How would one replicate the following VBA code? Sub setvalue() Dim ws...

Hi all, I've got a document I'm using as a template with several sections. Page 1 is a title page with the: Document Title Published Date Updated Date Those three items are all bookmarks. Those three items are also included in the header of each page. When I'm ready to finalise the file...

Using REDUCE function in Office 365 we can get combinations of items in different columns very easily. =REDUCE(A1:A4,B1:D1,LAMBDA(x,y,TOCOL(x&"-"&TOROW(OFFSET(y,,,99),1))))...

Hi all, I am trying to figure out how to calculate the Exponential moving average of a stock. The sheet shows the steps involved. I tried using the scan function but I couldn't figure it out. I hope someone smarter than me can help with the formula or point me in the right direction. I know I...

I use the checkmark symbol a lot and I would like to use a macro to add a checkmark to a cell that I select. I tried recording a macro to add a checkmark to a selected cell but I need it set up so that it will place a checkmark in any cell that I select, not just the one that the recording...

Hello. I am trying to group dates in a pivot table by pay period. The pay periods extend from the 1st of each month to the 15th for the first half and then from the 16th to whatever the last day in the month is. In the date grouping options I can only find the ability to group dates by the...

Hello, I was using 32-bit Excel 2013 and had a workbook with a number of bespoke functions, some simple, some not so simple. However, after upgrading to 64-bit Office 365 all of my bespoke functions do not seem to be working. Here is example code to work out the inverse of the tangent...

Hello Excel experts! I am in need of a macro in Sheet A that creates a tab delimited blocks.txt file from range A36:C50 in Sheet B in directory C:\Users\user\Desktop\AsBuilt\blocks.txt Also, since I will be using this same file to import blocks in AutoCAD, I wouldn't mind if the newly created...

Hello, I have to migrate a very old excel file with many macros from Office 2010 to Office 365 (Office 2010 being no longer supported). The Excel file works perfectly on Office 2010. When I run the VBA compiler, I get the following error message: Compile error Variable not defined Here is the...

I have a file with three worksheets. Sheet1 is a summary of all clients. Sheet2 has a table that copies only clients with "active" status from Sheet1, Sheet3 has a table that copies only clients with "buyer" status from Sheet1. Is it possible to write a vba code that will delete rows from...

Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...