# Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

19,105
questions

**0**

votes

**0**answers

16 views

### How can I use the built-in VBA editor on a high resolution screen

As you can see in the below screenshot, intellisense often doesn't leave enough room for the full description on enum members (and in some other places).
But I think Dim... seems fine
I don't seem ...

**0**

votes

**1**answer

18 views

### Pandas not Working after updating Excel with MS Azure

I want to use my Python program for reading/manipulating excel files. All worked fine so far, until I got a new Laptop which is win10 with MS Office 365 including MS Azure Information Protection. Now ...

**0**

votes

**0**answers

41 views

### What's the Excel equivalent of Stata's collapse(sum) command?

In Stata, I'd type collapse(sum) x, by(y z)
(where x,y,z = variable names).
What should I type in Excel to get the same result?
Edit: for those unfamiliar with Stata, this will "collapse" the ...

**1**

vote

**2**answers

23 views

### INDEX Issue when Adding Rows

I have an issue when using INDEX. The INDEX function works fine if I delete a row from the targeted sheet using:
INDEX(MissionList!$B$3:$B$36,1,1)
The problem is that if I add row(s) to the top of ...

**0**

votes

**0**answers

16 views

### VBA check the first colomn available

My excel sheet is used to clock the time at work. The code I made checks the colomns from "L" to "AE" at today's row. Which makes a lot ot duplicated lines.
I was wondering if we could simplify the ...

**0**

votes

**1**answer

13 views

### Excel Link To Images

I am importing my stock items onto an online selling platform, but on the excel spreadsheet I need to put a link to the image location.
I have uploaded images to my website, what is
https://...

**0**

votes

**1**answer

7 views

### drag formula across active columns that has been summed on last row +1

id like help with the below
my code is going to the end of a column, then in the row below is summing the data within the column. I want to drag that formula across the remaining active columns. ...

**0**

votes

**0**answers

17 views

### MS Excel 2010 Tagalong Buttons

I'm unable to get this code to work.
If Target.Column = 6 Then
ActiveSheet.Shapes("Picture 1").Visible = True
ActiveSheet.Shapes("Picture 2").Visible = True
With ...

**0**

votes

**0**answers

37 views

### Excel - Multiple Formulas

I am trying to do a spreadsheet collating multiple financial data.
I have used the formula below in cell C18.
Cell U116 is a drop down list for each month of the year.
Cells I117 to T117 are the ...

**0**

votes

**0**answers

9 views

### XNPV formula not working

I need to calculate XNPV, and I want to select whole rows with data, because now I have observation with 60 months deal, and for month e.g. I will have 90 months deal, so I should only update columns ...

**0**

votes

**0**answers

46 views

### Dragging and dropping cells in Excel causes unwanted shading to be applied

When I drag and drop cells, shading sometimes gets applied to the original location of the moved cells.
It's always some shade of grey but the exact shade can differ.
Sometimes all the 'moved-from' ...

**2**

votes

**2**answers

280 views

### Return list of all values that match Two criteria

I am trying to setup a formula that returns values that satisfy two criteria.
E.g.
A B C
1 Bob Banana 10
2 John Banana 10
3 Steven Apple 5
4 Elliott Apple 2
...

**0**

votes

**4**answers

57 views

### Determine if values are +/-10% of each other in excel

Hello and thank you in advance. I'm trying to put together a formula to determine if a series of values, e.g., 22.1, 23.4, 22.5 (up to 12 different numbers) are within +/-10% of each other. I've tried ...

**1**

vote

**1**answer

42 views

### Conditional formatting using IF function to meet 3 criteria

I have a row of dates at the top of my work sheet. I want to conditional format cells to give me a coloured cell if the date at the top of my worksheet (H8) is >= a date in cell D11, <= a date in ...

**0**

votes

**1**answer

38 views

### Im manually changing value and color of a cell, i want same value and color to be replicated into a cell another sheet

Im manually changing value and color of a cell, i want same value and color to be replicated into a cell another sheet on the same time. is it possible?

**0**

votes

**1**answer

5 views

### Excel . Give Weight to Score between Two %

i need solution for Formula , if i have Score for certain name that i need to give him weight . like in below
but there is already determine score & weight that i want to select from it
above ...

**0**

votes

**1**answer

34 views

### How to copy a data validation formula from a single cell to a row

How can I copy a data validation formula from a single cell to a row;
let's say from A1 to A2:A500, while the formula inside of the data validation should be adjusted according to its cell location.
...

**0**

votes

**0**answers

