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.

learn more… | top users | synonyms (2)

0
votes
0answers
10 views

Excel Multiple Drop-Down lists

I have 2 drop down lists. One column is Equipment name the other is class number. Some of my coworkers can remember the equipment name, others can remember the class number and i would like to be able ...
3
votes
1answer
23 views

Limitations to the Excel INDIRECT() Function

If I have numerical data in A1 and A2 then: =SUM(A1:A2) works and: =SUM(INDIRECT("A1:A2")) works and: =SUM(A1,A2) works but: =SUM(INDIRECT("A1,A2")) does not work. I am guessing that this ...
0
votes
1answer
12 views

Excel Convert Time with units

If I have a cell with time data formatted as "1m 11s", how can I convert this to something excel can understand?
0
votes
0answers
7 views

Reset code and userform window positions in Microsoft Office VBA

When we open UserForms and code modules in a Microsoft Office VBA project (Word, Excel or Access), we can change the size and location of these windows. MS Office saves the last position for these ...
0
votes
0answers
18 views

How to check the values are increasing or decreasing between different columns?

In the below table each row shows different behaviour. For eg: In the first row for the columns "pool1" the values are decresing and same behaviour for "pool2" and "pool3" columns. In the second row ...
1
vote
1answer
22 views

List difference between 2 columns excel

I have 2 columns looking like this: A | B -----|------ a | a b | c c | e d | g e | i f | k g | l And I am looking for an array formula to list all ...
0
votes
1answer
10 views

Office 365 Excel > Sort > “My data has headers” grayed out

Using Excel from Office 365. I've selected a range of cells from Row 1 down to Row 200. The cells have a header row, but when I try to sort the data My data has headers is grayed out and can not be ...
-1
votes
1answer
11 views

IF there is the value of I6 in range C170:C999, then set D6 to value of B at index whereever I6 matches C170:C999

I tried for 3 hours now but can't find a solution to my problem. I have to set D6 to the value of the cell G on line where I6 and C170:C999 match. For example I6 matches C200, then D6 should be set to ...
0
votes
1answer
17 views

Excel offsets to suit complex autofill scenario

Having some trouble with off setting cells in order to use the auto fill option in excel rather than entering cell formula manually which is what I'm doing at the moment. Here is an example of what ...
0
votes
1answer
10 views

Need help tagging in excel

Please help, I´m trying to sort this data in the best way i can, column B cells exist in multiple categories under column A. Therefore i´d like to tag all the column B cells with their corresponding ...
0
votes
0answers
6 views

How to plot a scatter plot where labels are on y axis and values on x axis?

I have to plot a scatter plot to represent my data. my data label must on y axis and values on x axis. Please help me in this
0
votes
0answers
12 views

How to tell which labels have been changed in a pivot table?

I'm working in Excel 2010 with a few pivot tables where I think some wrong edits were made on row labels. I need to find the edited labels, check them for mistakes and correct the wrong ones. The ...
0
votes
0answers
27 views

How to replace an array excel formula with another regular one to avoid long calculation time

EXAMPLE by using an array formulas in range (E11:E16) According to the above example: To count unique customers in range (E2:E7) that meet only the following criteria: 1- Purchased Product 1, ...
0
votes
1answer
17 views

Chart two columns of data in Excel

I have two columns of data: RPM and MPH. I want an Excek line chart of RPM versus MPH. Then I would like to create a formula for the best fit.
0
votes
0answers
11 views

Intermittantly can't edit Excel cell

I use Microsoft Office 365 ProPlus running over Windows7 64 Enterprise. While I work on an Excel spreadsheet, it will often refuse to let me edit a cell. I click in the formula bar but the editing ...
2
votes
3answers
21 views

Hide cell from being computed in the formula

I have two cells in the same column adjacent to each other (Q7, Q8). They are used in multiple formulas as range. eg: 1. SUM(Q1:Q10) 2. SUM(E6:N13)-SUM(P6:AJ13) How do i skip those two cells from ...
2
votes
0answers
13 views

Show MS Excel Syntax as you type Formula

