The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**2**answers

28 views

### Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...

**0**

votes

**1**answer

11 views

### Excel chart with a single x-axis but two different ranges (combining horizontal clustered bar and horizontal stacked bar), possible?

I am new here. I have a data set of density values (phytoplankton community) according to depth and the composition of it in percentage. I want to ask if it is possible to construct the density values ...

**1**

vote

**1**answer

12 views

### Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

**2**

votes

**1**answer

32 views

### Excel 2010 Pivot Formatting - Can't indent and wrap fields?

When working with pivot tables in Excel 2010, I want to show my pivot in compact form, with each field being indented as you move through the data, like so:
However, some of my data strings are ...

**0**

votes

**2**answers

23 views

### Find last instance of a character in string and keep anything that comes before

I have the following data and I need to get rid of the numbers. This means I will have to find that last occurence of the character " " and keep everything that comes before however I dont know how to ...

**0**

votes

**2**answers

20 views

### Excel 2010 - how to prepend a “0” to make an 8 digit number 9 digits

I'm running Excel 2010 using a output file from our database software that exports a list of our affiliate stores. The affiliate stores have a 9 digit code and a number of these codes start with "0".
...

**0**

votes

**1**answer

16 views

### Excel - Quickly Charting Frequency of Event To IP Address Over Time

Warning: Keywords and tricky phrases may not be correctly being used here. I'm not extremely knowlegable about the terms used with Microsoft Excel so I'm using my best guess.
I'm failing to find a ...

**0**

votes

**1**answer

18 views

### Linking files on a network drive

have two excels files on a network drive. Linked file path: Z:\A\ABC\a.xlsx Source file: Z:A\b.xlsx The link from source to linked cell is by clicking the appropriate reference cell in source. For ...

**1**

vote

**1**answer

29 views

### How do I create a dynamically-growing graph which ignores empty tail cells?

I have a table on an Excel 2010 Worksheet 'Consolidated Data' where:
Column A is filled with arbitrary dates sorted by increasing age
Column F has numeric data relevant to this question
Row 1 is the ...

**0**

votes

**1**answer

13 views

### Extracting multiple numerical values from mixed characters in excel worksheet

I have a column containing cells with two numerical values, separated by an asterix...
e.g. 12.5*3.4
How can i extract the smaller number of the two into one new column, and the larger of the two ...

**0**

votes

**1**answer

21 views

### Control CSV import in excel 2010 [duplicate]

I have a csv with values like this:
"a very long value, with a comma","387621937291732193"
The number, despite being enclosed in quotes gets turned into a number in excel and shows up in scientific ...

**0**

votes

**1**answer

18 views

### COUNTIFS using AND / OR

I need to count the number of records where any one of several conditions could be met in column G but a specific condition must be met in column I.
For example, column G could be either "Toyota" or ...

**0**

votes

**1**answer

19 views

### Finding the right formula

I have a spreadsheet set up and used by one of my contractors, there is certain data that I need pulled from it, ie: the number of people per craft. Said spreadsheet is used for contractors payroll ...

**0**

votes

**2**answers

29 views

### Graphing patient data, multiple dates, multiple patients

In Excel, is there a way to graph multiple series from one column of data? I have lab values for patients. Column A is date, column B is patient identifier, and column C contains all the lab values. ...

**0**

votes

**2**answers

28 views

### Cannot delete created excel table

I have created an excel table. However, I now want to delete or change it because my range changed.
However I can't delete it in the excel Name Manager:
Any suggestion why I cannot delete it?
...

**1**

vote

**2**answers

21 views

### How can I stop Excel From Updating Links When Copy and Pasting Cells Linked to Other Workbooks?

Summary of the problem: I would like excel NOT to link to the spreadsheets links I'm copy and pasting until I have the entire spreadsheet setup.
Overview: I have a worksheet that acts to aggregate a ...

**1**

vote

**1**answer

34 views

### When pasting, how can I ignore hidden columns in the destination range?

I have two worksheets s1 and s2.
Data on s1 looks like:
+---+-----------+--------+------+
| | A | B | C |
+---+-----------+--------+------+
| 1 | scarecrow | tinman | lion |
...

