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.

Filter by
Sorted by
Tagged with
0
votes
0answers
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
2answers
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
4answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
2answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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 ...