Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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.

0
votes
1answer
17 views

Roll-up Year Worth of Power Company

columns i want to output are daily sum of (kWh), daily average, daily peak or max, and time of peak. sum, averge and max forulas are straight forward but i struggle rolling them to next block of 24 hr ...
0
votes
0answers
15 views

Excel vba, Changing cell references in formula to point to different cell location

I am trying to move (offset) only parts of formula column location to a different column location by a specified amount of columns. The formula cells change from sheet to sheet. I have thousands of ...
1
vote
0answers
14 views

Excel - updating linked cells from the clone

I work with a pricing spreadsheet, which has hundreds of inputs, but in reality I only tend to work with 5 or 6. I want to create a summary worksheet where I only have the inputs I want to ...
-2
votes
0answers
25 views

Why am I receiving prompts to update links when my VBA code is set to turn this off? [on hold]

I am trying to create a macro that runs through all the excel files in a folder and copies a set of data from each file in the new file. I am having trouble with some of those file containing links ...
0
votes
1answer
7 views

Excel- Sum of two times to decides date

I creating a timeline with duration as a key data. I start an activity at 10 am, duration is 60 minutes . I sum the start time and duration and it updates end time as 11:00 and date remains same lets ...
-1
votes
0answers
21 views

Office 365 Excel

Q1: I am generating a percentage of completion with the formula =COUNTA(E4:N4)/COUNTA($E$1:$CU$1) However, I would like it to ignore any "no" values in a cell. How do I write the formula to ...
1
vote
0answers
21 views

Assign Nested Sequential unique numbers for items in Excel Table

I'm trying to generate a unique ID number for a items in a table in excel. For example: 1.2.4 For each column the number is uniquely numbered based on the text. For example in the table below would ...
-3
votes
0answers
21 views

Microsoft Excel - How to select certain data and display it separately

I've created a simple image that will entirely explain what I need to achieve.
0
votes
0answers
8 views

PivotChart Expand/Collapse elements in the legend

I have a pivot chart (stacked bars) showing data about different Teams, grouped in Departments, evaluated over time (months/quarters/years). I want to be able to see the data either of the single ...
2
votes
2answers
58 views

Deleting Rows In Excel Doesn't Reset Last Cell (Used Range)

I have an Excel file that is larger than 7MB. To understand where the weight is coming from, I've used the method described in this SU question. I narrowed most of the weight down to one sheet, and ...
-1
votes
0answers
21 views

Excel VBA programming [on hold]

One column has a 16 digit ID number. I need to be able to copy and paste that number into a cell and it will be able to tell me if it is duplicated. If it is duplicated the number of times it has been ...
-3
votes
0answers
12 views

Microsft Excel - Macros

I have an Excel Sheet which has 10 columns. I have split this Master sheet into different sheets in the same Excel. I have split the sheet on two criteria. First one for example Year like 2015, 2016 ...
-1
votes
1answer
26 views

How to sync same excel workbook between 2 computers on the same network

I need some help with this please. I have an input workbook where product data is entered, and an output workbook(Report) where this said data is copied into a single line using vba macros. The ...
1
vote
0answers
22 views

Pivot Table won't show correct data relating to the row names

I'm trying to create a pivot table to tell me how many people are coming to different parts of a bachelor party. When I select the "Row Labels", I select that of "Coming Zorb" as they are the same ...
2
votes
1answer
55 views

How to fix Excel and prevent it from converting copy-pasted strings to dates even when cells are formatted as text

