Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
0
votes
0 answers

Amend working formula to ignore blank cells and a designated characters ("-")

I have this formula which works well to combine column A and column B in a specific order: =SUBSTITUTE(FILTERXML(""&TEXTJOIN("'",,CHOOSE({1,2},IF(E2:E67="-","",E2:E67),G2:G67))&"","//s"),"'","") This is a variation on:…
Nick
  • 789
  • 5
  • 22
0
votes
1 answer

Ammending Equation so that columns A,B do not have to be adjacent to eachother

I have this formula below which sorts data In columns A and B as shown in the image. The formula is: =SUBSTITUTE(FILTERXML(""&TEXTJOIN("'",,A2:B60)&"","//s"),"'",""). The problem with this question however is that it requires…
Nick
  • 789
  • 5
  • 22
0
votes
1 answer

Microsoft Excel keeps repairing my .xlsm file for no apparent reason and eliminates data validations on a sheet

I recently created an automated Excel utility (using Microsoft Office 2019), in which I've extensively used data validations, VBA code, named ranges and formatting. It was working well until one day I received an Excel prompt message that…
Nik L
  • 39
  • 1
  • 7
0
votes
1 answer

Add-In tab not displayed after adding add-in in Excel 365

I have Excel 365 64 bit and I'm trying to add an old add-in. In previous versions of Excel when I added my Add-In (Duplicate Master V2 by brettdj) it would create a new tab labeled Add-In and there would appear the routine. I've tried adding on my…
Rick
  • 2,288
  • 18
  • 66
  • 98
0
votes
1 answer

How to: Auto populate an excel Table in another sheet (S2) from another sheet (S1 as unique table values)

I have let's say one excel table (formatted as a table) in one sheet that has date column (in Column A) with some unique dates but starting from row ten (A10). Other rows are empty (because of the structure of table and the columns on the…
MmVv
  • 553
  • 6
  • 22
0
votes
0 answers

Auto-Fill range of cells in excel from a list of names based on criteria

I have a table with a list of tasks that happen on three shifts, and a list of employees that will be assigned to these tasks. each employee can't be assigned to the same task twice in the same day and can't have two tasks in the same…
A.O.G
  • 35
  • 8
0
votes
0 answers

Excel: How to use if(countif) using multiple ranges to return multiple texts?

I am trying to build a formula under sheet1 columnM to provide a status for each cell in columnE in sheet1, if the cell in columnE is found in columnJ in sheet2 then return "analysis complete" if not found, if cell in columnE in sheet1 is found in…
jabv
  • 1
0
votes
1 answer

Excel 365 - Crash when Filtering ADODB.RecordSet via VBA

I have some Excel 2013 & Excel 2017 spreadsheets that make extensive use of VBA, downloading and processing data from Oracle. We have recently migrated to Office 365 (64 bit), so I am having to update these spreadsheets to work in the new…
ainwood
  • 992
  • 7
  • 17
0
votes
3 answers

Count how many matches in the same row across 3 columns

I hope someone can help, I am looking for a formula solution to the following problem if possible. I have a column of people's names, and for each of those people I have 3 columns of data from 3 different sources - I need to determine how many times…
TheEndUK
  • 33
  • 5
0
votes
0 answers

MS Graph API | Error on content convert from xlsx to pdf

I attempted an API call that converts the XLSX to PDF using the following endpoint GET /me/drive/items/{item-id}/content?format={format} Excel.xlsx Has 5 worksheets ['Sheet1', 'ワークシート', ',..&^&^(^(%^$%#$@@((&&)'] Sheet1 is blank ワークシート is filled…
sylvester_scitara
  • 1
  • 1
0
votes
1 answer

Call Office script from outside of MS Excel WebApp

In the Excel WebApp (Office 365) it is possible to place Office Scripts via the "Automate" tab, which is using the JavaScript-syntax and which could automate excel like a VBA-macro, but for the excel WebApp (Screenshot). (How) is it possible to…
Peter
  • 323
  • 4
  • 15
0
votes
0 answers

Error in conditional formatting formula where the same formula works in a cell

I'm trying to conditionally format a column of cells based on whether the combination of two other columns appear in a Table. Here is a link to the test workbook I am playing with and screenshots below for those that don't like clicking strangers…
Alan Schofield
  • 19,839
  • 3
  • 22
  • 35
0
votes
1 answer

Deactivate a range in Excel 365 VBA

When a range in EXCEL365 is Activated the cells turn grey. They remain grey when the subroutine is completed & exited. I assume that one wants to Deactivate the range before exiting the subroutine to have the cells turn white. This topic is not…
oldsilenus
  • 11
  • 2
0
votes
0 answers

Formulas and Formatting Not Applied to New Rows When Pasting Additional Rows of Data into Excel Table

When I paste new rows at the bottom of my Excel table, the table expands properly, but none of the column formulas or formatting apply to the new rows of data. I've tried paste special with values only, formula only, formatting only, etc. No matter…
SQL Nerd
  • 1
  • 1
0
votes
0 answers

Pivot Table project - Avoid using many INDEX and MATCH functions that make Excel crash

I need some help with an Excel Project that's giving me headaches. I succeeded to achieve everything I wanted but the result is too heavy for Excel and it crashes all the time. I'm over-using the INDEX and MATCH functions on large tables (50 000+…
Alexandre
  • 1
  • 1
1 2 3
…
17 18