3,685 questions
0
votes
0
answers
28
views
Excel Refresh using win32com
def excel_refresh_query_replace(path, query_list = [], old_str = '', replacement_str = '', index_update = False, max_bk_date = '', sub_list = []):
Application = Dispatch("Excel.Application&...
- 1
0
votes
1
answer
54
views
DAY function Returned Wrong Answer
I'm trying to find a correct formula for this. I want to find the date if we add the month by 4. The answer should be September 30, 2024, but why the output is October 01, 2024? what should I add to ...
0
votes
1
answer
54
views
Excel Data Extraction
I need help with Excel to display data based on drop-down selections. I have a table with "Name" and "Gender." How can I set it up so when I select "Male" or "Female&...
- 11
0
votes
1
answer
29
views
How to get missing "style "attribute related to columns, while reading XLSX template using OpenXml?
What is the objective?
Pump data into xlsx file from a data source("Data Table" for now).
What has been so far?
A new XLSX file was created. Columns were added and same columns were also ...
- 3
0
votes
0
answers
38
views
Copying Text from a textbox to a cell in excel through vba
The below is the code for copying the text from a textbox and paste its contents into a given cell while maintaining the proper formatting, but the thing is that it takes a lot of time to run.
I need ...
-1
votes
1
answer
76
views
How to find the row coordinate of a specific cell in excel using python
Language: Python (version 3.12)
Packages tried: OpenPyxl and
Pandas
Task: Within a workbook I'm trying to find an instance of a specific year (input) within a column called "Year". From ...
0
votes
2
answers
92
views
Hiding empty cells in Excel chart
I would like to set up a graphic that is fixed to a cell range. The values there change depending on the data input. If a cell is empty, the axis labelling is still displayed in the graphic. How can I ...
1
vote
3
answers
2k
views
How to get the first and last cell with values in a row for every row in a table in Excel?
So I wanted to solve a question, which was to compture YoY (Year over Year) growth rate for some specific conditions company, I was given this dataset above and I know the formula of YoY Growth rate. ...
0
votes
3
answers
84
views
want to decrease number of rows by putting size of same item into column to decrease sheet size
I have excel sheet of more than 1000 item name in which single item contain different sizes (which making sheet long) I want to separate sizes from name and want to put them on top row so that same ...
0
votes
1
answer
40
views
How to copy excel cell content to a string with vba
I want to save an Excel sheet as a file using vba code. That I have achieved.
Sheets("html").Select
Dim Path As String
Dim FileNumber As Integer
Dim k As Integer
...
0
votes
1
answer
52
views
Run-tim error 1004 when use WorksheetFunction.Transpose in VBA but works ok if use excel TRANSPOSE function
If I have the Seven Dwarfs names as strings in cells H1 to N1 and then select cells B1 to B7, then insert the formula
=TRANSPOSE(H1:N1)
and then Ctrl-Shift-Enter, then the Seven Dwarfs are inserted ...
- 9,678
0
votes
0
answers
43
views
Addressing problem after automatic table update
Friends, I have a file that when opened, connects to a site and the table in the first sheet is automatically updated (once a day).
In the columns after this table, I wrote formulas that perform ...
- 3
1
vote
3
answers
70
views
Find the Maximum and Minimum values from a range set by cells containg specific value by VBA Array function
I need to extract data from Input sheet to another sheet as shown below
Input sheet:
I have added the image of the source file from which i want to extract the data
And I have hidden someww columns ...
- 25
1
vote
3
answers
91
views
Trying to Find the Maximum and Minimum values from a range set by cells containg specific value
I need to extract data from Input sheet to another sheet as shown below
Input sheet:
ColumnF
ColumnV
2
120
2
100
2
130
2
150
-1
70
-1
200
-1
150
-1
60
To new sheet to extract from Input
...
- 25
1
vote
1
answer
85
views
Auto moving a copied row to the first row set that is empty
I have created an Excel document that has multiple sheets. The first sheet is where all the information is processed, and then I added a formula that transfers the row of information to another sheet ...
- 11
0
votes
0
answers
69
views
How to read Raw value rather then the formatted value from the excel sheet using POI library using XSSFReader class
They are using the XSSFReader to read the sheet:
XSSFReader.SheetIterator iterator = (XSSFReader.SheetIterator)xssfReader.getSheetsData();
And then they are using override method:
@Override
public ...
- 1
0
votes
0
answers
50
views
How to sort data in text format in Excel
I have data in Excel and my data contain below format:
Year | WeekNo
2024 | Week 1
2024 | Week 2
2024 | Week 3
.
.
.
2024 | Week 11
2024 | Week 12
2024 | Week 13
.
.
so on.
When I applied ...
0
votes
0
answers
187
views
Check excel file is protected (with and without password)
I need to open an excel, and if it doesn't open, I need to determine if it's because of any of these cases:
-- Excel is protected
-- Excel is password protected
-- Excel is corrupt.
I have to use a ...
- 2,441
0
votes
0
answers
29
views
How to exclude insecured download blocked warning in Edge
I am getting below warning in the Edge when ever I am downloading excel
How to fix this?
I am trying to download excel from the web application that is developed in .NET technologies
- 1
0
votes
0
answers
18
views
In Excel apply formula by vlookup from Sheet1 to Sheet2 in VBA
In my Excel (.xlsm) sheet1 B column empty Apply formula in G column by vlookup get data from sheet2. It shows error "Subscript Out Of Range"
Private Sub Worksheet_SelectionChange(ByVal ...
0
votes
1
answer
473
views
Is there a formula to Count Unique values with Criteria and between two dates
I need help to count all UNIQUE each Serial # of each Phase # between two dates.
Raw data changes every day. I know there is a way to formulate this but I can't do it.
I tried Cleaning the raw data ...
- 95
0
votes
0
answers
88
views
How to determine the count of Worksheet Tabs that is visible in the Sheet Tab on Excel?
In Excel, how can I determine which worksheet tabs are currently in view across the bottom of the window (Sheet Tab)? i'm looking for a object property to show if this sheet tab is in view or it is ...
- 13
0
votes
1
answer
78
views
Is there a formula to multiply two column only if both of them not null?
beginner here.
So I have to find a value with calculation like this: Sum of Column C * Sum of Column B / Sum of Column B. But the problem is both of Column B and C have to be not null. I use excel ...
- 3
0
votes
1
answer
72
views
How to change a cell value in worksheet change event in vba [duplicate]
Actually using the following code is impossible, because we are doing a change in Worksheet_Change
Private Sub Worksheet_Change(ByVal Target As Range) Target.Value = "test" End Sub
It will ...
1
vote
2
answers
210
views
Identifying number of sequential numbers in a set of data in Excel
I'm looking for a formula or set of formula to find how many numbers are found to be sequential.
See picture for example of what i'm looking for
Ive found the following formula that identifies what ...
- 37
1
vote
1
answer
56
views
Formula cell in excel shows #NAME?
I am attempting to add an excel formula to calculate Upgrade Effort based on certain conditions that will refer to other columns in the same excel sheet.
Below is my formula
=@IFERROR(@IFS(C3="...
- 79
0
votes
0
answers
21
views
Error Changing a range of cells withing the same row
I am currently trying to change a range of cells to add at the start and at the end, words from other cells within the same row for each of them.
I've made this code below but everytime I turn the ...
- 91
0
votes
1
answer
57
views
Python returns Excel formula rather than cell value or the cell value isn't changing
import openpyxl
# Path to the Excel file
file_path = r'D:\1 - DOWNLOADS\TEST1.xlsx'
# Load the workbook
workbook = openpyxl.load_workbook(file_path)
# Select the active sheet (assuming you want to ...
2
votes
2
answers
158
views
Count average value of every 6th column in one row via Excel VBA
How can I count average value of range that consists of every 6th column of my table?
In Excel this formula looks like "=AVG(I3, O3, U3...HE3)"
I tried the macro recorder but it was hard-...
- 23
0
votes
0
answers
130
views
How to combine two Excel =filter( ) functions
I need to filter a table twice.
First, I want to exclude rows if "Tour-Nr." equals to a specific value:
=FILTER(Data, ISERROR(MATCH(Data[Tour-Nr.], B3:B8, 0)) * ISERROR(MATCH(Data[Unt. Nr.], ...
- 33
-1
votes
1
answer
272
views
Apply color to Pie Chart slices in Excel
I want to create a pie chart in Excel with 33 pieces.
I want for each piece, depending on the value of the cell
green (No issue)
red (Need)
yellow (Opportunity)
For example,
Identifier # Results
...
- 1
1
vote
1
answer
112
views
Vba exclude 2 shapes from selection by name
I am trying to copy a range of cells which contains data and shapes, from sheet 1 to all other sheets in a workbook. However 2 shapes need to be excluded from the selection by name, other shapes need ...
- 193
-1
votes
1
answer
55
views
Data from Sheet one into Sheet two [closed]
In image, i have data in sheet 1 and want specific data in sheet 2
- 11
0
votes
1
answer
27
views
Tabs re_protection issue on Format columns & Format Rows, Auto filter
While reseting the password on current file using VBA, Once reprotected "Format columns & Format Rows, Auto filter" options are disabling. We not required these optons for all the files ...
- 1
0
votes
0
answers
35
views
pivot cache using vba getting run time error
I have created one script which is running perfectly fine in my laptop but while my colleague is trying with same script getting error with pivot cache
Set PCache = ActiveWorkbook.PivotCaches.Create(...
1
vote
2
answers
73
views
How can I identify pairs of identical values in an Excel column named ‘Current’ and return the corresponding values from the ‘No. Feeders’ column?
No. Feeders
No of WTG
WTG Power (MW)
Current
F4
11
2.3 MW
470.43 A
F5
6
2.3 MW
256.6 A
F6
6
2.3 MW
256.6 A
F7
11
2.3 MW
470.43 A
F8
3
2.3 MW
128.3 A
F9
7
2.3 MW
299.37 A
F10
6
2.3 MW
256.6 A
...
- 575
0
votes
0
answers
149
views
I Want to Find Daily Calculation interest in Excel Sheet Based on Some Requirement
I need to find Daily Calculating interest
Interest As 1 %
1 jan Closing Bal as -100. No Need to Calculate interest For Jan 1
For Next 2 days have No transaction. So No Need to Calculate Interest For ...
- 42
-4
votes
1
answer
102
views
Automatically smooth line after slicer in excel [closed]
I need help in fixing the line graph to a smoothed line. It keeps on getting crooked after clicking/selecting a slicer.
I am trying to avoid VBA as it needs to be activated for it to be smoothed again ...
- 95
0
votes
1
answer
57
views
Locking the Textbox Position To Be the Same While Update
I am creating a calendar feature in Excel that takes inputs from a form and based on that I will put the job details into the dynamic calendar. The problem I'm facing now is that whenever I'm updating ...
0
votes
1
answer
51
views
Excel 2007 formula to extract 90-90 character sentences from a paragraph [duplicate]
Posting this question again as I could still not find the proper solution.
Paragraph in cell A1:
Buy a Arlen Ness Big Sucker Stage 1 Air Kit with Beveled Cover for 17-Up HD Touring Softail and get ...
0
votes
2
answers
50
views
How can I find word in Excel and delete the digit Before?
I would like to split the word. If i found ACC, The word before ACC is delete in vba code
I found this code but it will delete the word after the found text
Set myRange = ActiveDocument.Content
...
- 13
-1
votes
1
answer
75
views
Extract Excel items in time range to consecutive time
Here’s a simple table with items in a time range. The desired result table has all items mapped to their consecutive time slots. What formula would you suggest accomplishing this task? Thanks!
...
- 1
0
votes
1
answer
180
views
How to export a column data in excel to a text file using a vba code?
I want to export the data contained in column H in an excel file using a vba code. I managed to get the code, but i want to modify it to allow me to choose the name and the directory to save it before ...
- 87
0
votes
2
answers
72
views
How can I Separate Data from one column to Multicolumn?
I would like to Separate this below.
to this format
I can separate account first.
I would like the optimize way to run the VBA.
Thank you.
- 13
0
votes
2
answers
136
views
How to find first instance in a column in excel and then reset it
I am trying to find the first instance where the value is >=65 in a column. The first flagged value can re-occur in the list and should be flagged again. Please see image for desired output.... I ...
- 55
0
votes
1
answer
846
views
Change source using VBA in excel for multiple links
I’m new to VBA and have been tasked with creating a macro for my team to update multiple (26) external links in a single workbook. I would like to have a table of the new links and old links. The ...
- 23
1
vote
2
answers
60
views
EXCEL: Search for a value in a range and return its adjacent value in a particular column
this is my sample data
1 0 11 12 A
2 9 13 14 B
3 8 15 16 C
4 7 17 20 D
5 6 18 19 E
I need a excel formula which returns B when i input 14 or 13 or 9 or 2 similarly it ...
1
vote
1
answer
180
views
How to Index excluding the header and footer
Is there a way to disregard the header and footer of an indexed data?
I need to dynamically get only the dates only that will be used on another dynamic formula.
My code is not working as $L$2:$L$4 ...
- 95
0
votes
3
answers
861
views
PHPSpreadsheet IOFactory writer not saving file to be downloaded to client
I have recently installed PhpSpreadsheet using composer, I am using php 7.4.
I am trying to open an excel file, change some of the cell values and then save the file (download to client) with these ...
- 11
1
vote
2
answers
347
views
Count the unique Values that met the Criterias (without using Pivot and Unique() function)
I need help in counting the unique Type of the table if they showed twice on the record with Code 1 function that doesn't use Pivot or Unique() formula.
As you can see on the screenshot below, I used ...
- 95