10 views

### Excel Array Function Giving error when file is saved as a copy from network drive

I have created a template in excel that used SUMPRODUCT and other array functions. This file is saved to a network drive in which others can save a copy and use in their own work stations. I have ...

**0**

votes

**0**answers

25 views

### Updated Versions of Excel File: how to link “LOOKUP” and “Data Validation” to the Original Version

I'm working with Excel 2013.
I have a complex Excel file original.xsls with "VLOOKUP"s between cells and sheets of this document and "Custom Data Validation" with links within the file.
There are ...

**0**

votes

**2**answers

33 views

### Find Difference of Time in Excel

I have data from biometric attendance device and I am tasked to create a report of how late an employee comes in on daily basis.
I have Column A in h:mm:ss AM/PM format
I have Columns B in h:mm:ss AM/...

**-1**

votes

**2**answers

42 views

### VBA Creating a clocking sheet

I would like to create a register of the clocks that I make. When I come at work I click on a button and it adds the hour in the right cell so it can count my time. But I would like to automate that. ...

**0**

votes

**0**answers

16 views

### Comparing columns in two different worksheets

I have 2 worksheets. Sheet1 and Sheet2.
Sheet1 A2 contains TODAY()
Sheet2 Column A contains text
Sheet2 Column B contains dates
I want to match the date in Sheet1 A2 to Sheet2 Column B. If there is ...

**1**

vote

**1**answer

18 views

### Excel: when combining column chart and line chart, position of the line

I am trying to obtain the following chart: for each month, a column chart representing the amount of money spent, and line chart representing the amount of money I had at the beginning of the month.
...

**0**

votes

**1**answer

11 views

### Add a second horizontal axis with different values in an Excel combo chart?

