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
0answers
6 views

Fill formula right to end of row, without going to edge of worksheet

a quick Excel question. If I have a row with say 26 formulas in horizontally from say A1 to Z1, and then I move down to cell A2 and write a formula. Now I will to fill that formula right until cell ...
0
votes
2answers
10 views

Fill a large range with a formula in Excel, without mouse-dragging to extend

I have 5000 elements in column A and 5000 in column B I want the element wise difference and stored in column C. The subtraction command I know is =A1-B1 then drag all the way down with a mouse. ...
0
votes
0answers
5 views

How do I superimpose a conditional formated heatmap based on one set of values over a different set of values in Excel 2013

I would like one cell to be formatted with a gradient color based on the value in another cell. For example, I would like cells A1 and A2 to be highlighted based on the values in B1 and B2. If I ...
0
votes
0answers
15 views

If function in MS-Excel

=IF(F506>0,IF(F506-L506=0,0,IF((F506*0.05)>U506,(F506*0.05),U506)),IF(G506>5000,G506*0.05,0)) When the Value of F506-L506 is 0, its not returning 0, rather its returning the value U506. ...
-1
votes
1answer
11 views

Using multiple functions in one cell

I'm using Excel 2010 and I'm trying to do the following For IT Changes in different locations, I'm trying to find how many "successful" changes in "Lake Mary" The data is in the same file using ...
0
votes
1answer
9 views

Access Autofilter listing with VBA

How can I access the unique listing of values in the column that the autofilter displays with VBA? I already know how to turn the autofilters on and off with VBA. I can access filters that the user ...
1
vote
1answer
9 views

Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010. I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...
0
votes
0answers
16 views

Projecting Revenue in Excel

So we are building a spreadsheet to project sales and revenue. In our business, we sign a deal, we get implementation revenue the month after we sign the deal, then we get the recurring revenue for ...
0
votes
2answers
21 views

EXCEL VLOOKUP returning #NA when IF condition specifies “ ”

=IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]Big'!$B:$B,1,FALSE),"Project BIG",IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) ...
1
vote
1answer
39 views

Excel 2013, SUMIFS formula

I think I need to use a SUMIFS function for this but I am not positive. I have a list of codes: All of these codes are in a category of downtime, each code also has minutes 5,10,15,40,65 etc. My ...
1
vote
1answer
18 views

Lock color scale (convert to fixed)

I have used conditional formatting to apply a color scale to a range of values. Now I would like to permanently freeze those colors. I have poked around a bit, and can't find event the beginning of ...
0
votes
2answers
52 views

Excel: transforming an indexed sheet with many columns to two columns

I have an excel sheet with rows like this: Fruit | Apple | Banana | Grape | Peach Vegetable | Cabbage| Lettuce| Carrot| and would like a two column output duplicating the index (first column): ...
0
votes
1answer
12 views

Return first value from multiple columns that passes checks

I have some an array of columns of multiple statements of the same data, some meeting criteria I have set, some not. I wish to return the first (lefthand-most) value that fits my criteria. See below ...
0
votes
3answers
32 views

Excel: Check if date has a day

I have cells with dates in Excel. Some dates have dd-mm-yy (e.g. 20-01-15), others just have mm-yy (e.g. 01-15). I want to determine which cells have a day specified by the user. As far as I can ...
0
votes
0answers
11 views

Ranking observations by percentile, based on subgroups?

I have a spreadsheet with a column of data on company names, another column with the number of employees the company has, and another column that classifies the company by SIC code, like so: Company ...
0
votes
1answer
15 views

Split cells into two rows

I have this: and would like to split those three cells into two rows without affecting the rest of the spreadsheet. Something like this: But this was done by adding another row and then merging ...
0
votes
1answer
12 views

VBA - auto-populate date when data entered in cell

I have a tracking spreadsheet where I'd like the date a cell is completed to auto-populate in the next column. I found the following code which works for the first (I:I), but I'd like to add the same ...
-2
votes
1answer
20 views

