Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
1
vote
1 answer

VBA Loop thru different worksheet & table to format alignment, column width & etc

I've 4 different worksheet & different table. I trying to change the formatting using loop for all the worksheet but the range defined below is giving an error - Method 'Range' of object '_Global' failed. Data I have already in table form. Dim…
Jeroho One
  • 11
  • 1
1
vote
1 answer

Excel DROP function unexpected behaviour

When getting a formula solution for this question Insert row to separates group of data with header I tried dropping the first and last row from a spill result. This was the data used: column A column B column C row 1 pos item qty row…
P.b
  • 8,293
  • 2
  • 10
  • 25
1
vote
2 answers

How do you flag cells by comparing values in another column with the same 'ID' column?

I have a sample table like this: base I wanted to flag if there is an increase in Output of the same ID compared to the previous Date. Note that the data is only sorted by Date. Expected output: output I've been trying to find the correct formula…
babooshka
  • 13
  • 3
1
vote
1 answer

Multiply two ranges in Excel to get an array result

Excel 365 allows to multiply ranges to get an array as a result. Example: # A B C 1 1 0 1 2 0 1 1 Entering in A3 = A1:C1 * A2:C2 will evaluate to {1,0,1} * {0,1,1} and return an array {0,0,1} spilling in…
Yuri Ammosov
  • 15
  • 5
1
vote
0 answers

Same macro crashes in Excel 365 but works perfectly on Excel 2007

I got a macro that opens 2 workbooks and make some calculations. It works perfectly on Excel 2007 32 bit. But in Excel 365 64 bits it crashes right after opening the first workbook, with no messages errors. Excel quits directly with no…
Foxfire And Burns And Burns
  • 10,665
  • 2
  • 17
  • 38
1
vote
1 answer

I need to sum values from multiple instances of a lookup value in excel

Hi I'm sorry if another thread answers this but I've tried looking and couldn't find anything helpful. I'm putting together a library database which involves 2 main pages, one for the stock of the books (how many are owned by the library) and one…
Eboda12
  • 11
  • 2
1
vote
2 answers

Hide and Unhide a range of rows based on the value in a cell

Very Basic I am sure but I can't figure it out for the life of me. I have a set of radio buttons that changes the value of cell("L37") between 1 and 2. I have tried to write the VBA code several different ways without luck. Please advise. Sub…
Methodikal
  • 13
  • 3
1
vote
1 answer

How can I do step by step debugging, or even set break point in Excel 365 Office Scirpt code?

I have enabled Office Script, and I see AUTOMATE tab in my Excel-365. I can write a script and also see results in log and on sheet . But when I see the tab, or the script, I do NOT see any way to take step by step execution, or even set a…
Rahul Mehta
  • 31
  • 3
1
vote
1 answer

How to change color in a range of cells using an Axtive X control button?

I am attempting to use an Active X control button to change the background (fill) color of a range of cells when the button is clicked and then change it back to its original color when clicked again. The code I have returns errors. I am looking for…
DMatt d20Gamer
  • 73
  • 5
1
vote
1 answer

VLOOKUP - "A value is not available to the formula or function" error

I have a workbook with two sheets. On the "Likes" sheet, I have a list of URLs (and other things that are not relevant here). The second sheet, "Apr-4.13.22", has topic titles and their URLs. I want to pull the topic titles from "Apr-4.13.22" into…
AnnoyedEditor
  • 13
  • 4
1
vote
1 answer

Find certain code combinations using text (sub)string in Power Query

I had similar question (link below), but it just lets say "add-on" to my issue that I found on the way. Find all code combinations using text string in Power Query What I need is to extract exact matches (or I would say fuzzy matches in Power Query)…
MmVv
  • 553
  • 6
  • 22
1
vote
1 answer

Wrong Office version and Operating system in vba Excel

I am running this code in VBA Excel 365 using Windows 11 Sub test() Dim sBuild As String, sOP As String, sVersion As String sBuild = Application.Build sOP = Application.OperatingSystem sVersion = Application.Version MsgBox "Operating System " & sOP…
Manuel Pérez
  • 13
  • 2
1
vote
0 answers

Apache-poi protect sheet locks sheet from autofilter when using Excel O365, but not when using LibreOffice

The issue I am trying to create and populate an Excel sheet while locking specific columns and adding autofilter to the header rows. The application currently generates the Excel sheet with the correct values and when using LibreOffice autofilter…
Zaccie
  • 11
  • 5
1
vote
1 answer

How to summarize outcomes in a spreadsheet

I have a data set (a lot more columns involved than example) however, want to summarize outcomes on a separate sheet. Well, can’t use pivots as I have to drop data in from an external source prior to the desired outcome. Staff names will not be…
user18587694
1
vote
1 answer

Find all code combinations using text string in Power Query

What I need is to find all the code combinations from Codes (table 1) using text string (long text string in A2) and to get all the combinations like on the Results table (table 2). For instance, you have CE1 part of string, and it can happen that…
MmVv
  • 553
  • 6
  • 22
1 2 3
…
17 18