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)

0
votes
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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_______ ...