Excel 2010 - possible to apply a function to an entire column?

In Excel 2010, is it possible to apply a function (not a formula) to an entire column (without dragging the plus symbol all the way to the bottom)?
-5
votes
0answers
36 views

find offset of max value, in spread sheet (excel) [on hold]

I have a loop of this kind of data points (listed below) in one column that I need to find the points to each of the peak then average them i.e. In the below data-set the max value is 0.80078125, and ...
1
vote
2answers
17 views

Count unique records with multiple conditions

I need to produce a table that outputs a count of unique ID's for each day for separate regions. That is, there are three conditions: Must match date; Must match region; Each ID is counted only ...
1
vote
1answer
25 views

Create a formula to find difference between values in regularly spaced rows

Lets say I have 100 rows in column A. That would be 100 cells with a value in each. I only want the value of the difference between every 5 cells. For example, in the first cell, A5-A1, then next cell ...
1
vote
1answer
18 views

Return array based on value of column in source array

I am attempting to obtain an array of only values that meet certain criteria. I have an array in which the meeting of these criteria is summarised in a column of TRUE/FALSE for each entry, as such ...
0
votes
0answers
11 views

Scatter plot combined with line chart

I am doing a compensation plot I need to make a line chart with 30 grades, each having a min and max.(low and high salary within that range) On top of that, I need to plot specific employees within ...
0
votes
1answer
29 views

Search table and combine rows with identical A and B columns and add their value in C column

I would like to search the entire table (1200+ rows) and combine rows where A AND B columns are identical, and add their C column values. If column A and column B are identical to any other rows, ...
0
votes
3answers
30 views

How do I reference an Excel sheet name in an Excel formula?

How do I reference an Excel sheet name in an Excel formula?
1
vote
2answers
8 views

Return number corresponding to entry within array in excel

I have a list of names and I wish to create a column next to this indicating what number of entry in the list every given name is. An example of what I am trying to achieve, the column entitled ...
0
votes
1answer
9 views

Transpose list of dates based on both ID and Category in Excel or Access 2010

I've got a very long list of three columns: ID, category and Date. The ID field is repeated for each different date, with a category of 1 to 3 assigned. I really need to get these into a form I can ...
0
votes
1answer
11 views