I have a combo chart (clustered column and line). They are currently using the same x-axis (which is simply the number of weeks, starting at 1) and different y-axes (primary one for the stacked column,...

**2**

votes

**1**answer

31 views

### How to put the values of column A to row A and keep the values of the dataset unchanged?

I've got a large dataset with 10 variables (columns) and 10k rows.
One of the columns is Year, going from 2000 to 2014. I want the values of the Year to be joined with the names of the variables.
...

**0**

votes

**0**answers

23 views

### VBA Excel doesn't show English characters

I wrote some scripts in VBA that have some text in other languages except english.
As you may know, I changed windows setting under region menu to support my non-english language.
Everything is ok ...

**0**

votes

**1**answer

59 views

### How to Combine these Excel Formulas in a Cell

I have these three formulas:
In Cell A1:
=IF(OR(ISNUMBER(SEARCH({"*31*","*32*","*33*","*LIP*","*Kuala*"},$E4))),"MP32-LIP Area","Recheck-It")
In Cell A2:
=IF(OR(ISNUMBER(SEARCH({"*Dewat*","*Ports*...

**0**

votes

**1**answer

33 views

### How to create a nested if statement based on time range?

I'm trying to group a series of time ranges in a column into 4 time range buckets (7AM-12PM, 12PM - 4PM, 4PM-8PM, 8PM -12AM) that I'll display in the next column. So, if the time is 730 AM on the left,...

**0**

votes

**0**answers

20 views

### Windows 10 - Remembering applications open and position/window size for all apps. VBA script

I am looking for a VBA script (I am not able to install an application on the workstation at work) that will scan all windows (.exe's, browsers, etc...) and be able to save the positions and size of ...

**0**

votes

**0**answers

32 views

### How to keep original formatting when copying from Excel to Word and back to Excel?

Here's my problem:
1) I copy a range of values from Excel. Copy Rows from Excel
2) Paste the rows into word with Keep Source Formatting Paste with Keep Original Formatting into Word
3) Edit my rows ...

**1**

vote

**0**answers

12 views

### Is there any way to display notes on a cell when the Excel workbook is embeded in a webpage via iframe?

I'm trying to display an embedded spreadsheet on a webpage. It must freeze the top row and first column for ease of navigation (which Google sheets can't do when embedded). The other thing I need it ...

**0**

votes

**0**answers

12 views

### CATIA V5-6R2016 VBA Locals Window isn't displaying data

After previously showing all relevant variables and values, my CATIA V5 VBA Editor's locals window has stopped showing any data. I tried running different macros, with and without user forms. After ...

**0**

votes

**1**answer

25 views

### Installer for Excel 2016 build 1809

Excel 2016 has had several releases with performance enhancements since the version we use at my company.
https://techcommunity.microsoft.com/t5/Excel-Blog/Excel-O365-performance-improvements-in-...

**1**

vote

**0**answers

25 views

### Excel search cannot find specific data in a worksheet, even when data exists

I have text data in two workbooks in Excel. The first problem is that when I search for text in any of the workbooks, the search does not work for some text. So for example, in the first workbook, I ...

**0**

votes

**0**answers

15 views

### Download/Extract xlsx file from iqy file

I have an iqy file from SharePoint that, when opened with Excel, shows me a list that I can save in xslx format. I want this process to happen automatically and preferably in the background. Is there ...

**0**

votes

**2**answers

32 views

### What function to use in Excel to count all numerical values of one variable on the basis of the values of another variable?

I'd appreciate some help with working with the data set with Excel.
I have a big data table with 4 variables in columns and multiple cases in rows.
The Sector variable shows what type of sector the ...

**0**

votes

**1**answer

20 views

### Excel - Using Two Data Tables to Build Output Table

I am trying to compare the locations of numbers in two different data tables and create an output summing the total revenue booked per day of the week based off the location of the day of the week in ...

**0**

votes

**1**answer

40 views

### Excel: filtering text to show rows with certain words AND without certain words

Say I have a table with 3 columns:
I want to filter to only show rows that contain an animal from the animal field, but not a place name in the city field.
In this example, I want to only return row ...

**0**

votes

**1**answer

45 views

### Use defined column names in conditional formatting formulars

I have a table with 28 columns. 8 columns are calculated values. The other 20 columns are user-input.
Now I want to setup conditional formatting to highlight rows which do not have values in all of ...

**0**

votes

**1**answer

39 views

### How to add up multiple values for multiple rows in excel and end up with 1 row per unique ID with sums in columns

Basically I have a huge list of data with multiple rows of unique IDs (each ID can appear on multiple rows). I then have multiple variables in no particular order associated with a value. I would like ...

**1**

vote

**2**answers

75 views

### Create an exploding stacked column chart

I want to create an exploding stacked column chart similar to this:
For example, I want to create the graph from the following data:
+--------------------------------+--------+--------+
| Process ...

**-2**

votes

**1**answer

35 views

### How can I change the value of a cell depending on the value of another

I have a cell on my worksheet that holds the amount payable to debtors. I have another cell of amount paid. I need to know how I can be able to make the value of amount payable to decrease with the ...

**0**

votes

**1**answer

24 views

### Excel says SUMIF formula I try to use to have too few arguments

I am trying to use the SUMIF-formula, but can't seem to work out how it works, and how it want me to input the formula.
The formula template is stated as:
=SUMIF(range criteria [sum_range])
I have ...

**2**

votes

**1**answer

28 views

### Shortening long sentence based on lookup-value

Need help: As stated in image below that I need the result in E3 to be "Washington" because based on lookup value in B6:B9 there is a matched-word partially (which is 'Washington') from D3's long ...

**0**

votes

**0**answers

12 views

### How to preserve pivot chart formatting? [duplicate]

Every time I make changes to my pivot table, the chart formatting reverts back to its original appearance. How do I preserve my chart formatting?

**0**

votes

**0**answers

19 views

### Create a report in Excel from a Master data using a pre-defined Template

I have bunch of data in a table called master list. I need to copy each and every row of data into a predefined template into separate excel files.
My master table is as below named as Master.xls. ...

**1**

vote

**2**answers

48 views

### Bypassing one of the SUMIFS criteria+criterion if the particular cell is blank

Need help:
From the table image below, the result I want in cell M5 using SUMIFS formula is that if cell K5 (validation filter) is blank or "" then the formula of D5:D6,K5 should just bypass.
So the ...

**0**

votes

**1**answer

18 views

### IFS formula to check two different cells

I am trying to create an invoice tracker that has one cell with the options for "Paid", "Past Due" or "Pending".
My formula for the cell is
=IFS(C3>=0,"Pending", C3<0,"Past Due")
C3 is the ...

**0**

votes

**0**answers

28 views

### How can I format the Excel file that is created by my ssis script package?

I currently have a script task in ssis that takes data from a sql server table and creates an excel file with different sheets for each city in the location column of the sql table. I want to be able ...

**1**

vote

**0**answers

15 views

### Excel Creates an External Link to Add-In when Transporting Worksheet Between Users

Simply stated, I have a formula in a worksheet that I made on one computer:
=setChartAxis("Template","Chart 2","Min","Y","Primary",(Template!C4 - 0.5))
The setChartAxis function itself is from an ...