Questions tagged [excel-2021]
16 questions
3
votes
2 answers
How do I get the longest text of a row in some column in the middle of an Excel file? Formulas or VBA are okay
I have an excel file in the column somewhere in the middle of which (yellow selected row for example) I need to find the longest text of that row, and do that for each row in that column.
I obviously get a circle reference if I simply select the…

Shinico
- 35
- 4
2
votes
1 answer
EXCEL Pivot Table not showing all the months
I was trying to make a Pivot Table and I cannot understand what could be wrong. I want to display all the months in the Row Labels but it only displays the month of January. (I'm using Excel 2021.)
Link to the dataset: link to dataset
Here you can…

ArmoredKitty
- 23
- 3
2
votes
3 answers
I am looking for a formula that counts the number of rows between cells with a number 1 in
I have the following table:
I have the following formula in column B4
=IF(A4="","",MATCH(TRUE,INDEX(ISNUMBER(A5:A1872),,),0))
The formula is counting the number of blank rows between the number 1 in column A.
The formula i want though is one that…

Ingram
- 654
- 2
- 7
- 29
2
votes
0 answers
VBA editor in excel is inaccessible
I am unable to do anything in VBA editor in office, it just shows few big letters and nothing else, it´s impossible to reach settings or anything else, also it´s in french, don´t know why.
I already reinstall whole Office, but nothing has changed.…

Pal.Moonie
- 71
- 1
1
vote
2 answers
Worksheet_change working, but won't call a sub routine
I've been searching for an answer but nothing fits my problem. I have Sheet 1 where I've created a private sub ("disable1") to enable or disable a checkbox based on the value of a cell. I then created a Worksheet_Change in Sheet 1 ("Entry Sheet")…

Becket9
- 25
- 4
1
vote
2 answers
Can a page break be added based on where there is already an automatic page break?
Ok. I have a sheet that fills certain cells based on answers to questions on another sheet. Some cells end up empty. At the end, I have a sub that hides all the blank rows to prep the document for printing. The first page needs a larger top margin…

Becket9
- 25
- 4
1
vote
3 answers
Array formula with if conditions and substraction
I am searching for a formula solution that would summarize hours based on two conditions (date - column a, activity - column b). More precise, I want to summarize hours of sleep each day with array formula that would include whole column range.
The…

Igor K
- 37
- 6
0
votes
0 answers
How to apply my formula for visible cells only?
=SORT(UNIQUE(FILTERXML("" & SUBSTITUTE(TEXTJOIN(",",TRUE,A2:B6),",","") & " ","//s")))
This formula is for combining multi columns in one column.
I need to apply above formula for visible cells only. "a" is filtered in "A"…
0
votes
1 answer
How can I split the words in a range to a column?
I want the data of the range A2:A6 to be placed inside the column C with the following conditions: non-duplicate, non-empty and sorted.
I have Microsoft Excel 2021.
please help me.
Screenshot01
Thank you very much.
I want the split data from a range…
0
votes
0 answers
Embed/Host Excel into WPF application
I am trying to embed an excel workbook into WPF application. I have used the Microsoft.Office.Interop.Excel for achieving this, It works and opens the excel workbook in WPF application.
Problem: When I try to run the macros in VBA the workbook gives…

Ganpat Gutte
- 1
- 1
0
votes
1 answer
How can I hide different sets of ActiveX checkboxes in Excel based on two variables?
I'm really new at VBA, so I apologize. Hopefully I can describe well enough. I recently changed a section of my spreadsheet from an area I can completely white out with conditional formatting to an area that is text (which I can white out), but…

Becket9
- 25
- 4
0
votes
0 answers
Upload Excel Data to Google Sheets automatically
Does anybody know how to upload Excel data automatically to my Google Sheets document by hitting a button (underlying VBA code within a Macro) and GoogleSheetsAPI?
I have everything like ClientID, Secret, SheetID but can't upload anything as I…

Rafael
- 1
- 1
0
votes
1 answer
EXCEL-Function to find how many people does the oldest female live with
I have the following data collected:
persnum: Person number within the household
Age:age of the person,
htval: height of the person
I have highlighted them in the screenshot.
I am looking for a formula that tells how many people does the tallest…

andrea65
- 67
- 8
-1
votes
2 answers
Find value with the biggest age difference
I have a spreadsheet containing data from hospital patients. I'm running Excel 2021.
I need to create a function (or a macro) that tells me how many people live in the household that has the biggest age difference between the oldest and the youngest…

andrea65
- 67
- 8
-3
votes
1 answer
The sum of values whose second column is 1
I have two columns in Excel!
The first column of prices
And the second column of the status, whose values are 1 and 0!
I want to the sum of the prices whose status is 1!
How do I do this?
Columns A1:A5 are for prices |||| Columns B1:B5 are for…

AmooReza
- 9
- 7