**0**

votes

**1**answer

28 views

### Duration calculation in seconds [on hold]

This is what my data looks like. How do I calculate the duration, in seconds. I've tried some an answer but it looks complicated -
=INT(E226-D226)&" days "&TEXT(MOD(E226-D226,1),"hh "" hours ...

**-1**

votes

**1**answer

22 views

### Merge Two Dynamic Tables in One Table [on hold]

I have try to merge/combine two tables but I have always fail.
How can I merge/combine two dynamic tables in one table

**0**

votes

**0**answers

24 views

### Excel timeline summing overlapping values [on hold]

I have an excel spreadsheet with the following values:
Start End Value
1/12/15 5/12/15 6
3/10/15 4/8/15 3
I want a timeline that starts at the earliest date out of the entire ...

**0**

votes

**1**answer

20 views

### Filter data for different data serie to display in XY-Plot

I want to paste the date (see image) in my excel sheet a get a XY-Plot with 4 data series, one for each Method
Until now I filter them by Method and copy each result, so I get 4 tables for 4 data ...

**0**

votes

**1**answer

35 views

### Excel combination 6 [on hold]

Good morning,
I am trying to do in excel all possible combination of 1 to 6 without repeating.
6!
How can I list the 720 possibilities
Thank you,
examples
123456
132456
654321

**0**

votes

**0**answers

19 views

### Excel cell value showing when printed despite font colour and fill colour being exactly the same

In Excel, if I set the fill colour and font colour of a cell to be Gray (RGB 217-217-217) and then type "TEST" in the cell, I cannot see any text but when I print it (I made the cell significantly ...

**0**

votes

**0**answers

12 views

### How to open an excel and prevent the automatice convert the numeric fields larger than 15char

We work with a software that we must export data from and use this information for multiple functions, one is the data is reopened in Excel. Excel converts the numeric fields greater than 15 char to ...

**0**

votes

**1**answer

34 views

### Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets
Sheet 1 contains 2 columns.
Column A has a range of unique alphanumeric identifiers.
Column B has a range of non-unique numbers.
A B
...

**0**

votes

**0**answers

9 views

### Information into multiple sheets

I run a drag racing promotion company and need some help in creating a workbook for shows. I want to put a master list of names in sheet 1, sheet 2 through 20 will be the different classes. Is there ...

**-1**

votes

**1**answer

14 views

### Creating a button linked to tex and not cell [on hold]

I want to create a button in Excel that is linked only to a word, so that if lines are removed, the button is still linked to the text and not the cell. How can this be done?

**2**

votes

**2**answers

34 views

### Column of Text in Excel

I have a column in my spreadsheet in which each cell is either a YES or a NO. I'd like to produce a NO result even if there is only one NO in the column. I tried
=IF(C4+"NO","NO","YES").
This ...

**-1**

votes

**0**answers

15 views

### Formula copy display only formula [on hold]

Suddently I cannot copy formula from one cell to another it just expose the formula.
this formula is correct, it work in original cell. the destination cell is setup on automatic, If I type manually ...

**0**

votes

**1**answer

17 views

### I would like to add specific text to get total count

I am trying to create a holiday calendar for team. We have defined terms like
H= Holiday
B = Business trip
S= Sick
I would like to count total of H , S &B for calendar year.
How can I do ...

**27**

votes

**9**answers

2k views

### How do I insert a new row in Excel via the keyboard?

Right clicking on a row and clicking insert is fairly time consuming. I'd rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? ...

**0**

votes

**1**answer

23 views

### Frequency formula in Excel 2010

I am just trying to figure a way to get the frequency of occurrence of a number within a large array, not the freq of the number in the array belonging to a range.
Eg, how many times does the number ...

**0**

votes

**0**answers

14 views

### Auto populate data from one worksheet to another [on hold]

I have an excel worksheet with a nominal of employees I would like to be able to filter departments to a separate worksheet I have been trying all day but to no avail.

**0**

votes

**1**answer

38 views

### How do I generate random numbers between a range in cells? [duplicate]

I'm wanting to create a button that generates a string of 10 random numbers into cells, and pulls the range for these random numbers from, for instance, in B1 and B2. Basically, I'm looking to use the ...

**0**

votes

**0**answers

19 views

### What do I need to see if there is matching formula between two cells in Excel? [on hold]

I'm awful at excel and I'm trying to figure out what I need to do to see if there is matching formula between two cells.
As an example D6 has a number 55, P6 has something like mon200055. Is there a ...

**0**

votes

**0**answers

14 views

### Excel automatically applying styles to new data

I'm having a problem with Excel 2013.
I have a spreadsheet filled with names and related information for applicants. When I contact the applicants, I highlight the cells (using the fill tool) so I ...

**1**

vote

**1**answer

15 views

### Excel 2010 SUMPRODUCT FUNCTION - unable to do date comparison

I run a small share investment club and of course use Excel to keep track of our activities. On one worksheet (Asset worksheet) I am trying (for each company we hold) to add up the dividends received ...

**0**

votes

**0**answers

14 views

### How to make Excel scatter plot axis show months rather than days?

I have an Excel scatter graph that is separating months into 20-day segments instead of the entire days of each month. How do I fix this? I want to have it reflect the days of the month by simply ...

**-1**

votes

**0**answers

9 views

### Is there a short cut key to put MS Outlook for text to column option [on hold]

Hi team i am using windows 7 operating system and king office 2013 software. I have a doubt what is the shortcut key for text to columns in king office 2013 spreadsheets. Help me team

**-1**

votes

**0**answers

8 views

### MacBook Air, OS X 10.9.3 - Excel for Mac 2011 [on hold]

I am trying to save a spreadsheet that was built in a different version of excel and the conditioning formatting formulas are too complicated for Excel for Mac 2011.
Any ideas?

**0**

votes

**0**answers

17 views

### Excel locked columns

-Is is possible to lock a column, for example column F, and then set it so if i scroll from column E, all other columns will appear before the F column. I am trying to set F up at the end of a spread ...

**0**

votes

**0**answers

52 views

### Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names.
In Column B, I have n number of Order numbers for each name.
In one cell I will be inputting the number of orders I want to pick randomly.
Once I input the ...

**3**

votes

**1**answer

24 views

### change layout in excel sheet

I have excel sheet (plz visit link below,unable to post img)
http://postimg.org/image/q4nf8j7qd/
which contain first name,last name,city,address, etc of many person..
A | B | ...

**0**

votes

**1**answer

25 views

### Comparison of two files in excel [on hold]

I want to compare two files including ticket number and amount.How to compare?
I can also send you sample files format.The ticket number and amount is same in file 1 and also in file 2.But,they are ...

**2**

votes

**1**answer

33 views

### Excel averageifs multiple criteria on one range

I know how I can use average(if(... etc using an array, however I'm stuck on how to include other criteria in this
This is what I've got so far:
...

**1**

vote

**1**answer

46 views

### Excel 2013 match values in two workbooks and merge one column

I'm running Excel 2013 and I have two spreadsheets open. The first, sheet1, has two columns and 7k rows the columns are:
A B
ID Description
58749651 a ...

**0**

votes

**0**answers

12 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...

**-1**

votes

**2**answers

22 views

### How can I assign Cell Part as Variable?

I want to set a number in a cell to be a variable yet still keep text in it. That way it can be added up later using that variable.
I want it to say something like
Justicar Aatrox: 975
And ...

**0**

votes

**0**answers

24 views

### Add content from cell in sheet1 to cell in sheet2 when cell in sheet1 is found dynamically [closed]

Reworded for clarity per site request 1
How do you find a value in a list on sheet1, get the value in the column to the right of it and enter it into a cell in sheet 2, then add a number to it, then ...

**-1**

votes

**0**answers

20 views

### Excel: making a chart evaluating two binary conditions

I have several sets of data in binary text form: them/us, win/loss, up/down. A row might look like
Them | Them | Up | Win
I'd like to make a chart evaluating this data. Ideally, I'd like a chart ...

**1**

vote

**1**answer

19 views

### Can Excel Solver solve with this equation?

I’m buying some food, and want the most calories I can get for my money.
I have a budget of $12.00. There are 3 food groups, and I need to pick 2 items from each of those groups. There is also a ...

**0**

votes

**0**answers

11 views

### Normalizing imported date values and formats

I am importing data into Google Sheets and having difficulty figuring out how to fix and normalize my date cells which are being incorrectly interpreted.
In Google Sheets, when you type in a number ...

**1**

vote

**1**answer

20 views

### EXCEL - How to use two cells for input and output at the same time

I have 3 cells, VALUE, DOWNPAYMENT, DOWNPAYMENT %.
The 3rd cell "DOWNPAYMENT %" calculates the percentage of "DOWNPAYMENT" over "VALUE"
Is there a way for the user to have the function to input a ...

**0**

votes

**0**answers

18 views

### Combining worksheets into worksheet

I have Jan as sheet 1, Feb as sheet 2 to Dec as sheet 12. I want to combine these sheets such that, I would have on one sheet the data in Jan column Feb column Mar to Dec.

**0**

votes

**1**answer

15 views

### How do I change the DATA TYPE of a cell or group of cells?

I have a large spreadsheet of data which stubbornly will not change data type. when I run the type() formula on a cell, it returns the value 1, and it will not change no matter what I have tried.
...

**0**

votes

**1**answer

21 views

### apply conditional formatting to a cell when it matches the text in another column on another worksheet

I have a list of accounts in column a of sheet one.
I have a sublist of the same accounts in column a of sheet two.
If the account name in column a of sheet 1 matches an account name in column a of ...

**-1**

votes

**0**answers

9 views

### EXCEL - Build table with variable number of columns based on another data table [on hold]

Is it possible to build a table with variable number of columns based on another table?
Example:
Enter number of regions: 3
up pops 3 regions named A, B, C
Enter number of segments for A: 2
...

**2**

votes

**1**answer

11 views

### Excel: filter a column by more than two values (“ends with”)

This is related to another (answered) question. At:
Excel: filter a column by more than two values?
There is an answer for how to filter for cells equal to a set of values with more than two ...

**1**

vote

**1**answer

16 views

### Totaling cells over multiple tabs perhaps NOT in the same position, but with same name

I have an excel document with different tabs for each month that has totals paid from individuals. Not all months have the same individuals, as some are added or removed. Is there a way to make a ...

**0**

votes

**0**answers

22 views

### Split Text String VBA [closed]

I need to split some text in Excel. I need to split the data but I cannot just use white space because I do not want to split some of the data (e.g., name and address). Is there a way to split based ...

**0**

votes

**1**answer

23 views

### Excel Scatterplot Graph

How would I put on set of data on the x axis and the other on the y in Excel?
Meaning suppose I had 5 people rate two different films on a scale of 10 and I organized my results like this:
Person ...

**0**

votes

**0**answers

23 views

### In a Pivot Table, how do you calculate the percentage of one value to another value?

I have a pivot based on raw data where each line is a person and their characteristics.
What I'd want to achieve:
I'd like the percentage of a value depending on various subgroups and locations.
I ...

**0**

votes

**0**answers

14 views

### Update links to another excel workbooks

I have a excel work books that I use VBA programmed macros to open serval another workbooks (WB's). In the main WB I have a lot fomulas that is linked to the another WB's. After open all files, I ...

**0**

votes

**1**answer

24 views

### Excel formula - date comparison

I'm trying to construct an Excel formula to compare the date in column A to the date in column B, tells me YES if they are the same date, tells me NO if they are different dates, then if NO tells me ...

**0**

votes

**0**answers

18 views

### Excell 2013 Calculating across Multiple Sheets number of fields

I am trying to work out the total number of fields across multiple sheets to arrive at the total number of new members each month.
Some months have little as 50 others as much as 250+.
I thought I ...

**0**

votes

**0**answers

32 views

### Combining an IF statement with a dropdown list

Column 1 has a drop down list with the following selections
Cash
Check
Deposit/Refund
I need for column 2 to say "Cash" if it's selected, "Check" if it's selected, but then I need it to have ...

**0**

votes

**2**answers

24 views

### Defining Variables in Excel

I have two lists of data, x and y, one in a row one in a column. I would like to populate a chart of rows and columns with a complex formula that is the same for each chart point, the only difference ...