**0**

votes

**2**answers

26 views

### Excel: DD/MM/YYYY stored as text…need to convert to Date format

I have a slight problem. It would be easier to post an image but I can't because I don't have 10 reputation. Anyway I have a column with the heading "Birth Date", and dates entered in DD/MM/YYYY ...

**2**

votes

**0**answers

38 views

### Automatic scatter plot in Excel 2010

I have two quite large data sets of which I want to plot every line in one plot.
The pattern is the following:
x-axis: Set one (Colonne 1-6)
y-axis: Set two (Colonne 1-6)
Now I want such a plot for ...

**0**

votes

**1**answer

20 views

### How to load above 2 million data from SQL Server to CSV/Excel using SSIS 2008R2 package?

How to load above 2 million data from SQL Server to CSV/Excel using SSIS 2008R2 package?
The Package needs to create new excel/csv file automatically once the first file is filled with maximum number ...

**1**

vote

**2**answers

51 views

### Excel Lookup adds double quotes to string

I'm using this formula to get value form a table
=LOOKUP(C11;Alias[A];Alias[B])
where C11 = 12354567
But when I use
=LOOKUP(LEFT(C11,7);Alias[A];Alias[B])
where C11 = 12345678, the formula does ...

**1**

vote

**3**answers

28 views

### Replace Alphabet with Number

Is it possible I write A and excel count it as 5,and on the same cell I write B and excel count it 4, all the way through to F (where F = 0).
Actually at the end I want to add the numeric values.
...

**0**

votes

**1**answer

36 views

### Compare two spreadsheets in a workbook, find the differences and record the differences on the first spreadsheet

I need a way to compare two spreadsheets in a workbook, find the differences, then write those differences on the spreadsheet in sequential order in the same column below the existing numbers.
Sheet1 ...

**1**

vote

**2**answers

46 views

### Using Excel to make a grid in millimeters

Trying to figure out a way to make a grid in Excel that will print out in with spacing of mm's. Haven't figured out a way to do this yet though.
I'm doing some work with Nanoblocks (which a single ...

**1**

vote

**0**answers

29 views

### How to add custom columns to Pivot Table (similar to Grand Total)?