Every time I copy-paste some numerical data written as fractions or separated by hy[hens into Excel, it always converts numbers that could possibly be dates into dates. There's no way of getting them ...
0
votes
1answer
21 views

Paint cell background based on the values of three columns

I have three columns of color data in my worksheet. They are labeled R, G and B and contain float values between 0 and 1. How do I color the background of a fourth cell in each row based on the R, G ...
1
vote
0answers
15 views

How do I get a cross-join with power query to “remember” values associated with it?

Let's say you have a basic Excel cross-query. You have two lists: A B C and X Y You cross join them (Cartesian join them), and get the following table: A - X A - Y B - X B - Y C - X C - Y Now, ...
2
votes
1answer
33 views

How do I transpose a table with repeated key values?

I have a table that looks like this: Column A | Column B 10 | 0.1 10 | 0.2 10 | 0.3 20 | 0.4 20 | 0.5 20 | 0.6 I need to transpose ...
1
vote
1answer
52 views

Excel formula advice

I am trying to use Excel to calculate delivery costs based on postcode data and volume. I have base data with all the postcodes and the costs based on the volume delivered. I want my main table to be ...
1
vote
0answers
19 views

Excel VBA - Use string variable as input to Union Method

Somewhere in the Sheet called Sheet 2 I have the following: Click for image It uses the TEXTJOIN function to concatenate the values in Column A. The string in B100 is variable S (see the code). I'm ...
0
votes
0answers
5 views

Power Pivot will not load in com add-in

Had a powerPivot application running perfectly with Windows 10 and EXCEL 365, but user has Office 10, so the 365 app would not run on that machine. I uninstalled Office 365 and installed Office 10 on ...
0
votes
0answers
17 views

Find the first occurrence of a value in a filtered data set, and return a corresponding value from another column

I have a spreadsheet of donor data, and I want to find out where our new donors come from each month. A data sample is below, but the full data set is approx 80,000 rows, and is formatted as a table. ...
0
votes
2answers
25 views

Excel, AVERAGE, SUBTRACT

In Excel; I want to calculate an average of three values and to find a difference between result and a value in another column. I want the difference represented as a positive number. R25 is -2.00; ...
-3
votes
0answers
28 views

Microsoft excel (or otherwise) listing possible combinations of a list of numbers [on hold]

I have got groups and I need the different combinations of the numbers in each group, Util 27 Telcm 28 Servs 29 Beer 9 Oil 26 Smoke 10 Cnstr 18 Util 27 Steel 19 FabPr ...
0
votes
1answer
21 views

Copy a hyperlink from one sheet to multiple other sheets

I have a workbook with 12 sheets, one for each month named JAN, FEB, etc. I have a hyperlink in cell B2 of JAN which jumps to cell B200 of JAN. I'd like to copy that hyperlink to all the other sheets ...
0
votes
0answers
11 views

Cannot change Date formats on Excel [on hold]

Please see this thread. I am struggling to change the format of dates in a workbook. I cannot change them manually as there are too many items. I believe this is due to there being text in the column ...
0
votes
2answers
43 views

How to paste value in cell based on the another cell in Excel

I have 2 sheets: 1 sheet contains numbers (some are duplicated) and another sheet contains the name of that number. I need to paste the name beside every number in the 1st sheet. Example shown below: ...
1
vote
0answers
28 views

Can't get rid of custom styles in an Excel 2013 workbook

I use Excel 2013 and I am trying to clean up an 8000 KB spreadsheet which has evolved over the years to include thousands of duplicate cell styles. I managed to get rid of most of them using some VBA ...
-1
votes
1answer
23 views

Excel check formula, return specific text on error

I have an excel sheet that uses an array to return the most common text found, and then the result is copied to a separate sheet so we can view the most common text per month of the year. This sheet ...
0
votes
1answer
46 views

Replacing an Excel nested IF by a vlookup of formula text

I am working on a spreadsheet for Materials Requirement Planning (just for fun). One problem is with lot-sizing rules. I have to use OFFSET and INDIRECT functions in a lot of places, and the formulas ...
1
vote
0answers
15 views

Excel: Pasting values clobbers table (i.e. list) object

I have a formally defined table (also known as a list object) in Excel. I have copied old versions of that table to other areas in the worksheet. But they are just for reference. There is only one ...
0
votes
0answers
23 views

Make Excel Spreadsheet Fill Page when Printed

I am attempting to print a spreadsheet that automatically fills the page utilizing all space available. The amount of rows varies, but the columns do not. The reason is that people hand write in the ...
-4
votes
0answers
21 views

Excel Help Needed - Need a master Wotkbook to Auto update [on hold]

I have 12 sales staff all with there own workbook containing bookings, I need this to all update onto one master sheet that the manager will see, is this possible? Thanks Steph
0
votes
1answer
24 views

Excel Calculate Date Differences between Orders Per Customer

I have a data-set with Account Names, Order IDs and Close Dates. I would like to see the number of days between orders, per customer, however Excel will not allow me to sort by date in my Pivot Table ...
0
votes
0answers
42 views

vba Relative Path from MS Access to Excel

Here, I read a piece of code written by Dave on September 12, 2016. I have this line of code that works well: sExcelWB = "D:\testing\" & "qry_task.xls" I have been trying the Relative Path codes ...
0
votes
0answers
25 views

How to create dynamic named range that includes blank cells?

I am attempting to define a dynamic named range, however some of the cells are blank, but I still need the range to encompass these cells. What functions, etc. should I be using in order to do this? I ...
-2
votes
0answers
22 views

Excel count date and text together

I need help writing a formula that will give a count when one cell has a specific text, "Very High" and another cell in the same row but different column has a date. The text is in (I7:I100) and the ...
-1
votes
0answers
26 views

Excel limits on data

Is there a rule of thumb for how many cells a workbook should contain given certain computer specs? I have an excel file with 26 columns spanning 650,000 rows, 2 of the rows are equations (VLOOKUP &...
0
votes
0answers
14 views

Excel - How do I change the color of a data bar based on its value

I have a column in excel that has been formatted to display a progress bar based on the value in the cell 0 - 100. I did this by going to: Home > Conditional formatting > Data bars > More Rules: ...
0
votes
1answer
37 views

Return All Column Location of String Value (Can be subbed for T/F) in a Row

I have a quandary - I am attempting to automate a process where I am manually searching across 59 cells per row, looking to provide all cell locations that house the string value of "Unmet" I have a ...
0
votes
1answer
20 views

Creating a scatter plot with 4 or more data columns fails, whereas it works with only 3

I have a CSV file that I'm importing into Excel. It's formatted like this: Time Var1 Var2 Var3 Var4 .. VarN 0 1 1 1 0 .. 0 1 1 0 1 0 .. 0 2 0 0 ...
0
votes
0answers
22 views

Choosing a set of random values from one column where another column matches a certain criteria

I'm producing an Excel report where I need to input a randomised selection from a data column, but to omit the human element of selection (for audit purposes). The column names are "Date", "Staff ...
-1
votes
0answers
14 views

Creating a file/folder directory and loader with use of excel

I want to select a parent folder, then for a code to work its way through the folders inside a the parent folder & create hyperlinks for the files. The aim is to have a directory interface on ...
0
votes
0answers
7 views

How to add checkbox to excel automatically?

Suppose I have three columns; Column A, Column B and column C. How to add checkbox using VBA automatically in column A if I put text in Column B (only) not Column C, and when I delete that text, ...
0
votes
1answer
28 views

How do I use Ctrl + End to go to the last formatted cell?

Using Ctrl + End on a excel worksheet goes to the last cell in the range (moves in the direction of the arrow) that has some content in it. This usually ignores formatted cells. That is, if you're in ...
1
vote
1answer
38 views

How to implement this formula with braces and brackets into Excel

I'd like to use Microsoft Excel to compute this formula to find y : But I absolutely don't know how to do... It's the first time I see such one. Could you help me ? Note : Td2 is a known variable ...
-2
votes
0answers
11 views

Keeping columns together when finding duplicates

I have three columns, the first has code numbers from a CRM, the second has information which needs to be kept in the same order as the first column (so that the duplicates can match with this), the ...
0
votes
0answers
36 views

Vertical and Horizontal Slicer Boxes

I had to go back to Office 2010 from Office 365 in order to create a PowerPivot table for a user who has Office 2010. I had the thing running on 365 but it would not run on 2010. So I uninstalled ...
0
votes
1answer
21 views

Missing the Split, Hide, and Unhide Buttons in Window Pane under View tab on Mac OS

I was trying to follow this guide to unhide my personal.xlsb workbook (which I've been able to successfully do on my Laptop that runs Windows), but when I went to the View panel of Excel, I realized I ...
1
vote
2answers
24 views

Can Excel VBA call Macro in Different Macro Workbook

Can VBA code in an excel spreadsheet call a different XLSM Workbook file's Macro? I have a local XLSM that needs to call a method in a different XLSM file, how can that be done?