**1**

vote

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

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

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

29 views

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

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

**0**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

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

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

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