Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
523 views

Excel summing named range

I have a workbook with many sheets in it. I want to sum column C2:C50 on each sheet. However, in the future I anticipate having to sum the range C2:C?, and rather than have to go into each sheet to ...
0
votes
1answer
491 views

Ignore “[Value_if_false]” when value is true

In Excel, I am using an IF function and using the OFFSET function to assign a value in the [value_if_true] and using a 0 for the [value_if_false]. The true OFFSET function was occasionally returning ...
0
votes
0answers
19 views

Printing a Multiple Page Sheet on Excel [duplicate]

How do I make the margins non existent when I print my sheets? I need there to be no margins so when taped together the sheets continue to the next with no space.
0
votes
0answers
46 views

Excel Printing Budget

I am trying to print an 5 page across/4 pages down sheet. The whole reports needs to be running smoothly together so when I tape them all together it is one continuous sheet. I have tried cutting the ...
2
votes
1answer
36 views

Excel 2007 nested function “if, then”

I keep getting a message that I have too many arguments. I am trying to ask: If value 1 = x, then value 2; otherwise value 3. BUT if value 3 = 0, then blank. It doesn't like: ...
0
votes
1answer
59 views

Excel users all have different colours

I have a workbook shared by a number of users (it is in fact a dreaded shared-workbook). Depending on who saved it, the background colours seem to shift. What was green when I save it, may be a ...
0
votes
1answer
202 views

Excel - Using condtional formatting in a count down of the date

So i am using Excel Mac 2008, i want a formula where i enter a date and if the date is less than 5 days from today, it turns bold and red. can anyone help me figure this out? I have a formula that ...
1
vote
1answer
41 views

Scoping a macro to current row

Brand new to VBA in Excel coming from HTML forms world and trying to understand how excel expects me to approach a task that, if i work working with an HTML table I'd say: Each row in my table has ...
1
vote
1answer
77 views

MS Excel 2007 If Then Formula Troubles

This is a simplified case of an issue that I am seeing using MS Excel 2007. Format your sheet to be currency with 2 decimal places. Cell A1 type 25 Cell A2 type 20.13 Cell A3 type ...
0
votes
1answer
52 views

I'm having trouble with macros in Excel

I am having trouble with a macro I recorded in excel. What I want it to do is start where my selection is and Ctrl + Right Arrow to select all of the stuff in the row. I then want to copy it to ...
1
vote
1answer
66 views

Identiying repeating digits in Excel cell

I have a list of phone numbers in excel, some of which are obviously duds because they contain repeating digits like this '5555555'. Is there any easy way of identifying these? Its Excel 2010.
1
vote
1answer
549 views

Pull Data from Excel Worksheet to Another Based on Defined Values

I have two excel worksheets which have data cells. I want that if a cell in column J equals a certain value, let's saying "Negotiating", then it automatically pulls that row to a new worksheet. The ...
3
votes
3answers
385 views

What software can I use to edit CSV files?

What software can be used for editing CSV files? Notepad is gonna work smoothly? I have been using MS Excel but now I have this issue. When I put date like this: 090913 whcih represents 9th of Sept. ...
1
vote
1answer
82 views

Excel does not accept custom cell format for cents

I have a spreadsheet containing cent amounts, and I am trying to format the amounts such that the last two zeroes are separated from the rest of the figure by a space, and from then on thousands are ...
4
votes
1answer
350 views

Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells? For example I wish to conditionally format a cell such that its color is: Green to Blue graded scale for ...
0
votes
1answer
67 views

Conditional formatting duplicates for highlighted cells

I would like to conditionally highlight cells in a row. When the items in column B are duplicates then cells in columns B and C should be highlighted. The value 7264 in column B has duplicates so ...
0
votes
0answers
32 views

Create histogram with column times another column

I am trying to create a histogram where one column has amount of days and another column has miles per day. I want to have a histogram where the x-axis is miles per day and the y-axis is days at that ...
-1
votes
1answer
30 views

using date ranges and numbers

I have a spreadsheet that uses both dates and numbers. For example I have a job that takes 4 hours to complete and needs to be done on 10/11/13. I have several jobs that end on this date but the time ...
1
vote
1answer
5k views

Automatic copy rows with matched column to other worksheet

Now I have a worksheet named sheet1 like the left side of image I want to automatic copy all rows of sheet1 that have the column C = NO to worksheet sheet2 like the right side of image. And each ...
0
votes
1answer
207 views

Stop Excel wrapping values that contain carriage returns with double quotes

I have an Excel spreadsheet that contains various rows of data (some which contain carriage returns) and a cell at the end of each row that uses a formula to generate a JSON string. However, a problem ...
2
votes
1answer
482 views

What do the different ping statuses returned by VBS scripts mean?

I have a VBS Script that executes this code strQuery = "SELECT * FROM Win32_PingStatus WHERE Address = '" & Cell & "'" Cell - is the Excel cell with the hostname Some of my results are ...
0
votes
1answer
887 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
53 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
605 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 ...
0
votes
0answers
31 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
2k 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
713 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
638 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
51 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
88 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
46 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
53 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 ...
1
vote
0answers
27 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
351 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
81 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
402 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
636 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
4k 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
138 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
2
votes
1answer
49 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
93 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
764 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
1k 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
164 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
137 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
44 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
371 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
135 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 ...
3
votes
1answer
13k 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
109 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 ...