If/Then (# to Text) With Multiple Number Ranges

I am using Excel and trying to create a formula. Part of the formula works, the next doesn't. I'll explain. Column P is "BPM" (Beats Per Minute) and will have a numeric value, which will be entered ...
0
votes
1answer
10 views

Change pivot table layout into “more columns”

When I create a pivot table in excel 2010 my table looks like that: Any suggestions how to get this extra colume filled up with the names within a pivot table? Or do I need to use power pivot? How ...
0
votes
1answer
18 views

What is this drop down selection thing and how do I select an option from the keyboard?

I am using this .xlsx as a template and there are several cells like the one above which when selected a little box with a down arrow appears. When this box is clicked a list of options is ...
0
votes
0answers
21 views

how to replicate the chart on excel

right now i'm working on a excel chart. Long story short, i'm looking to replicate the following interest rate project charts. my question, how should i arrange my excel data in order to achieve a ...
0
votes
2answers
59 views

Count function in excel

I have a set of data looks like this: FALSE FALSE FALSE FALSE 1 <-- 1 1 1 FALSE FALSE FALSE FALSE 1 <-- 1 1 1 FALSE FALSE FALSE FALSE My question is how do I count the total of the ...
-1
votes
2answers
29 views

How to fill formula horizontally but increment cell references vertically

Is there a way to fill a formula across columns (i.e., horizontally) but have the cell references in the formula increment the row number instead of the column? I have a summary sheet that links to ...
0
votes
0answers
14 views

Excel pivot table grouping overlaps

I have a pivot table with salaries as rows and I'm trying to group them neatly together. However, when I try to group by increments of 5000 I get ranges like 0-5000, 5000-10000, and so on. This is ...
0
votes
1answer
28 views

trying to copy a formula skipping multiple rows

I would like to know how to copy a formula that skips a number of rows. For example, E40-E1, E80-E40, E120-E80, E160-E120, etc. Basically I only want the values every 40th row. I would run a macro to ...
-1
votes
1answer
16 views

Modifying Column Charts in Excel

I was wondering if someone might be able to help me figure out how to create a particular chart in excel. The rows are businesses and the columns are what percentage of people in area A and B that use ...
0
votes
0answers
8 views

Trickey Excel Hyperlink Copying

I have a spreadsheet with a large number of cells in Column F containing hyperlinks with display text different than the hyperlink location. I need to be able to copy the same hyperlinks to the ...
1
vote
1answer
14 views

How to properly highlight alternating rows after Filtering / Sorting?

I have this Excel sheet with about 2,000 rows of data : I've applied a handful of Filters on Comparison Result & Extension, then added a few Sorting parameters for all of the columns. If I ...
1
vote
1answer
21 views

How can I use if function in excel to count unique numbers which are not greater than given time duration

I'd like to ask something. I have bunch of transaction data containing date, time, ID like this: DATE //TIME //ID 7/6/2015 //9:30:22 //0266731550 7/6/2015 // 9:33:19 // ...
2
votes
2answers
49 views

How to do up a excel hair chart?

I'm trying to do up a chart (on excel), the chart that I have in mind is somewhat similar to the attached picture. Data: X-axis: dates (weekly data) Y-axis: interest rates Doing this, I can ...
0
votes
2answers
19 views

excel copy values of cell if particular cell in same row is not empty

i have column A with first and last name of a person, column B with place of birth(not important in this case) and column C with employment date. Column C can be empty. I would like to copy values of ...
1
vote
0answers
18 views

Search in text for column of words and return the word that matches

I have two columns of data, the first (Column A) contains a whole load of text, the second (Column C) contains the "key" data. I want to see if the text in Column A is matched by any of the entries ...
0
votes
0answers
20 views

excel error when double clicking file but not when opening from excel

I have an excel file that, when I open by double clicking it, gives me the following error message. If I click ok everything works fine. If I open the file from Excel this error message does not ...
1
vote
0answers
28 views

Hiding pivot table field using a button

I have a pivot table in Microsoft Excel 2010 with several row and column labels. For the sake of user friendliness I would like to have several movable, clickable buttons which each hides/shows one of ...
1
vote
2answers
34 views

Extracting email from text string in excel/google spreadsheet

I'm looking to extract email addresses from text strings in Google Docs/Excel and email them automatically, where the content of the cells are currently unknown (until updated by user). For example, ...
0
votes
1answer
19 views

Excel: Month() Formula Returning Wrong Value

I have a Sheet that has dates in Column B and Numbers Column X to be Averaged by Month in the formula I am using is as follows take for instance the month of February ...
0
votes
1answer
17 views

Displaying data in Excel Pivot Tables

I am working on a project and being able to use a pivot table would make life much easier. I need essentially for one column to become the column labels which is fine, however I would like to display ...
0
votes
0answers
10 views

Excel - Pieces of data from large chart sheet 1, auto sort on sheet2

I have a large chart and need to take small pieces of data (3 cells each for 14 rows) and have them stack ranked on the second sheet. I need A21:A34 (Branch Name), M21:M34 (% of Goal) and K21:K34 to ...
1
vote
2answers
29 views

Sorting rows in Excel 2013 based on when they were added

Is there a way to sort rows in Excel 2013 based on when the rows were added?
0
votes
1answer
10 views

Format as currency within a formula

I am trying to sum a column of dollar amounts and label it as "Total: $xx,xxx.xx" in the first row of that column. I have gotten as far as ="Cost - " & Text(SUM(B2:B), "$0.00") BUT, it is not ...