Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
288,741 questions
Newest Active Bountied Unanswered

Question list filters

Filter by
Sorted by
Tagged with
Filter by Employee ID
Score of 0
0 answers
15 views

I'm working with SSAS Multidimensional and Excel PivotTables. I have a dimension Structure with four independent attribute hierarchies: Level-1 Level-2 Level-3 Level-4 There is no user hierarchy, ...
Score of 0
2 answers
68 views

I have a table shown below that lists the names and dimensions of rectangles. I want to draw these rectangles on an XY chart, so I need to calculate the (X,Y) coordinates of the corners of the ...
Score of -2
4 answers
149 views

I need an Excel formula that can provide a value from a cell based on 5 criteria. For example, I want the YTD amount of EBITDA in P03 of 2026 for the region of LATAM. What formula can I use to get ...
Score of -4
0 answers
69 views

In my Excel automation, I select a cell via the Name Box and press Enter (so the cell has a green border). Immediately after, I use a Keyboard Shortcuts activity to send Ctrl + C, but Excel triggers ...
Score of -4
0 answers
102 views

I have made this easy looking Flow. It just takes starter point in the Excel spreadsheet and after goes through fixed amount of cells and reads and stores its number. What I want to do: I have ...
Score of -4
3 answers
210 views

Is there a faster, more efficient way to calculate a running total based on criteria? I'm using: =SUMIF(Table1[[#Headers], [REGION]]:[@REGION], [@REGION],Table1[[#Headers],[AMOUNT]]) The running total ...
Score of -6
2 answers
144 views

I have 4 separate sheets (sheet 2, 3, 4 and 5 to be exact, all named) all containing multiple columns (customer id, store id, address, date, time, etc) and I'm looking to see if the same customer id(...
Score of 0
0 answers
66 views

I am using a button to call a subroutine to copy a range of cells from a template sheet to an order sheet (a new row for a new order). I am doing an almost identical process for another feature of ...
Score of -11
0 answers
200 views

How can I automatically import text from an Excel spreadsheet into Photoshop text layers using a JavaScript/ExtendScript? I have a translation script in an Excel file. Copy-pasting it line by line ...
Score of 0
1 answer
208 views

I cannot get past this run-time error 1004 in Excel when I try to import a standard CSV file. The code I am using is: Sub ImportCSV() Dim ws As Worksheet Dim csvFilePath As String Dim ...
Score of -1
3 answers
251 views

My company uses a program for material usage calculation. It has very similar table system. I want to replicate it. Place in a formula below using numbers from placed arrays and then via PowerAutomate ...
Score of -1
0 answers
101 views

I have a script I'm working on to transfer two tables worth of output into a concatenation sheet, however it is erroring on the noted line as "subscript out of range" - I have triple checked ...
Advice
0 votes
2 replies
135 views

I am really struggling on this one. I am looking for a VBA solution, I don't think I can solve this with a formula. Here is my problem. Cell A1 value is either the boolean TRUE or FALSE. condition is ...
Score of -2
0 answers
111 views

I'm currently working on a spreadsheet that will automatically calculate how much I've earned, spent, and what I've spent over my budget. I've figured out a format that I'm happy with using lists and ...
Best practices
0 votes
0 replies
111 views

I have looked into many available options, But not able to choose one method, I have a proxy running in a closed server. I need to trigger actions based on the data from the Excel. Whatever I choose I ...
Advice
1 vote
2 replies
164 views

While practicing Excel functions such as LEN(), LEFT(), RIGHT(), and FIND(), I noticed that changing a cell's format from Date/Time to Text did not cause the functions to behave as if the value were ...
Tooling
0 votes
0 replies
90 views

We have built excel addin with react.js and I have deployed and my xml file is ready now. I am able to side load it in web excel but doesn't doesn't show same option to load xml file
Advice
1 vote
8 replies
237 views

I need to create an Excel macro to read a file. The file can be read in WordPad and contains configuration data and the tension measurements of a test to the breaking point. The test results will ...
Score of 2
3 answers
279 views

My data about contracts has the following columns: ContractID (unique, primary key) with the following fields unique for each contract: FiscalYear (calculated field from Contract End Date) ...
Score of 1
2 answers
140 views

