**0**

votes

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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