The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
12 views

Calculate Break Point Weight

I have a table like so: Miles Weight Rate 50 1710 54 50 3417 44 50 7253 38 50 12025 36 50 16052 35 100 1716 55 100 3429 45 100 7269 39 100 12027 37 100 16055 36 Where ...
0
votes
1answer
11 views

AVERAGEIF based on formatting

I am using Microsoft Excel 2010. I would like to do an AVERAGEIF, with the criteria based on formatting. Ex: For cells, I choose A1-A3. A1 is the percentage value 10%. A2 is the number value 20. ...
0
votes
1answer
12 views

Excel 2010 Formula: Finding a dynamic column based on string value, then count # of “0's” within that column

I have tried looking at many different potential avenues at solving this; INDEX, MATCH, DCOUNT, HLOOKUP with INDEX & MATCH, COUNTIF with INDEX & MATCH. What I'm looking for is a way to set the ...
0
votes
2answers
17 views

Excel COUNTIF range search returning #N/A

I'm using Excel to search multiple days (my ranges) in a timesheet for hours worked (my HLOOKUP reads the value below the dept number) by multiple members of staff for different departments. I've ...
0
votes
1answer
15 views

Make excel assume that I want to open my xlstart file readonly

I have a workbook called Book1.xlsx in my XLSTART folder. Is there a way to tell excel that I want it to always open this file as readonly unless I specify otherwise? There are two reasons I want ...
0
votes
3answers
14 views

Excel - How to merge rows from 2 tables based on a common column?

I am trying to merge 2 worksheets where only one col matches in content. Column"A" in both worksheets have matching values but all other fields are different. Worksheet1 Col"A" colb colc cold ...
0
votes
0answers
29 views

How do I make a function update dynamically when I make changes to the function in a “master” cell?

For example, column 1 would contain input data, and subsequent columns would perform actions on that data. Row 1 would be the master row. All changes to the formulas in row 1 would be duplicated ...
0
votes
2answers
22 views

How can I find max value for a text as unique identifier in Excel?

This is basically for an auction setup in Google spreadsheet. Say there are 26 bidders A to Z and each bid 5 times with different values. I need to find the max value bid by each of them and display ...
0
votes
0answers
14 views

How to partition data from one sheet to four others based on criteria?

I've one "master" sheet in the Excel 2010 file with all my outstanding orders detail and also reflecting how many days the orders have been outstanding. I've 4 other sheets, I'd like to extract the ...
2
votes
3answers
29 views

Group unique elements within a time interval in Excel 2010

I have some data as such: User Date 001 1/1/2000 002 1/25/2000 003 2/2/2005 004 2/5/2005 005 12/24/2008 I would like to find out, in each month, how many unique ...
-1
votes
2answers
33 views

Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item. Here is the data table: Date Item Quantity Operator 01/01/2014 Item1 3 John 01/01/2014 Item2 5 ...
0
votes
1answer
22 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
0
votes
0answers
10 views

Why some columns (fields) dissapear when I import a Power Query connection into PowerPivot on Excel 2010?

I have a Power Query connection set up in Excel 2010 that is NOT loaded into a worksheet (messy) or a data model (only for Excel 2013). Upon entering PowerPivot, I go to 'Existing Connections' and ...
0
votes
0answers
22 views

Locking / Hiding cells in Excel containing tables and formula

I have an Excel spreadsheet with Table in it. As we know, the cells contained in the table column are updated automatically based on the formula in the first cell in a given column by virtue of ...
0
votes
1answer
36 views

Populate default value to a cell based on another cell content

We use a spreadsheet as our time cards. The template is stored in a server with links to it on the individual's desktops. I am trying to figure out VB code that would help in achieving the flliwing: ...
0
votes
1answer
22 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
0answers
18 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
2answers
39 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
1answer
14 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
1answer
19 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
1answer
18 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
0answers
21 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
2answers
24 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
1answer
21 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
0answers
19 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
1answer
25 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
0answers
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
0answers
10 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 ...
1
vote
2answers
27 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
1answer
23 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
1answer
30 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
0answers
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
1answer
25 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
2answers
33 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
1answer
22 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
2answers
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
1answer
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
0answers
25 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
2answers
14 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
2answers
21 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
0answers
10 views

Excel 2010 SlopeA Function [closed]

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
1answer
58 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
0answers
23 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
1answer
23 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
1answer
47 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
0answers
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
1answer
18 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
1answer
29 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
1answer
34 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
0answers
26 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. ...