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)

1
vote
2answers
15 views

Combine multiple email addresses (in separate cells) into one cell (separated by comma) Google Sheets or Excel

I'm trying to combine multiple cells with email addresses into one cell where emails are separated by commas. I've used this formula: =P2 & ", " & Q2 & ", " & R2 & ", " & AD2 ...
0
votes
0answers
4 views

Using indirect function within an Index formula, when the data is on a separate worksheet

I would like to make it so the data on a separate sheet can be looked up, without having to manually sellect the data each time. Normally the formula would look as follows, referring to tabulated data ...
0
votes
0answers
3 views

Excel Macro: update sheet or create a new one based on a single criteria

I want to write a macro which updates a single sheet out of many in an Excel workbook, based on a single criteria. The first sheet of my workbook is titled "Input"; I copy and paste a client's ...
0
votes
0answers
8 views

Combine data of unknown row size from multiple Excel tabs into one tab

I have a lot of tabs with similar data. As an example, let's say that I have three tabs: men, women, children. All tabs contain data of the following type. Name Surname Age Address How can I merge ...
0
votes
1answer
15 views

How to find time difference between two cell in excel sheet?

"14/07/2016 09:26:59" & "14/07/2016 09:28:47" I could not find difference between this time. I have enter formula =A2-A1 result shows "#VALUE!" Please help me.
-1
votes
0answers
23 views

EXCEL. An array that displays the most recent set of data(based on date) of a customer

I'm looking to pull data from one sheet into another sheet where I pick the most recent date of information on a person. So I may have 50 entries for Bob, but on sheet 2 I just want to post the most ...
0
votes
0answers
9 views

How to force Excel to use English formats on non-English locale?

I'm using English Windows, English Office but my system locale is Czech. This unfortunately leaks into Excel: How do I get rid of this? I want my worksheet to be pure English (US) – all amounts in ...
1
vote
0answers
17 views

Conditional formatting with several conditions depending on different cells

I currently have a table in excel that looks like . The table shows four projects, each with three stages with each having an expected and actual start date for that stage. I want to create a ...
0
votes
0answers
22 views

Excel big database

I have a really large database and I have to see which number appear most of the time. I know for mode function, but it will give me only the most appeared number, i would like to have first 5 or 10....
0
votes
1answer
14 views

Excel - How to combine a hyperlink cell and text cell?

My requirement is I have one cell with text and the next cell with a hyperlink. I need to add only the hyperlink to the text. Any ideas on how this can be achieved? I want to automate or use a formula ...
0
votes
1answer
12 views

Clearing a value when an option is selected from a drop down menu in Excel (VBA)

Good Morning, I'm trying to write a code in VBA, that while selecting from a drop down menu from D2, it will clear any value from E2 and F2 without removing the formatting. I have tried the follow ...
2
votes
2answers
22 views

How to name all data except for header row in Excel

Suppose I have some data like this: Name Number alan 1 bobby 2 cory 3 david 4 Assume that "Name" is in cell A1. I'd like to be able to name this range but not include the header row. I ...
-3
votes
2answers
34 views

Locating Hyperlinks in documents without opening them

Is there any chance of locating hyperlinks in a documents without opening them? My friends and I have been working on a project with roughly 300 to 400 documents including MS Word, Excel and ...
-1
votes
0answers
9 views

Parse Excel to xml using vba using Excel column data as XML attributes

I have an Excel table with data in column1 and id's to this data in column2. column1;column2 dataCol1Row1;dataCol2Row1 dataCol1Row2;dataCol2Row2 Using any of the VB examples given in Parse Excel ...
0
votes
0answers
10 views

Advice making a multi line chart with daily count data

This is what my raw data looks like..... raw data image I would like to use this data to create a chart that display's Install date in the X axis, a daily sum of records for each installed by name in ...
0
votes
0answers
10 views

excel 2010 predictive dropdown box

I have a drop down list in one work sheet and trying to link it to a predictive cell in another work sheet. The problem I have is that although all items in the drop down are visible (140 items) the ...
-1
votes
0answers
19 views

Excel - Columns containing the series match

Let's say Columns A,B,C,... contain numbers. When I enter the new data (numbers again) in a new column, I would like to have an indication that such a match of 2,3 and more numbers already exist in ...
-1
votes
0answers
11 views

Deleting sheet tab names

I have a spreadsheet with a list of sheets each sheet has a product name. I want keep the population sheet product names that fall within my list and delete all other sheets which are not on my list....
0
votes
0answers
15 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 ...
5
votes
1answer
36 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
15 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
1answer
9 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
25 views

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

In the table below each row has a different behavior. Note that, In the first row, the columns "pool1" the values are decreasing. Also decreasing for columns "pool2" and "pool3". In the second row ...
1
vote
1answer
25 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
2answers
13 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
12 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
18 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
12 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
8 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
13 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
1answer
33 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
22 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
15 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
15 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
10 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
14 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
11 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
9 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
19 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
29 views

how to convert spreadsheet cells to units of time?

This is the goal: +------+---------------------+---------+---------------------+ | A | B | C | D | +------+---------------------+---------+-------...
0
votes
1answer
21 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
14 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
27 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
9 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
21 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
22 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 (...