**0**

votes

**1**answer

3k views

### Subscripts inside Excel formulae

I have a formula in Excel that evaluates the l_x's (number of lives aged x) in mortality data:
=IF(J3>J2,"l_x increased",IF(J3/J2-1>=devianceThreshold,"Deviance too high",""))
Accross the ...

**2**

votes

**1**answer

63 views

### Replace numbers with certain corresponding strings programatically

I have a large amount of numbers in an Excel spreadsheet that I want to replace with text. It looks something like this:
33
33
33
33
22
21
22
29
49
95
43
23
45
12
11
22
I want all of the 33's to be ...

**3**

votes

**2**answers

1k views

### Excel 2010 formula to delete repeated content based on value

I have a spreadsheet with two columns, a name and a value. The name is repeated several times with different values, for instance:
Name - 1
Name - 2
Name - 3
etc.
I am looking for a formula ...

**1**

vote

**0**answers

46 views

### Excel for Mac 2011 move column 2 in sheet 1 to column 1 in sheet 2

I would like to move column 2 into column 1 for each successive sheet, one sheet per week, automatically. Is that possible? I do it with this formula ='1st week'!D2 and manually changing '1st week' to ...

**3**

votes

**1**answer

7k views

### possible to have two Y axes and two X axes on same chart

Is it possible to have a chart with
left Y axis
right Y axis
top X axis
bottom X axis
all on same chart?

**0**

votes

**1**answer

3k views

### How do you click and drag lower right corner of a cell (autofill) in excel using the keyboard? [duplicate]

If I press CRTL+Down I move to the cell before the empty cell.
If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell.
Now if I want to auto fill ...

**0**

votes

**1**answer

1k views

### Scatter chart series with uneven data intervals

I have two series of data I wish to plot on the same graph: Series 1 has 10 data points, Series 2 has 15 data points.
I want to show both series on the same chart (presumably Scatter) with the points ...

**2**

votes

**1**answer

88 views

### formula for time calcuation within one cell

I want to put in a formula that calculates the difference between two times within the same cell.
For example the shift 6-2 or 6am-2pm equals 8 hours, and have the total sum of the shifts for two ...

**2**

votes

**1**answer

104 views

### Compare column contents and highlight matches or near-matches

