I have an Excel file for label template with 6,300 items (each item has a parent ID which matches the picture name that suits the child item). I found code that
I have pivot table amount columns: 0-100, 100-200, 200-300, 300-400, 400-500 How to make group by more criteria? I want until 100 group by 25, then from 100 u
I'm trying to tell python to insert "No work" in certain amount of cells, depending on how many days has passed since the codes was run. So basically, let imagi
I currently have code that inserts two columns, and copies values from two other columns into these two new columns. 'Insert 2 Column to the Left of S Colum
I have an existent graph to which I added a macros. The macros should update the axes, add a datalabel to the last point and delete the datalabel of the previou
Trying to dynamically get cell value from worksheet in same workbook, depending on worksheet name in column E =IF(E108<>"",INDIRECT(CELL("contents", E108)
I am using Read Delimited Spreadsheet.vi in LabVIEW and need to read data from other than the first sheet. How do I tell LabVIEW that want to use other than the
I am trying to download an Excel in Sharepoint site into an R dataset. But I keep getting errors. I have also tried searching for solutions across forums for th
I'm trying to get the shorten bit.y URL in my excel file, but instead I'm obtainig the following message, {"created_at":"2022-05-04T21:48:32+0000","id":"bitly.i
I am using this formula to pull the client's highest score: =MAX(IF(FILTER(Appointments!G:G, Appointments!C:C=C2)>0,FILTER(Appointments!G:G, Appointments!C:C
From our audit database I derive an Excel table like this one below. What I need to do is populate a table in a word template document with the content of the f
I am currently trying to produce a filter/summary for a data set using Sumproduct. The data is a list of codes, regions and managers each with a row value (&po
I am new to PowerShell. I have a file name as Input.xlsx file, which will contain 3 columns and we an filter on any column and save it. My requirement is to cop
I want to ask something. I have data close to the lineare in Excel but with different values: Y: 88.0 87.4 86.5 83.2 X: 2004 3002 3900 4500 I have created a gr
I'm using Apache POI 3.6, I want to read an excel file which has a date like this 8/23/1991. switch (cell.getCellType()) { ... ... case HSSFCell.CE
Part 1: Please help to advise where did it went wrong. Would like to sort for column E via descending order with header Sub SortRows() Dim destSht As Worksheet
Is there a way to swap many instances of strings at once without nesting? For instance, say I want to drop all instances of the following values from a string:
Okay, totally noob coder here. I'm working on a sheet that has a repeating series of 1 combo box linked to one other combobox and a checkbox. Basically, the fir
Within this picture, an Excel chart is displaying approximately 100 values + times (red curve): Excel is "intelligent enough" to reduce the number of the displ
I'm currently working on a project where I want to be able to manipulate and graph data with relative ease in Excel. However, a lot of the data involved exceeds