office 365

Hello. I am trying to create a histogram off of pivot table data. Sample data... When I am clicked within the pivot table and try to add a pivot chart and choose histogram... i get the following error. Is this because of the larger counts or... is there other way of accomplishing this. A...

Hi Everyone, I am short some correct code to finalize this sheets for customer ageing This is the sheet with full data of invoices ABCDEFGHIJ6OUTSTANDING INVOICESREPORT DATE:5 Sep 202478DATETYPECUSTOMER NAMEINVOICEAMOUNTVATDUE DATEDAYS DUESALESPERSON91014/09/2022InvoiceMy Skin...

Is there a way to have a sheet have the alternating rows but have a formula within it so I don't have to do double the work? I want to color every other row but one of the formatting options I do is a fade from my XLOOKUP or dropdown menu in the overall status and I want the white rows to have...

Hello, so I'm using Microsoft Excel on Office 365 and I'm using the VLOOKUP function and having some issues. Here is the current state of my formula I'm trying to troubleshoot: =VLOOKUP(C3&"*",A:B,2,FALSE) Column A is filled with identification keys composed of letters and numbers while column...

Hello. I used to have a VB script that worked with Excel..years ago. I now have Office 365 and want to do the following. Loop thru a number of folders and pull particular cells from particular tabs and import them into a master file. For example .... folder layout is .... main folder (static...

Hi everyone, I did try Vlookup but its not working, since there is 5 columns as reference for lookup value to select the customer for salesperson it is difficult for me to select which formula can work perfect. This is the sheet look like for each salesperson, it should have formula in all...

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...