**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**3**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

27 views

### how to convert spreadsheet cells to units of time?

This is the goal:
+------+---------------------+---------+---------------------+
| A | B | C | D |
+------+---------------------+---------+-------...

**0**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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 ...