Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
0
votes
1 answer

How to replace TEXTJOIN() in Excel for older versions?

I have an Excel sheet that works well where I use TEXTJOIN() which is only available in the latest Excel versions. Is there an easy way to transform it to use existing functions of older Excel versions? My code looks like this: TEXTJOIN(",…
maxmitz
  • 258
  • 1
  • 4
  • 17
0
votes
1 answer

Excel: get subarray from column with multiple criteria

I'm sorry I'm new to Excel, so I'm asking questions that I could probably Google if I new enough terminology to come up with a good search phrase. Here's a simplification of my problem: Using this table, I need to get the UIDs (and then the…
Bob
  • 369
  • 1
  • 4
  • 24
0
votes
0 answers

Excel IF Formula with different result if blank or non blank

Column B - Date of Birth Column P - Date AR Completed Column Q - AR Due Date For the cells in Column P - The AR Due date is 15 years from the date of birth (the cells from Column B). I was using this formula for cell…
IndyMom83
  • 153
  • 1
  • 1
  • 6
0
votes
3 answers

How to optimize VLOOKUP formula with two searching criteria for more efficient calculation?

I have a long table with three columns, looking like this: +-----+-------+-------+ | URL | Label | Value | +-----+-------+-------+ | u1 | l3 | v1 | +-----+-------+-------+ | u3 | l4 | v3 | +-----+-------+-------+ | u2 | l2 | v2 …
Evgeniy
  • 2,337
  • 2
  • 28
  • 68
0
votes
1 answer

Not able to define Averageifs condition using isnumber search

I am trying to find a formula which can help me find the average of the results for the 4 criteria's used with ID; Company Name; Code & Activity by using isnumber search options: Example: Table with the details coming from the report extracted and…
suresh7860
  • 91
  • 9
0
votes
1 answer

How to get sum of each row of a dynamic array?

I have a 2D dynamic array of 0s and 1s (e.g. B1#). I want to calculate the number of 1s in each row. This can be done using SUM of each row or COUNTIFS on each row. My goal is to have a single dynamic array formula which would sum/countifs each row…
dsauce
  • 592
  • 2
  • 14
  • 36
0
votes
1 answer

How to combine two dynamic arrays to make one dynamic array in a formula?

I have two columns both with results of individual unique functions, i.e. both columns contain unrelated dynamic arrays. Is there a way I can combine both these dynamic arrays as a single dynamic 2D array and use in a formula? Example: Cell A1 =…
dsauce
  • 592
  • 2
  • 14
  • 36
0
votes
2 answers

How to auto fill periodic content in Excel that is not counting up like the rows

Let’s assume I have eight excel cells (A1:A8) with the following content: =MID(B1,1,2) =MID(B1,3,2) =MID(B1,5,2) =MID(B1,7,2) =MID(B1,9,2) =MID(B1,11,2) =MID(B1,13,2) =MID(B1,15,2) Now I mark it and drag it down to the next eight cells. I would…
switches
  • 25
  • 4
0
votes
1 answer

VBA to Open a Hyperlink based on Specific Text in another cell

I am trying to create a VBA to look in cell E for Monday, and then open the Hyperlink that is in the cell next to it in D. I have tried the below But it is not working. Nothing is happening when I run it. The files are on my network that the…
mlott
  • 1
  • 1
0
votes
2 answers

VBA Crashes on first line Set Var = Workbooks("name").Worksheets("name")

Below is a simple code to check for changes between 2 workbooks. 1 is a master workbook the other is a list of changes sent to me. I literally have both opened and I have ensured they are opened within the same instance. Code is stored within my…
MartyMcfly0033
  • 168
  • 11
0
votes
2 answers

Interface error on Office Script (Excel on Web)

I am trying to call an external API (https://api.fortnox.se/3/customers/2) from an Excel on web. The Web API I am calling returns a jason data structure such as the "Response" under "Retrieve a customer" session here:…
Max
  • 1
  • 1
0
votes
2 answers

Sum values based on date compared to current date

I am currently trying to create an if statement that sums values based on whether a date has passed. Excel example image M1 to M12 dictate the months of the year e.g. 01/01/2021 for M1 and 01/12/2021 for M12 Now I want to create or use a formula…
VHes
  • 15
  • 5
0
votes
0 answers

Change matrix table with varying headers and rows into summary table

I'm trying to change a matrix table into a more straightforward database to allow multiple workbooks to be consolidated. I have seen a few potential options for this on here, but none seem to quite match what I want, and I can't convert to a Table…
user2846818
  • 1
  • 2
0
votes
1 answer

Excel vba code to save as pdf no longer works in excel 365 (windows 10)

Excel VBA code that worked previously on windows 7 (Excel 2013) no longer works on windows 10 (excel 365). Now a run time error is generated. Run-time error '-2147024773 (8007007b)' Document not saved The debugger highlights the 4 rows beginning…
TommyO
  • 37
  • 6
0
votes
1 answer

Function to search array and return boolean value excel

How can I search an array of safety values and return a boolean value/message if a values in this array are greater than a given safety value? So far I just used a simple IF statement: =IF(H10:J12>K10,"Safety concern identified","No Safety concern…
Nick
  • 789
  • 5
  • 22
1 2 3
…
17 18