I have Office 2013 on my work computer and Office 2016 on my personal computer. On my work computer in Excel 2013 when you type a formula you get the suggested syntax for formulas as you type, but on ...
1
vote
2answers
14 views

How to change the Fill Color selection in Excel?

For some reason, in Office 2013, Microsoft changed the list of colors available for Fill to this: It used to have bright green in the palette, but no longer. How do I change either the Standard ...
0
votes
0answers
9 views

Excel: Add new rows to a table with a subtotal row, when data added to a specific column on the last row

How do I get an Excel table (with a subtotal row) to automatically add a new row when I enter data in column C of the last row? At the bottom-right of the table I have 3 cells with basic SUM formulae,...
0
votes
1answer
13 views

How can I sort a list of strings to display “x number of characters”?

I have a list of several thousand strings [numbers formatted as text] of length 15 that all consist of "zeroes" and "ones." I want to filter and display only the results that contain "x number of ...
0
votes
1answer
10 views

Creating a For All function in Excel

This might be hard to explain, but I am trying to create implement a formula that compares a bunch of values of "TRUE" or "FALSE" and then displays an output a corresponding cell that states if at ...
0
votes
1answer
8 views

Excel formula: Add entries in same month and year

This seems like it should have a fairly simple solution, but I can't quite find it. Any help would be much appreciated. I'm trying to write a formula in Excel that will refer to an itemized list of ...
0
votes
0answers
17 views

Excel 2013 range copy rounds to penny but don't want it to

The code below (Excel 2013 VBA) saves a range of input values (a scenario) to a storage array selected. It is working generally fine, but it rounds all the values to nearest 0.01 (pennies) but I don'...
0
votes
1answer
27 views

how to convert spreadsheet cells to units of time?

This is the goal: +------+---------------------+---------+---------------------+ | A | B | C | D | +------+---------------------+---------+-------...
0
votes
1answer
18 views

How to check whether rows of specific columns have the same sign or not in R or Excel?

I have spreadsheet with many columns. In that Columns starting with "FC" should have all the rows with same sign. But below in the table you can see that for the first row "NM_000319" columns "...
0
votes
0answers
11 views

How do I color code a scatter plot in Excel?

I'm trying to create a scatter plot in Excel, where the data has multiple ways of being identified. For example, say there's a list of stores I want to analyze, and I want to attach the store number ...
0
votes
1answer
25 views

Can I use an excel book in SharePoint as my eternal data source?

Is it possible to use a data table from an excel workbook that's on SharePoint as an external data source to a workbook on my local drive or another location in SharePoint? There is a massive excel ...
0
votes
0answers
8 views

Array formula behaviour inconsistent?

