ID Value Valid MAX Group3 2 NO 8 Group3 8 YES 8 Group1 4 YES 4 Group4 2 NO 1 Group4 3 NO 1 Group4 1 YES 1 Group1 2 YES 4 Group1
I've been trying to develop and deploy an Excel Office Addin and I've run into a few issues. I've created an office addin by following the tutorials posted on y
I've just started using python so could do with some help. I've merged data in two excel files using the following code: # Import pandas library import pandas a
I have a code in VBA that I've always used to open Internet Explorer, copy the information on an specific website and than paste in a cell. The issue now is tha
I have 7 criteria = TMO-1 through to TMO-7 I have two scenarios to search from. i have either got a single excel with TMO-6, TMO-201, TMO-67,... etc (some have
I don't understand some parts in the following code: For i = 2 To UBound(a, 1) txt = Join$(Array(a(i, 3), a(i, 4)), Chr(2)) If Not dic.exist
The context is that I have a boatload of data dictionaries for various data bases strewn across multiple Word document files. Those files hav
Let's say I wanted to find the average number of calls per day. Normally, I can use the formula =COUNT(A2:A15)/SUM(1/(COUNTIF(A2:A15,A2:A15))) for the table bel
I have a dataset called verts imported from Excel with a column called Date that contains dates in this format: m/d/yyyy. I'm trying to extract the year from th
The black area contains a graph, when I hide the data the graph vanishes. I can still click on the graph and check/uncheck the "Show data in hidden rows and col
I want to insert an if statement in a cell through vba which includes double quotes. Here is my code: Worksheets("Sheet1").Range("A1").Value = "=IF(Sheet1!B1=
How can I read local excel data on my C# bot using bot framework SDK. I can't find any documentation for it. Can anyone help?
I'm thinking about writing script that convert my existing CSV file to XLSX file so I been following this post https://code.adonline.id.au/csv-to-xlsx-powershel
I have two xlsx files that have multiple tabs. I need to compare values in each tab based on the tab name. (e.g. sheet1 in file1 needs to be compared with sheet
My goal is to add a icon to my toolbar in the quick access section. I wish this code could look at the file that is open, check if the file name contains or rat
I am trying to filter data in an excel worksheet, copy the filtered data only and move it to a new workbook. However, when I complete that step, I still have ac
I have a data structure (array) in Access - 6 columns and 10 rows. I'm trying to write to a range in Excel ie B3:G12. I'm getting tied up in loops, literally. F
A user is trying to open an excel file (.xlsx) (using Open in App instead of in browser) from their Sharepoint site, but system tries to open it up in MS Word i
In Microsoft Excel I am considering columns and cells to make specific sums in a calculated column, here's an image as an example where the column "G" is where
My goal is to put the current week number in the subject of outgoing mail. Below gives me this week + 1. I used to have 2016, now have 365. Problem is still her