I need to highlight all the cells in column A and column C that are identical or near-identical (with just one or two letters' difference.)
Also, I need to highlight cells if there are similar words ...

**0**

votes

**2**answers

159 views

### Excel conditional field setup

In Excel (2003) I'd like to setup conditional field data population logic.
For instance, if B2 = 'text string1' then C2 = 'number string1' OR B2 = 'text string2' then C2 = 'number string2' OR ...
...

**3**

votes

**1**answer

79 views

### Excel Format - less than 1.00 should appear as -

I need an Excel format that displays large currency amounts. I want it to add commas, don't show pennies, and show "-" instead of a zero.
This works:
#,##0;-#,##0;-
except that .02 appears as "0"...

**1**

vote

**0**answers

33 views

### How do I organize Information in different cells into specific columns?

I have a large document and the information is randomly arranged and I need to organize it in columns. The header of the document is like;
name | address | email_address | date
The email address are ...

**3**

votes

**1**answer

675 views

### Excel: convert unusual minute format into numbers

I want to analyze data from a application in Excel 2010. The application stores worked hours in a unusual way:
15 = 15 minutes
30 = 30 minutes
45 = 45 minutes
100 = 60 minutes / 1 hour
115 = 75 ...

**1**

vote

**1**answer

155 views

### How can i reset my Libre Office Calc setting

I am using Libre Office Calc for my Excel work.
Image 1:
Image 2
I can not see the format color in on Libre office installed @My System.
but on my Colleague System who uses the same Libre ...

**0**

votes

**1**answer

2k views

### How to remove round up functionality when the value need to be reused in another cell

I am using roundup function in one column of cells in excel. In the next column of cells, i just need to subtract the values from the previous column. But when I use it in the next cell, I want it to ...

**0**

votes

**1**answer

2k views

### How do I access tabs in an Excel workbook once saved?

I have an associate who sent me an Excel file with tabs at the bottom to switch to different worksheets within the doc. When I save the document, I can't see/don't know how to open the different tabs ...

**2**

votes

**1**answer

12k views

### Filtering A Graph of Series Data In Excel

So I currently have a line graph with 48 different lines, comparing 48 different series of data. The series are generated by changing three variables: One with two possible values, one with 4 ...

**0**

votes

**1**answer

211 views

### Convert datetime to another datetime format

How do I convert this datetime?
[23/Sep/2013:21:18:00 +0200]
to
23/Sep/2013 21:18:00

**0**

votes

**1**answer

55 views

### Excel 2010 - Merging multiple rows by the value from the first row

I must find a way to merge multiple rows by the vallue from the first row.
For example the image in the following
Any idea how to do this?

**0**

votes

**0**answers

238 views

### invalid csv file for lan fax

I am trying to import a list of fax-numbers in Excel into the LAN-FAX address book. To do this I need to convert an .xlsx file into a .CSV file with an ASCII or Unicode character encryption. I need to ...

**0**

votes

**1**answer

3k views

### Automatically rename worksheet based on filename

I want to rename my first sheet or tab in excel based on the file name. If I change the file name, I want the first sheet to be automatically renamed. I don't want .xlsx to be included. I tried this ...

**-1**

votes

**1**answer

6k views

### Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this:
It might ...

**0**

votes

**1**answer

2k views

### Excel coloured line chart for grouped data?

In Excel how do I create a line Chart with each simulator being its own coloured line showing Calculation time (and potentially another colour for its Total time).
Axis X = Rounds
Axix Y = Time (...

**1**

vote

**1**answer

273 views

### Excel 2010 formula to track records and replace them when surpassed or bettered

I've found using game data is an excellent way to learn the ins and outs of Excel. I made a workbook complete with personally made achievements (all of which work), but I can't find a formula that ...

**0**

votes

**1**answer

88 views

### Match dates and time (hours) but not year

I have a column with temperature data from 2012, for every hour during the year. I'd like that data to be used to approximate values during coming years by matching the date and the time, like taking ...

**1**

vote

**1**answer

680 views

### How to filter rows which are blank rows from a specific column onward?

I have a file with thousands of rows and need to filter it.
How can I filter rows for which all columns are blank after column X?
The situation is as follows:
I am working with a database of ...

**2**

votes

**1**answer

291 views

### Remove pseudo-blanks in Excel?

Is there a way to make supposedly blank cells truly blank?
I have had a bunch of formulae evaluate to "", whereafter I proceeded to copy the results and paste values. Now when I check for blanks ...

**7**

votes

**1**answer

66k views

### How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...

**0**

votes

**1**answer

407 views

### how to fill series in excel for cell which are non identical in size?

I have list of test cases with each test cases having diff number of steps. I want to use the Fill Series option for Test Case ID column (which is merged cell). How to fill the series for those merged ...

**1**

vote

**1**answer

2k views

### How a count of values which have more than 1 occurance in a column

In cell B5 I have a formula:
=SUMPRODUCT((A2:A10<>"")/COUNTIF(A2:A10,A2:A10&"")-(COUNTIF(A2:A10,A2:A10&"")=1))
If column A has the data as shown below, the formula returns the ...

**0**

votes

**1**answer

29 views

### What function should I use in Excel for searching multiple cells for a reoccurring words?

For example:
baby
house
empty
people
people
pram
pram
pram
should return:
1
1
1
1
0
1
0
0
so pretty much it should only return 1 if the word is a novel word ...

**0**

votes

**2**answers

1k views

### Graphing a scatter plot or line graph with Mac Excel

I have the following data:
Subject Avg Calorie Intake Avg Min in MVPA
41 908.79 25
21 1050.43 23.33
15 2956.33 ...

**2**

votes

**2**answers

287 views

### Fill every combination of three ranges in ascending order with Excel

I have three ranges, and I would like to fill every combination in ascending order with Excel. The ranges are:
Power: 2-30 (increment by 1)
ON Time: 100-10000 (increment by 100)
OFF time: 100-10000 (...

**1**

vote

**2**answers

93 views

### How do I write this complex IF formula in Excel 2010

Cell:
E13 is a YES or NO,
E14 is a number,
L21 is a currency amount equal to E14*1 BUT;
If cell E13 is YES, then cell L21 cannot be any higher than $80.00;
If cell E13 is NO, then cell L21 ...

**16**

votes

**2**answers

3k views

### What does ALT+F+C+N do, and how to undo it?

I was trying to figure out how to copy/paste a forumla without changing the references, and I found on a forum board post that someone said "Copy the cell, then do ALT+F+C+N".
I tried this without ...

**1**

vote

**1**answer

75 views

### Export from Access to Excel, Bosnian char š not showing completely

I hope this is the right StackExchange forum for my question. I need to export a table from Access to Excel. It has all sorts of special characters in it. Ranging from é, à, ù to ß and finally š.
...

**0**

votes

**1**answer

2k views

### Use 'if' to check a condition. If condition is not met, then do not change the value in the cell. Keep the previous value as it is

Cell B1 has value 1
Cell B2 has value 1
Cell B10 has no value.
I write 'if' formula: B10 = if(b2=b1, b2,)
The value in B10 changes to 1.
Now, I change B2 value to 2.
The cell B10 changes to 0. (...

**0**

votes

**1**answer

38 views

### how to create a break in text and put in different cells

How do I create breaks in a long line of text?
I need the text to be in different cells (currently all in one with no breaks)
Example:
AU654AU789AU321AU544 needs to be split into different cells:
...

**-1**

votes

**1**answer

96 views

### excel reference- VLOOKUP formula error

VLOOKUP is great except every time i try to input the formula, i get an error message, "you may not use references to other worksheets or workbooks for calculated column criteria" anyone know how to ...

**0**

votes

**0**answers

62 views

### Excel 2010 partial cell formatting being prevented

I have a workbook that prevents me from doing partial cell formatting, it's not running in compatibility mode and I can't see any protection or anything. The cell in question is formatted text and ...

**2**

votes

**1**answer

4k views

### Excel array formulas to find smallest date with multiple criteria

The array formula I have will give me the smallest date from a Service table, based on the following criteria:
1) The value in the item column matches the item # in cell A1
2) The value in the ...

**1**

vote

**1**answer

198 views

### Numeric error in Excel with parentheses?

I have been able to produce a very simple and challenging numeric calculation error in Excel, am curious as to the reason and perhaps a solution to it:
| A | B |
-------------...

**1**

vote

**1**answer

145 views

### Excel reference - connecting a list to a database

I am trying to create a database. I have 2 columns, if I enter a number in the first column,
the matching name should appear in the second column automatically. The list of numbers and names is on a ...

**3**

votes

**1**answer

264 views

### How can I permanently remove hyperlinks to other spreadsheets in excel?

I have a huge spreadsheet, after some copying and pasting from other documents I see the warning that there is a hyperlink to another spreadsheet on every time i open the file. While this does no ...

**0**

votes

**3**answers

861 views

### Excel IF formula not working

I'm trying the following excel formula, I need cell C4 on my sheet to return the value 0 because A4 does equal B3. Here is what I've tried:
=IF(A4='Weekly Input Data'!B$3:B$4,0,1) and it's returning ...

**6**

votes

**2**answers

3k views

### How to convert embedded excel sheet to word table?

We receive word documents from clients that will sometime contains Embedded Excel Object(sheet) and we need to convert them to word table so that we can then import the documents in InDesign properly.
...

**0**

votes

**1**answer

1k views

### How to create a formula that can count values across multiple columns in specified rows

I have an Excel sheet where I have multiple tasks and multiple products. Each task for each product is rated red. amber or green depending on progress so far. Each task also has an owner.
I want to ...

**0**

votes

**3**answers

109 views

### Excel formula with multiple conditions

I want to tell certain combinations of genes that make bacteria species.
So:
sample number, gene A, gene B, gene C.
The formula should be:
If all 3 are negative then it is a rest group
If A and ...

**-1**

votes

**1**answer

2k views

### Alphanumeric cell format (using custom format)

I want to display an alphanumeric code in this format:
A/DDDDD/DDDD
Where A is letter and D is digit. If there are less digits, a leading 0 should be displayed.
Example:
W/1/1 displays: W/00001/...

**1**

vote

**1**answer

113 views

### If column A match, replace all other column of row

Here I have a sheet
__A_B_C_D_E_F_G_H_I_J_
1_A___________________
2_B___________________
3_C___________________
4_D___________________
5_E___________________
6_c_1_________4_______
...