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)

-1
votes
3answers
10 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
0answers
4 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
8 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
7 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
16 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
19 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 ...
-1
votes
2answers
35 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
0answers
14 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
11 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
2answers
16 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 ...
0
votes
0answers
10 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
47 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
16 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
13 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
16 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
19 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
28 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
15 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
9 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
28 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
9 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
25 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
24 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
25 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
33 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
28 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 ...
0
votes
0answers
19 views

I want to hide rows in Excel 2010 using VBA if a cell value is blank

I can get the VBA to work just fine to do this, but my spreadsheet is 20MB without data. What I want to do is find the first time a cell is blank and then hide every row at once from that spot until ...
1
vote
1answer
11 views

Inserting formula through VBA in “A1” reference style

I insert this formula through VBA, Cells(1, 1).FormulaR1C1 = "=LEFT(A2;5)" But the formula which gets inserted ends up with apostrophes. =LEFT('A2';5) This works perfectly with the R1C1 ...
0
votes
1answer
27 views

How to make a macro universally usable on multiple workstations with different usernames

I have a macro that I built for a specific work related task. I share this macro with a few people by sending them the .xlam file as an addin. No problems there. My problem is that some of the code ...
0
votes
0answers
15 views

Can i have a transparent slider in Excel?

I want a transparent slider element in Excel. What do I have to set for BackColor? Right now it is: &H8000000F& In the end I want a slider Element which changes colors on slide.
0
votes
0answers
39 views

What is the most useful way to chart word frequency over time? [on hold]

I want to create a chart displaying word frequency in a newspaper over time. I'm looking to chart specific words (not all words). I thought a scatter chart would be best. I would like to have the ...
0
votes
1answer
32 views

Excel Formula with conditions

This feels like it should be simple but my head is hurting now and I'm struggling. I need to add a condition to an existing sheet which already contains formulas and references to other sheets. ...
0
votes
0answers
11 views

Copy Blank Count

i want to copy the blank color count under Color column from "5-Jul-15" sheet and "6-Jul-15" sheet to ABC sheet under "5-Jul-15" and "6-Jul-15" column (i.e. C13 and E13) respectively. It should ...
0
votes
0answers
3 views

Excel for Mac conditional matching statement

In Excel for Mac. What I am trying to do is create a formula in cell A13 that will take a value from cell A1 and look for a match from a a list of multiple values from a list (column a) from tab b. ...
1
vote
1answer
33 views

Excel - duplicate search and replace - 2 sheets

Let me rephrase the question. When a cell in column A sheet 1 matches a cell in column A sheet 2, take the value on that row of sheet 2 column e and replace the value in column E sheet 1 with it on ...