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
3 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
7 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 ...
-1
votes
1answer
14 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)?
-3
votes
0answers
12 views

number of points to the max value

All How do I find number of points to the max value: i.e. FALSE FALSE FALSE 0.708007813 0.712890625 0.72265625 0.737304688 0.7421875 0.747070313 0.756835938 0.766601563 0.776367188 0.776367188 ...
0
votes
2answers
12 views

Using multiple conditions with COUNTIF

Needing to produce an table that outputs a count of unique ID's for each day for seperate regions. The table is in this format (only way bigger, with many many appearances of each ID everyday) - A ...
0
votes
1answer
17 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
15 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
8 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
25 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
27 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
6 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
8 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
10 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
9 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
56 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
1answer
24 views

Excel, Offset from cell target

Is there a way to offset() from a cell target not cell position? I have a summary sheet that links to totals on back-sheets and this would speed up the linking of cells. Lets say A1's formula is ...
0
votes
0answers
12 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
25 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
14 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
18 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
48 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
18 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 ...
0
votes
0answers
14 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
18 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
23 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
30 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 ...
2
votes
2answers
26 views

Excel: Calculate IF column based on another IF column

I am trying to use Excel to create a scorecard for different companies to use. The product I create needs to be a finished product - when a company representative fills out certain information on ...
-4
votes
0answers
22 views

Creating Rules in Excel Spreadsheet [on hold]

I have the following problem. I have a spreadsheet which has different cells that I need to to create some rules in the spreadsheet so cells turn red if a position is named and not posted and if a ...
1
vote
1answer
23 views

Counting how many fall within a time range based on specific text

I am trying to produce a fomula that counts how many times and indivioudal registers a time between acertain time range. So the table below is part of the data so for example how many times did ...
2
votes
0answers
25 views

Looping through master sheet and filter out rows that are needed

I have created a script which I want to allow a user to select a file (Master File) and if a condition is a met I want to Copy the data to the excel workbook (which the script is run on) The code ...
2
votes
1answer
31 views

Update an existing cell in Excel without circular reference

Please note: I am aware that the function I am using will cause a circular reference. I am trying to find a work around for this problem. I have a simple excel report which I use to fill in weekly ...
-1
votes
0answers
25 views

How to convert microsoft excel spreadsheet into mobile-friendly html table?

mobile-friendly html table microsoft excel spreadsheet data pattern | h1 | h2 | h3 | h4 | h5 | h6 | h7 | |----+----+----+----+----+----+----| | | d | d | d | d | d | d | | ...
-1
votes
0answers
16 views

Change format of data label of pie chart (in Excel 2007) dynamically satisfying some conditions

I have made a Dynamic Pie Chart in Excel 2007. It has a Data Range that changes dynamically using Form Combo Box. I would like to have a VBA code that checks each Data label of Pie chart with ...
0
votes
0answers
8 views

Pivot table filters replace values on their own

I have a pivot table connected to a table in SQL. When I create the pivot table for the first time, all the filters display the correct information. Once I start applying filters however, some of the ...
-3
votes
1answer
40 views

How to create this Excel function (formula)? [on hold]

I'm trying to create an Excel formula: If (B20<=750 and B20>=850 and B22>=135 and B22<149) then B15*.16 otherwise 0 It is for this graph PVR Penetration 0-749 750-849 ...
-1
votes
0answers
26 views

Find first value above 0 in Column A and B then find the first value above 0 starting from the row where the previous value came from

I have column A and B which are filled with values, mostly zeroes. All other values are above 0. If a value is above 0 in column A it will always be 0 in column B and vice versa. I now want excel to ...
-1
votes
0answers
39 views

Combine data from monthly sheets into totals on another sheet

I have an Excel workbook with different sheets per month for salary details, with columns being Employee Name, Basic, HRA, Conveyance, etc. I want the sum of all these components in a different sheet ...
0
votes
1answer
34 views

Count rows matching criteria for every row in excel

Hi here is a sample spreadsheet: +--------+-------+-------------+-------------------+ | Animal | Count | Animal Type | Animal Type Count | +--------+-------+-------------+-------------------+ | cat ...
0
votes
4answers
29 views

Format percentages in Microsoft Excel

I am trying to format the following column in Microsoft Excel to add the percentage sign after the second decimal: 5.8394 3.2922 3.2 4.461 1 I highlight the column and choose Format cells > ...
0
votes
1answer
8 views

Multiple row calculation with one fixed value

I have a calculation like this =B8+((B2-1)*C8) I want to multiple these calculation by just dragging it down. So I don't need to type the calculation for each row. The values B8 and C8 shall ...
0
votes
0answers
10 views

Excel - Conditional formatting retention through data validation in another sheet

I have applied conditional formatting in an Excel sheet (Sheet2) to change the font color in column A if the result in the adjacent cell in column B is "No." I then used this conditionally formatted ...