**-1**

votes

**3**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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 ...