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…
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…
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…
-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
1
2