I have data which I pivot as Row Labels and Column Labels which gives me something like this:
And what I would like to do is add columns like Grand Total (i.e. which applies to all columns as a ...

**0**

votes

**1**answer

36 views

### How does Excel handle the h:mm:ss format?

I have the number 0.00082788917980126 which once converted to h:mm:ss format gives me 0:01:12, and I need to understand how as I need to perform similar formatting outside Excel, hence my question:
...

**0**

votes

**1**answer

32 views

### Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank.
But when I use this defined name in another cell, the second ...

**0**

votes

**1**answer

15 views

### Nesting multiple IFERRORS with Index and Match

I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a
Current ...

**1**

vote

**2**answers

37 views

### Align Secondary Axis Origin with Primary

I am interested in aligning my secondary axis such that it lines up exactly with my primary axis.
To be more clear, I want the origins to both line up at 0 at the same place, each preserving their ...

**1**

vote

**2**answers

27 views

### Simple, Excel, =LOOKUP(xxxxx), not returning the correct value

OK this is infuriating as I know this should work...
I have certain traits in column A. Each trait has a corresponding value in column B and a numeric indicator of that value in column C. Like ...

**0**

votes

**1**answer

11 views

### Format Changing when copy into email Excel + Outlook

Okay this is starting to confuse me a lot, when I copy my excel spreadsheet into an email in outlook, (not attaching just selecting all cells with values) the cells in the side table change to some ...

**0**

votes

**1**answer

21 views

### Excel, how to subtract time to span before midnight

I am trying to subtract hours to a time that is close to midnight, but excel is outputting all hash (#) symbols complaining of the operation.
Adding time is easy and possible, as described by this ...

**2**

votes

**1**answer

41 views

### How to Make a PivotTable out of “hierarchical” Excel spreadsheet data

I would like to create a PivotTable out of "hierarchical" data contained in an Excel 2010 worksheet. The data is hierarchical in the sense of a parent/child relationship in a database where, ...

**0**

votes

**1**answer

43 views

### Excel: How to clear all renamed PivotTable labels

When using PivotTables in Excel, it's often useful to overtype certain PivotTable labels with new names.
If you have a long list of items you've relabelled, it can be easy to lose track of what the ...

**2**

votes

**2**answers

30 views

### Referencing a blank cell - should act like a blank cell

I have a spreadsheet that referencing a blank cell on another tab. I use the iif(isblank(thatcell),"",thatcell). This works fine, until I use that cell to calculate. When I include that cell to ...

**0**

votes

**0**answers

18 views

### Convert OO4 ODS to XLSX using Excel 2010 VBA

I am trying to bulk convert OpenOffice documents to Microsoft Office. Using built-in VBA, I use the following code (ODS to XLSX is shown, but same code is being used for ODT and ODP with some ...

**1**

vote

**1**answer

30 views

### Find the last data entered in rows in Microsoft Excel 2010

I have a spreadsheet of clients in column A and each week along the top row. When a client attends I put a corresponding "1" in the week they attended.
I would like to insert a column that finds the ...

**0**

votes

**1**answer

27 views

### Nesting the IF Function in Excel when there may be #Value! errors in the target cell

I'm trying to get some help to change a formula:
=IF(S4>8000,3,IF(S4>6000,2,IF(S4>4000,1,IF(S4<4000,0))))
So that it returns a value of 1.5 if the target cell contains an error value. ...

**-1**

votes

**0**answers

13 views

### Create a text box in Excel 2010 that will appear when you selected the box

How can you create a box what you can switch on and off and when you switch it on a text box appears to place a comment in the box?

**0**

votes

**3**answers

37 views

### In Excel replacing a column with another column

I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...

**-1**

votes

**1**answer

19 views

### Format of Row in VBA based on 1stCell and also Compare to above row?

I was wondering how would i through VBA conditionally format the whole row or a row in a range based on the first cell in that row? Also it would require a comparison to the previous row to current ...

**1**

vote

**3**answers

49 views

### In Excel, how do you do custom number formatting so that it has leading blank spaces?

I need to use custom number formatting or something similar that will create real blank spaces to achieve this because I am actually using a library that implements Excel functionality called ...

**1**

vote

**1**answer

45 views

### Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...

**1**

vote

**1**answer

113 views

### How do you reverse the sign of a range of numbers in Excel?

In accounting I sometimes download statements where although the transaction represents debit, the sign is negative.
I then need to change the sign to be positive so it's actually indicating a true ...

**0**

votes

**0**answers

22 views

### Excel 2010 SUMPRODUCT with multiple conditions

I have three columns A=Date, B=Region, C=Qty. I need to identify the Qty in the GR region between two dates.
I have tried this formula with no success:
$B$3=Beginning date,
$C$3=Ending date
...

**3**

votes

**1**answer

87 views

### How can I have automatically updating copies of charts?

I have been doing some more complex work with Excel (different tabs/worksheets, etc.).
Now I have some charts from one worksheet that I'd like to kind of embed in the other worksheets for the purpose ...

**0**

votes

**1**answer

40 views

### VBA macros “deleted” after closing excel file

I know, the topic sounds very strange, but yesterday I worked on an excel file with VBA all the day long. After saving the file to disk I went home and todays morning the makros are lost?!
Please ...

**0**

votes

**2**answers

28 views

### How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?

How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?
I also want to limit another range of cells to maximum 24 alpha and "-" ...

**0**

votes

**0**answers

9 views

### Max Scroll Values in Excel

I want to use a scroll bar in Excel with very large numbers but the max scroll value is only about 30,000. Can anyone let me know how to increase max scroll value to 100,000,000?
thanks

**0**

votes

**2**answers

35 views

### How to embed or link a text file in Excel?

I have a text file containing a memory dump from an embedded system, which I update after every run (the file is formatted in the Motorola SREC format, but this is not too important). I am using Excel ...