I have an Excel workbook from which I sometimes need to copy a selection of sheets to a new file. To accomplish this, I have made the following macro in an example file: Sub Copy_to_new_workbook(...
Score of -3
1 answer
150 views

In an Excel conditional formatting criteria, the formula for finding a string that BEGINS with a certain string is $AJ1=LEFT($AJ1,14)="string to find" when searching in the AJ column, where &...
Score of -1
2 answers
110 views

I have the following conditional rules for color formatting rows in Excel: I want the color coding to be applied to each of columns 1 to 4 in the repeated sequence (not just 1 and 4). And I'm not ...
Score of 0
2 answers
210 views

I'm trying to integrate a variable into some VBA code. The code is pasted below. Essentially, what I am trying to do is take an exported data set and transferring the order to run, and a few other ...
Score of 0
2 answers
127 views

Running into a runtime error and I think it's because there's no stop to the loop in my MergeCells code. In my data, I have dates in column A that I would like to be merge and centered if the same ...
Score of 1
1 answer
151 views

I want to auto adjust the cell width to the text width. I also want to auto sort the text alphabetically in column A and sort the rest of the data in the other columns with it but I want to exclude ...
Score of -3
4 answers
224 views

We have this table: c2 d2 ---------------- 100 34 We need if d0 is equal to 0, then add 25% to c2 if d0 is not equal to 0, then if c2 < 500 then c2+40% if 500 < c2 < ...
Score of -1
1 answer
171 views

EDIT: To clarify, I need to stop this rightward shift. What causes it and how do I stop it from happening? I have a lot of pivot charts in each of 14 workbooks - all the same except for the entity (...
Score of 2
1 answer
210 views

I am running a VBA macro that processes a large dataset (around 500,000 rows and 30 columns). The data is read into a Variant array, processed in memory, and then written back to a new worksheet. The ...
user avatar
Advice
2 votes
3 replies
144 views

I have issue with adding formula to cell with formula contains variables and defined name. How to correct my code? Goal is to check if cell is not empty and backround color is green. Formula itself ...
Best practices
1 vote
1 replies
135 views

I've recent tried the formula"=cell+cell*percentage" I've recently been trying new ways to calculate the percentage on excel and can't seem to find the best way to get the fastest most ...
Score of 4
6 answers
276 views

Table 1 Part Number 11-May 18-May 25-May 1-Jun 8-Jun ~~15-Jun~~ PN1234 8 5 6 4 9 7 PN5678 3 5 1 6 2 ~~4~~ PN2468 1 3 4 3 8 5 Table 2 Part Number 11-May 18-May 25-May 1-Jun 8-Jun ~~15-Jun~~ PN1234 20-...
Score of 2
1 answer
183 views

Essentially I have table in Excel that I want to filter and then copy into a new sheet. I am trying to do it with .SpecialCells(xlCellsTypeVisible) but I am getting an error: 1004 Unable to get the ...
Score of 4
6 answers
256 views

Problem Trying to create a formula (or a VBA macro) that produces the array under Desired Array Output. For each field in row 3 that contains a FALSE I want it to return the related Loan ID that = ...
Advice
1 vote
11 replies
184 views

Trying to open an excel file using an external editor gives the error "The file is not displayed in the text editor because it is either binary or uses an unsupported text encoding". Can a ...
Score of 0
1 answer
96 views

I'm working on a folder tree restructuring for our team's file share. Before actually changing anything, I want to list the planned moves/renames/deletes etc. in Excel. For this, I want to have a ...
Score of 1
1 answer
209 views

I am writing a formula to allow a user to automatically select a dynamic range using Excel's HYPERLINK function, as follows: (LET statements broken line by line for clarity) =IFERROR( HYPERLINK( LET(...
Score of 0
1 answer
93 views

I'm using ExcelJS 4.4.0 + Node.js to export a sheet with images in cells. First open looks fine — each row has its image in column D. But once I turn on AutoFilter and hide some rows, things break: ...
Score of 1
0 answers
80 views

I have two workbooks, one contains my formulas/calculations, the other my data in multiple sheets. I am trying to do a vlookup where the lookup array comes from a cell with a concat formula. Example: =...
Score of 1
0 answers
86 views

I am trying to amend a formula so that one of the ranges dynamically changes based on a match. My starting formula is: =COUNTIFS($B$4:$BY$4,B$31,$B5:$BY5,">"&VLOOKUP(B$31,Allowance,2,...
Score of 1
0 answers
132 views

So far I have been using this VBA to extract data from Redshift - via ODBC Driver 1.0 - into my Excel-File Sub Query_Data_driver_1.0 () Dim conn As New ADODB.Connection Dim rs As New ADODB....
Score of 0
0 answers
192 views

I have been using this VBA to extract data from Redshift - via ODBC Driver v1.0 - into my Excel file: Sub Query_Data_driver_1.0 () Dim conn As New ADODB.Connection Dim rs As New ADODB....
Advice
0 votes
6 replies
197 views

at the moment I am using this code snippet to add "20" to the beginning of each cell in a table column: For Each r In Range(TabellNamn & "[Date/Time]") r.Value = "20&...
Best practices
0 votes
3 replies
113 views

I am Creating a logging app to track jobs. After entering a dozen aspects about a job on sheet1 it calculates the overhead and profit of job. There is a checkbox to acknowledge acceptance of the job. ...
Score of 0
3 answers
128 views

I’m trying to automatically check/uncheck Form Control checkboxes on a specific sheet based on a value change in a trigger cell (e.g., F19). The Logic: User changes the trigger cell. VBA searches ...
Best practices
0 votes
1 replies
93 views

Details I am using Excel Power Query for data profiling and data cleaning. My dataset cntains texts columns where missing values are represented in two different ways: null empty strings (" &...
Advice
0 votes
0 replies
82 views

Whenever I refresh my web-based Excel workbook, the Focus Cell setting automatically gets disabled and I have to enable it again manually. Please advise how to permanently keep the Focus Cell feature ...
Advice
0 votes
1 replies
68 views

I wrote code in Node.js ( version 10 ) for Excel. The Excel file has a URL column. When I click the link, it opens in the browser, but the browser opens behind the Excel tab, so the user doesn't know ...
Advice
1 vote
6 replies
165 views

I need to choose the best match between a target color, and a list of RGB values that are available to me. In order to give the user a visual impression of the remaining color difference, I want to ...
Tooling
0 votes
2 replies
97 views

would like to assign unique id numbers containing contents of other columns in an excel file. id number would contain text too. automatic id assignment everytime a new entry is typed in the excel ...
Best practices
0 votes
4 replies
126 views

I am exporting ~500,000 rows from MySQL into an XLSX file using batch processing. Current implementation: Fetch 10,000 rows per batch Write each batch sequentially into the XLSX file 3–4 table joins ...

1
2 3 4 5
…
5775