Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
0
votes
1 answer

Getting subtraction wrong in excel

This is absurdly simple but I am not getting what I am doing wrong, please help me out. My formula is very simple:=V40 - SUM(O40:P40,R40:S40) The values of V40 is 107, O40 is 80, P40 is 0, R40 is 1, S40 is 0 Ideally the result should be 107 - 81 =…
Allwyn P
  • 33
  • 1
  • 9
0
votes
1 answer

Merge two tables with some different headers in Excel formulas

I have a table in sheet a, that I want to merge with sheet b, and output on sheet c. Most of the column titles are the same but there are a few that are unique to a and to b. I want my output table to have every possible column title so that it can…
Aden
  • 1
0
votes
0 answers

Excel - VBA code works only for a few tries

I created this code in VBA so that every time I delete a number or the cell is empty(D7:O36), this code will run automatically(on selection change). The code runs fine if a certain small amount of cells(~100) gets empty at once, then the cells will…
Guilherme_Torq
  • 7
  • 4
0
votes
1 answer

DateValue is leaving some dates as strings

Using Office 365 - but some users access files via older versions. Standard and system date format is DD/MM/YYYY. Original data also formatted to look this way. I have a range of cells that appear as dates, but some are formatted as text. The data…
NelliNoodle
  • 158
  • 1
  • 9
0
votes
1 answer

VBA Copy Sheets From external Workbook and overwrite them on existing sheets with new values (including format, calculations and so on..)

I had similar question, that I posted over 1y ago, and it was basically solved but... Here is the link for more infos: VBA CopySheetsFromClosedWorkbook but overwrite (update) existing sheets with new values Recently I bumped on some issue where I am…
MmVv
  • 553
  • 6
  • 22
0
votes
1 answer

Power Query: Expression.Error: There weren't enough elements in the enumeration to complete the operation. (LIST)

What I am trying to achieve is to obtain "matches/pairs" from two tables. One (source 1)is data table with Date/Time and Pressure value columns and the other (source 2) is like Date/Time and Info value Columns. Second table has so called "pairs" ,…
MmVv
  • 553
  • 6
  • 22
0
votes
1 answer

Excel 365 Getting a Drop down with right Parent for Child

I have a family tree with 4 generations. I have put them into named groups of Parent and Child, for a child in 1st generation becomes a Parent in 2nd generation and so forth. I can easily, pending some rules, decide what Parent resides in 1st…
UserSpecialMinds
  • 1
  • 1
0
votes
1 answer

Error while connecting Excel with Oracle DB

I am trying to connect Excel will Oracle DB. I have already installed the Oracle client in my system (version: Oracle 11.2.0.3.0_64-bit). The process which I am following is: Then I got below message. Then I clicked "OK" Then I entered the server…
sudipto
  • 1
  • 1
  • 1
0
votes
0 answers

Margin error or Gutter error while multiple page Printing in excel

Problem : Margins are appearing when I print excel sheets when individual margin value is 0 Tools: Excel 365 Panasonic DP-MB5445SX Problem in detail: I have 4 sheets to print, each sheet will fit an a4 size paper fully, I have given individual…
Allwyn P
  • 33
  • 1
  • 9
0
votes
0 answers

IF statement: TRUE/ FALSE when a condition is met/unmet when referring to cells on another Excel sheet AND a specific entry in a second column

I have a sheet in my workbook called Students_Record. On that sheet, I am entering a formula that refers to columns of cells (StudentNumber and LessonType) from another sheet called Class_Record. I want it it to look through the ClassType column for…
Hayley Jonasson
  • 3
  • 2
0
votes
0 answers

Finding MAX value in another Excel sheet for values in one column if there is a specific value in a different column

I have a sheet in my workbook called Students_Record. On that sheet, I am entering a formula that refers to columns of cells (ClassDate and StudentNumber) from another sheet called Class_Record. I want it to look through the data in these two…
Hayley Jonasson
  • 3
  • 2
0
votes
1 answer

Copy&paste range into a sheet with values in it

I've been working on a VBA macro that copies values from two sheets into another one. I create a temporal sheet where I paste the values from one sheet and work with them cause where I have to paste them have more or fewer columns and I can't mess…
Daniela Paz
  • 33
  • 8
0
votes
1 answer

Allow "Mouse Click" event or "switch Excel tab" when a macro is running

I have a macro that extracts data from Microfocus RUMBA Mainframe Display and puts in Excel rows one after the other. I have created a Global Mainframe object and that is used for extraction to Excel. But when the process is running and if user…
Samantha
  • 3
  • 1
0
votes
1 answer

Excel formula that checks adjacent cell and if certain text, it uses the value of a 3rd cell, otherwise it returns N/A

In my spreadsheet, I have 4 columns: A - Location B - Report Date C - Status D- Review I need a formula to enter into cell D3. If C3 equals "Not Completed", it will take the value of cell B3 (report date). If cell C3 equals "Completed", I want D3…
IndyMom83
  • 153
  • 1
  • 1
  • 6
0
votes
0 answers

Excel drop-down list data and values

I have a large Excel(Office 365) spreadsheet that uses drop down controls so the user can easily populate the cell with set values. When you click on the cell the user can pick a value from the drop down. The drop down data is defined in another…
SkyeBoniwell
  • 6,345
  • 12
  • 81
  • 185
1 2 3
…
17 18