Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
9
votes
0 answers

Why does a plus sign in front of a defined name affects the results of enclosing function?

First let me introduce an example: I have a table of raw scores for players each day, it's call "Raw Score". I also have this table of modifiers that I will apply to each players' daily raw score, it's called "ScoreMod". I also have this table…
toaruScar
  • 401
  • 4
  • 6
9
votes
3 answers

Which random number generator does Excel VBA use?

Question in the title - I was looking to establish which random number generator VBA uses i.e., in Randomize and Rnd? According to Microsoft's documentation Excel itself uses Mersenne Twister - which is apparently very good, but you can't seed. I…
NWhittle
  • 131
  • 5
6
votes
1 answer

Why do VBA and Excel disagree on whether two cells are equal?

I am trying to compare two cells in a table: The column "MR" is calculated using the formula =ABS([@Value]-A1) to determine the moving range of the column "Value". The values in the "Value" column are not rounded. The highlighted cells in the "MR"…
Joku
  • 132
  • 8
6
votes
3 answers

Changing a CheckBox's Font Attribute "Strikethrough" from a specific module does not work

Using VBA (Excel 365 (16.0.12527.20880), German) I'm trying to set the strikethrough property of a checkbox (Checkbox1) caption to False in accordance to the Office VBA reference this should work. The following code is placed in a Module1…
Albin
  • 1,000
  • 1
  • 11
  • 33
5
votes
5 answers

Calculating sub totals within a Dynamic array/Range

I have the data below in which column A contains a formula to pull the below data from another sheet, such that if the original sheet is modified, the values are updated. For each group of metals I wish to create a sub total of the values as…
Nick
  • 789
  • 5
  • 22
4
votes
4 answers

How to make lambda function working on excel365?

I'm using excel 365, Can someone please explain why this function is not working as expected? I don't know what is the reason behind? Below is a screenshot of an excel simulation in Google Sheets, which produces the expected result:
Yen Dang
  • 268
  • 2
  • 9
4
votes
4 answers

Detect if Dynamic Arrays is enabled in Excel version with VBA

I am attempting to implement what Microsoft is calling out as a best practice, but with no avail. This is due to the newly support Dynamic Arrays that is now supported within excel. This is their article and below is the specific section. HERE Best…
Ben
  • 251
  • 1
  • 8
  • 23
4
votes
2 answers

Excel 365 VBA for hours and minutes format

I'm working on a simple Excel file with some worksheets where in every one I've report hours and minutes of work. I want to show it like 313:32 that is 313 hours and 32 minutes, to do that I'm using a custom format [h]:mm To facilitate the workers…
Jorman Franzini
  • 329
  • 1
  • 3
  • 17
3
votes
1 answer

Using office 365, how can I replace diacritics with 'normal' letters with an efficient formula?

I want to turn letters with diacritics into plain letters, so - áàȧäǎāãåąⱥấầắằǡǻǟẫẵảȁȃẩẳạḁậặăâ =a ḃƀɓḅḇ =b ćċĉčçȼḉƈɔ =c ḋďḑđɗḍḓḏðɖ =d I'm using office 365, but need to achieve this without addins or VBA, using a formula. A lambda function is…
Ne Mo
  • 198
  • 4
  • 18
3
votes
2 answers

Transposing all lines of data on multiple sheets into final sheet

I am trying to transpose 5 sheets of data (27 rows and 96 cols for each sheet) to a final sheet, with all accumulated data. Problem 1: My macro stops at column 27 on the first sheet. Nothing I change will make it run more of the data, even on a…
user21761326
  • 31
  • 2
3
votes
1 answer

How To Create A Unique List From Multiple Sheets Using Excel Formula

I am working on a payroll sheet, and I need to extract Unique Employee ID from multiple sheets in the workbook and place them in the same workbook in another sheet. Although I am able to create a formula, to get those Unique List however I am not…
Mayukh Bhattacharya
  • 12,541
  • 5
  • 21
  • 32
3
votes
1 answer

How To Extract The CAPITAL WORDS or BLOCK LETTER WORDS From A String In Excel

How to extract the capitalized full words from a string in excel ? Refer the first Image, I have used the following formula to extract the CAPITAL / BLOCK LETTER WORDS From a string in a cell, it works perfectly, • Formula used in cell…
Mayukh Bhattacharya
  • 12,541
  • 5
  • 21
  • 32
3
votes
1 answer

Q: How can I split data into multiple workbooks/files based on column in Excel?

I'm very new to VBA so I hope I don't sound too ignorant. Each month I receive a report that contains data in the ranges A:T and about 7000-10000 rows. I need to separate this data into multiple workbooks/files so that I can send them…
waddee
  • 33
  • 1
  • 6
3
votes
2 answers

What about "Application" as default object in Excel VBA?

I have just written this easy macro in Excel VBA for merging a group of selected cells: Sub Macro_Merge() Dim Temp As String Dim S As Variant Temp = "" For Each S In Selection If Temp = "" Then Temp = CStr(S.Value) Else: Temp = Temp +…
Dominique
  • 16,450
  • 15
  • 56
  • 112
3
votes
3 answers

Excel Dynamic Array formula to create a running product of a column

I need to create a running product from a column of numbers (I could use a row, but a column is easier to demonstrate here.) The input might be any arbitrary array. In fact, in the application where I would deploy this, it will not be a range, but…
mark fitzpatrick
  • 3,162
  • 2
  • 11
  • 23
1
2 3
…
17 18