The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

10 views

### Comparing two strings in excel, add value for common variables

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains ...

**0**

votes

**0**answers

11 views

### Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data:
-0.0892 8
-0.0711 16
-0.0529 19
-0.0348 13
-0.0166 5
0.0015 12
0.0197 5
0.0378 5
0.0560 3
0.0741 4
0.0923 5
0.1104 1
I would like to add a ...

**0**

votes

**2**answers

28 views

### SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for.
On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...

**1**

vote

**1**answer

13 views

### Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...

**0**

votes

**1**answer

12 views

### Nvidia How to display particular workbook of Excel file on TV and no matter what i do on the computer the TV displays the workbook

Basically i have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when i work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I ...

**0**

votes

**1**answer

10 views

### Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...

**0**

votes

**1**answer

15 views

### Named ranges changing randomly in Excel 2010

I'm trying to create some named ranges in Excel that extend using the offset function based on the number of non-empty cells in a column, with the general formula:
...

**1**

vote

**0**answers

20 views

### What can slow down Excel in copying worksheets, but doesn't slow down general responsiveness?

I've got a fairly complex workbook that I'm building, and it looks like it's going to need a number of the sheets copied 10-20 times over - where each copy operation takes ~45s at the moment (over ...

**0**

votes

**2**answers

19 views

### Excel 2010 Data Connection - Add Filter to Command Text

Two relevant workbooks:
Historical Data.xlsx with a table GLDATA, which includes a field cc
Template.xlsx with a named range COSTCENTER
Question: How do I modify the Command Text in the Data ...

**0**

votes

**1**answer

18 views

### Excel 2010- Document Contents Not Scrolling with Scrollbar