I am trying to use a sum with an array formula to be able to make a "sumproductif" : my old formula : =SUMIFS(OFFSET($B$2:$B$1915;0;$Z$22);$L$2:$L$1915;$Y$3;$B$2:$B$1915;X4) I replaced it with {=...
0
votes
2answers
19 views

Need to change rows to columns

I have a spreadsheet where 5 locker combos for each locker were entered but we did them in a list going down the rows. Now they want the five to go across in columns. Is there a way to change these ...
-3
votes
1answer
29 views

How to split text and string from excel into separate colums

I need to separate text and string from a single cell into separate columns. Please find below an entry: 70000049Isha
0
votes
0answers
20 views

Excel 2016 add-in tab not appearing in build 7070?

Is anyone having a problem with Excel add-ins loading in Excel 2016, but their tabs not showing up in the ribbon? This was not a problem with Office builds prior to build 7070, released July 12, 2016....
1
vote
1answer
20 views

Can a single cell in Excel extend over several pages? How?

I encountered this problem while trying to write really large chunks of text in Excel. In spite of of wrapping turned on, my text doesn't really get wrapped once it stretches over more than 12 lines (...
0
votes
0answers
4 views

Same Excel workbook fails to connect to Access DB for SOME users

I have an Excel workbook that is pretty heavy with code and connections to Microsoft Access. When the Workbook opens, it looks at the database's full path, written in a cell in the Settings sheet. ...
0
votes
1answer
18 views

Excel 2013 INDEX/MATCH vs. SUMIFS efficiency for looking up values with multiple parameters

Often times I find that I need to look up a value from a table using multiple parameters. For example, in this table I have two columns containing two levels of categories (e.g. the category "Food" ...
0
votes
1answer
14 views

How to make it so only the labels show up as points on a scatter plot in excel

So I am trying to plot countries on a graph in excel using two letter codes, but the points keep getting in the way and cluttering the graph! Is there any way to remove them and only keep the labels? ...
0
votes
2answers
18 views

Is there a way to add together an arbitrary number of cells based on a specific criteria in Excel?

So I have a spreadsheet with a bunch of little mini-charts as seen below. The numbers in blue are user entered, and they are all added together in the chart with the gray cells on the top left. Right ...
-1
votes
2answers
49 views

How to filter rows in multiple columns in Excel? [on hold]

I have multiple columns with some values. How can I filter rows with >=0.1 in Excel at a time? Name A_NT.1 A_BPA.2 A_BaP.3 A_BPABaP.4 AT1_NT.5 AT1_BPA.6 AT1_BaP.7 AT1_BPABaP.8 ...
1
vote
0answers
17 views

Is there any way to put a thermometer chart inside of the category name on another chart?

I'm using Excel 2016 and have a bar chart showing Manhours/Actual Hour. I want to make the horizontal category labels have a separate bar chart within them, showing time spent out of time possible (...
0
votes
0answers
38 views

Getting data from same row as matched cell on separate sheet

I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the match. Let's say A2 matches Sheet2!A20. I need the formula to return what's in Sheet2!E20. I ...
0
votes
0answers
16 views

Create Excel Chart Tracking Ad Placement Dates Versus Customer Volume

I have a chart now that tracks customer volume by month. Somehow I would like to add (maybe across the bottom?) what ad placements we had during those times. So, for example, in January if I show 63 ...
0
votes
0answers
14 views

Defining a range in excel for index/match

I'm trying to return a "best" value, but there are two criteria for a threading calc. One column has stress, which just has to be higher than a given value, and the other would be where you want the ...
-3
votes
0answers
13 views

Get data in MS Excel from Active Directory

I want search data in activer directory from a value excel cell, like I have user ID in excel sheet want to retrive frist name and last name of that user ID. Can someone help me to resolve this? Using ...
1
vote
1answer
15 views

Excel 2016 won't break down data for a chart

I just started MS Office 2016 Excel on my Mac, but I can't get it to create pie charts for me. Even if I choose a column of data, it seems Excel thinks it is a single piece of data. Switching between ...
0
votes
1answer
16 views

Create pivot table with one column?

I am not even sure how to title this question. If you can give me a better title I will update the question. Here is what I am trying to do: Column Title: Status A (blank)...
1
vote
0answers
10 views

Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...
0
votes
1answer
19 views

Show middle hierarchy in Excel treemap?

I have a CSV with filesystem data; file paths and size. I've created a treemap chart from this data, but the problem is that the treemap doesn't seem to take hierarchy into account. Each data point, ...
0
votes
0answers
20 views

Excel Power User Challenge - Advanced Workbook Split [on hold]

I need to split a workbook's multiple worksheets into multiple files (not based on worksheet name). Sounds easy, but just wait. The project: It deals with very sensitive HR/performance data, and I ...
-1
votes
1answer
142 views

Excel, No longer receive the option to open files in a different format

I have a web app that saves files as .xls but are actually well formatted .html. The files have always opened with excel producing the following warning: The file you are trying to open 'file.xls', ...
2
votes
2answers
17 views

Padding zeroes in non-Text lists

I have a list of numbers that have 3 digits after the dash (FL-100), but in the list are numbers that are formatted with only 2 digits after the dash (AR-12). They all need leading zeroes in order to ...
-1
votes
0answers
9 views

Excel - Data Fill from another sheet in certain column if value is right

I want to copy certain information from a line in another sheet if in a specific column it shows a value different from Work Done. Say in column F it has a value different from Work Done, then I want ...