Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
0
votes
0 answers

Transforming data from one column to more

enter image description here I need to have this data in four different rows in Power Query. Can someone help me with this. Thanks.
Vera Katic
  • 3
  • 5
0
votes
0 answers

Retrieving unique list of data given that previous values is not the same in Excel 365/VBA

I want to, given a set dataset as shown (with generic names) below, either using VBA or excel functions, find each unique row in the table and putting them into another sheet. The issue comes when I have several items for the same value, but…
Andreas
  • 13
  • 2
0
votes
4 answers

Finding the closest 3 values with a criteria

I have a list of employees where the Name, Department and Years of Experience is stated Name Department Years of Experience John HR 5 Mary Finance 12 Tom HR 6 Dick Finance …
Edwin
  • 1
  • 1
0
votes
0 answers

Excel Formula returning Unexpected Results

Formula in question: =IF(AND(COUNTIF(Roster[Number],[@Number]),COUNTIF(Roster[Black List],"TRUE")),"TRUE","FALSE") The idea here is to check if any row is "black listed" on one table by comparing the "Number" columns on it and the Roster. The "Black…
Styles2304
  • 143
  • 1
  • 14
0
votes
1 answer

XLookup function won't detect an exact match until I place the cell in edit mode and then exit

I am using the XLookup function in Excel 365. I use a VBA script to create an ID number for a row of data and then I place that ID number into a cell. If I use the XLookup function with Exact Match to locate that ID number and give me some value in…
Blau
  • 331
  • 3
  • 12
0
votes
1 answer

Excel VBA 2016 / 365 Compatibility Issues?

I made a macro that others have been using the last 6 months with 0 unexpected errors until yesterday. This entire time the macro has been created, edited, and used with office 365. All OS have Windows 10. Yesterday someone tried using the macro…
deLa
  • 89
  • 7
0
votes
0 answers

Vlookup with multiple columns and rows

I am looking for a solution to allow the below VLOOKUP code to loop and return all results in a table meeting the criteria in D2.. I have found several pages that have parts or other use case solutions but not one that fits issue this directly. Any…
5_Stripes_Fan86
  • 11
  • 2
0
votes
3 answers

Excel : Search in column based on patterns/substrings

In my excel sheet (Excel-365), I have 3 columns i.e. Table_Name, Size_MB and Session_Num as shown below. I am trying to list out all those Table_Name (Column A) along with their Size_MB (Column B) in two separate columns where Table_Name consists of…
Aarie
  • 39
  • 7
0
votes
0 answers

Excel Dependent Drop Drown List from Another Workbook

I was wondering is it able to create a dependent drop down list in excel from another workbook. I was able to create the drop down list from another workbook. What I wanted now is that to create a dependent drop down list based on the previous drop…
EM.C
  • 1
  • 1
0
votes
1 answer

Insert dynamic array formula in Excel sheet with openpyxl

I'm using openpyxl to create worksheets that contain some custom Excel formulas. One of the custom Excel formulas returns an array, but I don't know the size of the array (i.e. number of rows or columns) ahead of time. Suppose this is the custom…
mlin
  • 1
0
votes
1 answer

VBA Workbooks stop working with upgrade to Excel 365 - VBA Compiling Issue?

Since upgrading to Excel 365, my company has been having all sorts of trouble with VBA-supported Excel workbooks crashing or not functioning properly. The issues have popped up in various workbooks and various departments, including seemingly simple…
James Howard
  • 21
  • 1
  • 3
0
votes
0 answers

Build on advanced filter without resetting the last advanced filter

I have gone down a rabbit hole with this and am probably going to be told I've gone about it the wrong way, but anyway: I have a set of buttons that I want users to be able to press to automatically filter the dataset. The buttons should filter each…
Boswell
  • 102
  • 2
  • 16
0
votes
1 answer

Reach to the end of the existing data and add multiple column headers

I am trying to add multiple columns at the end of the existing data set and add multiple columns. Below is the code that I have working right now:- Sub AddColumn() Range("A1").Select Selection.End(xlToRight).Select ActiveCell.Offset(0,…
E L
  • 1
  • 1
  • 5
0
votes
1 answer

SSRS Report Execution Service: export to xlsx without error

Hello thanks for looking. I have some .net code that uses the SSRS Report Execution Service to download a report for the user as an xlsx file. It works & everything in the report is present & accounted for. One annoying thing though. When opened in…
drzounds
  • 369
  • 3
  • 16
0
votes
1 answer

Excel Formula If cell contains specific text, otherwise math operation

In cell G3, I would like the following: If G2 equals Completed, then in G3 I would like it to say Completed, however if G2 is blank or has a date, I would like G3 to take the date in G2 and add 30 days.(G2+30)
IndyMom83
  • 153
  • 1
  • 1
  • 6
1 2 3
…
17 18