Forum Widgets
Latest Discussions
Matching columns in two spreadsheets
I have a larger spreadsheet with email addresses in one column and a lot of other demographic data in the other columns. I have a second, smaller, spreadsheet also with email addresses in one column. I would like to match the two spreadsheets and create a third spreadsheet with all the demographic information from the first spreadsheet associated with the email addresses of the second spreadsheet. Help!
Excel Office Script "Performance API"?
I was working on an Office Script and trying to improve the performance. I typed "Performance" into the code editor, and I was suprised to see the Intellisene kick in. My question is how to find and understand the relevant documentation for Typescript applicable to Excel Office Scripts. I could not find this object/API in official MSFT Office Script documentation. Icing on the cake would be a suggestion for a more sophisticated way of measuring performance bottlenecks on an Office Script. I have attached a screenshot of the object and Intellisense. TIA!
Pivot chart not displaying all data from pivot table
Hi, I have created a pivot chart (clustered bar graph) and accompanying pivot table. However, the pivot chart is not displaying all of the data in the pivot table, it is only displaying every second row (i.e. 25 rows of data instead of 49). Is this because there is a limit to how many rows a clustered bar chart can display or could there be another reason? Many thanks.
Issue in Days Function
Hello there, I am Balaji, I hope you are all doing well. I am using Windows 10 in Dell Latitude 7480 Laptop. I am facing an issue using the "Days" Function. DAYS Function Explanation and Description mentioned in Excel Software: DAYS FUNCTION This article describes the formula syntax and usage of the DAYS function in Microsoft Excel. For information about the DAY function, see DAY Function. Description: Returns the number of days between two dates. DAY function This article describes the formula syntax and usage of the DAY function in Microsoft Excel. For information about the DAYS function, see DAYS Function. Description: Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Now, If I am using the "DAYS" Function to calculate the number of days between two dates. Suggest me Which Function should I use to get the correct answer. I am Looking forward to your guidance. Thank you.
Index & Match formula not working on multiple column
https://onedrive.live.com/personal/8419718c3ad8f98c/_layouts/15/Doc.aspx?resid=8419718C3AD8F98C!s94600d3fa0044d418fefd1508e44c0e2&cid=8419718C3AD8F98C&migratedtospo=true&app=Excel Hi Folks, I'm facing error on the match formula, which I tried to apply, I'm getting #N/A error... I tried few trouble shoots to make it work (adding helper column, broke the formula with "&" to make it work, checking for any additional characters & checking the format etc) but it is not working. I have used Match formula earlier, but never had this issue. I want a single formula to MATCH & verify multiple column to return the desired output, I can do single column verification & again to do the next column verification and get the result but it is tedious and not time saving. Kindly help me to learn how to make a formula work to one validation of multiple column. Kindly attaching the sheet above for reference. Highlighted the error in yellow hue(Sheet name - result). m_tarler & HansVogelaar - Please help, Thanks in advance
