Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
3
votes
2 answers

Fetch error on Office Script (Excel on web)

I am trying to call an external API from an Excel on web. However, I am stuck on trying to get the result from the fetch call. I am even using the Office doc example to make sure From an Excel, click on Automate to create a new script async function…
Miguel Guardo
  • 853
  • 1
  • 9
  • 17
3
votes
1 answer

`_xlfn`-prefix issue with current worksheet functions in MS 365?

I'm using the new dynamic MS 365 worksheet functions, such as e.g. FILTER, CONCAT and TEXTJOIN (together with a spill range reference indicated by the "#" suffix) These worksheet functions work and don't show any apparent error. I know that in MS…
T.M.
  • 9,436
  • 3
  • 33
  • 57
2
votes
3 answers

What formulas to use to check if 2 columns in Excel contain the same values not in same order?

So I want to be able to check if 2 columns have the same values, even if they're not necessarily in the same order. In the screenshot above for example, I want a formula that will return TRUE when checking if Col1 and Col5 have the same values, or…
Minh Nguyen
  • 23
  • 2
2
votes
2 answers

Excel: Dividing a column into a table with multiple criteria

I have some barcode scanner which lists out the codes on a column in Excel. The goal is to divide the original column into a table as per the test cases below. Does anyone have an idea in how to achieve it? Table…
Γουλιέλμος
  • 403
  • 1
  • 10
2
votes
1 answer

I am looking to filter data based on multiple conditions across different column

Let's say I have this fictional table. This table shows me a fictional list of customers and the various claim type for the services they have decided to have, which outlet they went to, if they are a mammal or bird. Outlet Name Claim…
ProperDataSet
  • 31
  • 7
2
votes
0 answers

Adding a LAMBDA formula forces other users to reopen spreadsheet

Issue: As the title says, any time a LAMBDA formula is used in my spreadsheet it forces all other users who have the shared spreadsheet open to reopen the spreadsheet. With my brain's limited capacity, I am struggling to find anyone else struggling…
jeranon
  • 433
  • 2
  • 14
2
votes
1 answer

How to split a search string into parts, then check parts against a database

Here's what I'm dealing with: We have a database of machines and their part lists are specified using strings. For example, one machine might be specified with the string &XXX&YYY-ZZZ, meaning the machine contains parts XXX and YYY and not ZZZ. We…
David Killy
  • 21
  • 1
2
votes
1 answer

Editing Excel 365 by hand and reading with graph api latency

I have an excel on line documents that can be edited by users in the Excel 365 web application. I have an application that read this excel file with the graph api. I have successfully managed to read the data from the file but when a user change the…
JuChom
  • 5,717
  • 5
  • 45
  • 78
2
votes
2 answers

Excel - How to split semi-colon separated values in multiple columns into rows

I have a table in Excel with following format Col1 Col2 Col3 Col4 alpha A;B;C;D 1;2;3;4 a;b;c;d beta E;F 0;5 x;y How do I split each corresponding values in columns to…
Rock
  • 95
  • 1
  • 1
  • 9
2
votes
1 answer

Change excel's default cursor

For years and years, my default excel cursor was always the arrow pointer/clicker. All of a sudden it seems to be a big fat gross plus sign and I hate every second I have to look at it. I know there is a VB macro I can write that will call the…
Adam
  • 43
  • 3
2
votes
1 answer

Two color conditional formatting centered around a number in excel 365

I am trying to set up a two color conditional scale where the highest is green, the lowest is red, and where it flips from green at a reference cell. So for example. Target Ex1 Ex2 Ex3 Ex4 Ex5 .5 .4 .2 .6 .1 .9 I would like Ex 1 to be…
tolle1038
  • 21
  • 2
2
votes
2 answers

One color change code for all ToggleButtons in a Userforms' Multipage

I have around 100 ToggleButtons. I would like: If .value = true then togglebuttons.BackColor = vbRed Else = vbGreen I can write the code for every one, but is there a way to create a group or class so that color change code would be…
David Komonyi
  • 23
  • 5
2
votes
1 answer

VBA COUNTIFs formula to refer to a dynamic range in another sheet

I am trying to incorporate a COUNTIFS formula into a worksheet via VBA - the formula I have works fine but it is not dynamic and with my rather limited VBA skills I've hit a bit of a brick wall. To explain, the COUNTIFS look at 19 different headings…
TheEndUK
  • 33
  • 5
2
votes
1 answer

How to select a part of a range, which is output of a formula

I seem to be really bad at writing readable titles :-) Here's the situation: I have a list of names and values, and I would like to calculate the sum of the values, corresponding to every name: Name Value a 1 b 2 a 3 c …
Dominique
  • 16,450
  • 15
  • 56
  • 112
2
votes
1 answer

How are boolean values treated in Excel?

I decided to learn how to work with the function SumProduct(), so I created this very basic Excel sheet: A B 1 1 2 2 I calculated =SumProduct(A2:A3,B2:B3) and the result was 5, which was as expected. Then I got the idea to replace B2 by…
Dominique
  • 16,450
  • 15
  • 56
  • 112
1
2
3
…
17 18