For some reason on a couple of computers, Excel 2010 is having issue with the scrollbar.
When the vertical scrollbar is dragged, the contents of the page do not follow (for example, as they do in a ...

**1**

vote

**0**answers

18 views

### Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following:
48.8
4.19
(0.36)
4.52%
and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...

**2**

votes

**1**answer

19 views

### Create a linear trend line in Excel graphs with logarithmic scale

I I have an Excel scatter chart with x and y values.
I set the logarithmic scale in x-axis and y-axis.
When I add a linear trend line to the graph, the line is not linear but appears like a curve.
...

**0**

votes

**0**answers

12 views

### Formatting of entire column based on the grand total using color scale?

This might be answered somewhere else, but I haven't been able to find a solution to this. The question is how to use color scale for entire column just based on grand total.
I have attached the ...

**0**

votes

**0**answers

8 views

### How to get cells to default to zero or calculate additonal fees, based on selection from a drop-down list

I am building a Pay Rate Calculator worksheet with a Flat/Base pay rate & numerous Overtime pay rates. I would like to be able to have the "Overtime" pay rate cells to change depending on my ...

**0**

votes

**2**answers

23 views

### Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value

I have rows of possible duplicate employee ID #'s, with another column of different values for the same person. I need a single column of unique ID's with the certifications transposed in the same ...

**0**

votes

**1**answer

21 views

### Excel: how to link cell from one sheet to another

could you please, help me?
i would like to find out how to do this:
i have a sheet 1: with columns: number, name, color.
i would like on sheet 2 to have 3 cells, where after entering the number, two ...

**0**

votes

**1**answer

24 views

### Excel 2010 vlookup formula - Using variable table array as input

I been trying to find out if its possible to automatically expand the table_array on this VLOOKUP formula:
=VLOOKUP(B2,Sheet2!$F$4:$G$965,2,FALSE)
I'm calling the values from Sheet2 to add into a ...

**0**

votes

**0**answers

24 views

### Plot 3 y axis in excel

I'm trying to plot three axes on the same graph. My data headings are: date/time (x axis), water level, temp, trout up, trout down.
I've seen examples where this is possible but don't know how to do ...

**-1**

votes

**1**answer

24 views

### Excel: Averaging Sensor Data by Time Stamp

I have a device that collects temperature measurements from several sensors at discreet time intervals. This data is dumped into a .csv file with each row formatted as: [time] [sensor name] ...

**0**

votes

**2**answers

31 views

### How to automatically select a non-consecutive range of rows/columns

I have an Excel document in which I want to select a few hundred rows (not necessarily consecutive), in order to then copy them into another document (which will incidentally serve as a source ...

**0**

votes

**1**answer

21 views

### Why won't this Excel autoformat work: =“$G5<max(I5:AB5)”

I want to make the cell change color when any one of a range of cells is greater than its valve. This seems like pretty simple code to me, but when I test it out, the cell doesn't change color. It ...

**0**

votes

**2**answers

26 views

### Excel: Random select within table that meets two criteria

Here is an example of my data:
Name: Office: Years:
John Smith Canada 1
Bob Smith Canada 1
Jake Smith Canada 1
Sarah Smith Canada 1
On another sheet I want ...

**0**

votes

**1**answer

24 views

### Conditional formatting

What I am looking to do is have a conditional format set up so that if row G contains the value "In progress" "With 3rd Party" or "Identifying" and row H, J or K contain no value then highlight rows A ...

**0**

votes

**0**answers

18 views

### Excel 2010, how to show percentage values on clustered columns chart?

I was looking for a better way to do this but no luck googling. My problem is about showing numeric values and percentage value in clustered column chart. When I use pie chart, there is an option to ...

**0**

votes

**2**answers

13 views

### IF Function on excel - i need to put a formula into one cell using to < < however it isnt working

I need to put in one cell that IF the value of H3 and F3 is lower that 25000 but higher than 0 it will equal 29.95, if false 0
the formula
=if(0

**0**

votes

**2**answers

19 views

### Formula on one sheet using indirect reference to contents of a cell on another sheet returning #VALUE

Excel 2010. Formula on Sheet1: =COUNTIF($D$9:INDIRECT($D$7),"qa") returns the count of cells that contain the text qa in range $D$9 through whichever cell is referenced in cell &D$7.
However, ...

**-1**

votes

**0**answers

10 views

### Excel 2010 SlopeA Function [on hold]

Addin or create a SLOPEA function that works like the AVERAGEA function treating text cells as a 0 value. I need either a link to getting the addin or the VBA code for creating the function.

**0**

votes

**1**answer

54 views

### Excel Formula: An Array formula containing VLOOKUP, SMALL, IF, OR

I am trying to create a formula that considers the data from three columns Y, H and V on my tab titled 'Data', returning the smallest value in A that meets that condition, once found Vlookup that ...

**-2**

votes

**0**answers

22 views

### Excel formula to copy text from another sheet in other cels

Hello I have this situation.
In sheet 1 I have rows a1, b1, c1, d1 and pasting them to sheet2 (sh1)a1 into e8 then (sh1)b1 into e10 then (sh1)c1 to e12 and (sh1)d1 to d22.
Then from sheet2 I wont to ...

**1**

vote

**1**answer

20 views

### Transferring custom excel ribbons in local computer to other computers in Excel 2010

I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons.
I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to ...

**0**

votes

**1**answer

45 views

### Merging multiple excel files in to one file

This is my macro for merging all the files in one directory to one excel sheet. I am unable to find why its not working as per expectation. I have thousand rows in each file. It copies 1000 rows from ...

**0**

votes

**0**answers

5 views

### Update data from external link

I have a dropdown menu to select a month and then all the sheet updates with the correct data. However, I have a few cells that don't update and I noticed that those are using data in a closed ...

**1**

vote

**1**answer

17 views

### Using column data from another worksheet

I have a worksheet with one column and that has a list of my company names and what I want to do is be able to create a stats worksheet where I can use those company names without changing both ...

**0**

votes

**1**answer

27 views

### Excel 2010 offset function returns #VALUE! error

I'm trying to use the offset function in excel 2010, but it gives me a #VALUE! error.
The function works perfectly, if it's like this:
...

**2**

votes

**1**answer

32 views

### How do I see the current filter being applied in Excel?

I received an Excel document with a filter already applied. The header row does not show the dropdown buttons. RIght now I can uncheck the filter to see the entire dataset, and then hit undo to go ...

**0**

votes

**0**answers

24 views

### Go to first non-negative cell in a row and divide by another cell

I'm looking to have Excel calculate the financial payback period for me.
In words, I'm trying to count and return the first non-negative number in a row and divide that value by a corresponding cell.
...

**1**

vote

**0**answers

19 views

### Freezing a header row until another header scrolls on screen

Is there a way for a row functioning as a header to freeze, but then be replaced by another header row as it scrolls on to screen?
In my example I've got a section called "Benefits", then about 20 ...

**0**

votes

**1**answer

35 views

### Sorting Survey Data in Excel

My knowledge of Excel is very limited, and I'm hoping for some guidance as to the best approach I need to tackle the challenge I outline below…
I have an Excel file that is full of data from a ...

**0**

votes

**1**answer

23 views

### Excel: Can't set user-specific editable ranges in protected sheet

I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want ...

**0**

votes

**0**answers

30 views

### Excel 2010 Compile Data from Multiple Worksheets into Summary Spreadsheet

I've compile a structural steel and architectural finishes material take off for an industrial building.
I simply tallied the quantity of each length of each shape on a sheet corresponding to each ...

**1**

vote

**1**answer

29 views

### Automatically “comment out” formula in Excel?

So I have this result set in MS SQL Management Studio. And I have an Excel sheet. I copy and paste data from MSSMS to Excel. As far as good.
Now, some of the fields start with an equals sign. Excel ...

**0**

votes

**0**answers

21 views

### Reference a very large pivot table, multiple time, with complex formulas

I would like to use the data from a big pivot table I created to do more complex computation and pivot tables. I know I can reference a cell within my pivot table using the GETPIVOTDATA function, but ...

**-2**

votes

**0**answers

18 views

### Adding button to Excel VB

I need help with the Excel spreadsheet.
When I click "Add Commodity" on the left hand-side I want it to show exactly those activities described on the sheet:

**-2**

votes

**0**answers

21 views

### Deleting rows based on text?

I have a spreadsheet which is giving me a particular problem. Not sure from what angle to attack it from.
In Excel 2010 I have 14 Columns by ~25,000 rows. The problem in question is that the 1st ...

**0**

votes

**2**answers

32 views

### How to add minutes in a column?

I have a call activity .csv file downloaded from my vonage account and I wanted to add up all the minutes in a column. I know how to add numbers but not sure how can I do it for minutes.
Date/Time ...

**1**

vote

**1**answer

38 views

### Excel chart colours

In Microsoft Excel 2010, when I insert a chart with multiple data series (or a pie chart), each series (or slice) is automatically given a colour. My 2 questions are:
What is the formula used to ...

**0**

votes

**1**answer

23 views

### excel text to specific cell

so i have this problem i want to get a specific cell from text i mean that
i have made a table 1,2,3... A,B,C,....
i made a vlookup to search for specific letter in number so if i press 1 in a A3 it ...

**0**

votes

**1**answer

23 views

### how to create a YES NO notification for time?

I have a formula that shows hours and minutes of how long it took to notify a client. I need to create another cell to say YES if that notification is 4 hours or longer.
I currently have the formula ...

**0**

votes

**0**answers

12 views

### restore MySQL Excel add-in

In a really bone-headed move I was trying to add an add-in to Excel 2010 and accidentally REMOVED the MySQL add-in (The remove button doesn't ask for confirmation). I tried to browse to the MYSQL ...

**0**

votes

**1**answer

14 views

### Exponential increase

I need to calculate the exponential growth, I think, of 0 to 60 with a distance of 340mm between them. the growth is not linear but starts small and then increases as it moves to the 60 mark. How do I ...