**0**

votes

**0**answers

4 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

**0**answers

5 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

**1**answer

8 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

**1**answer

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

**-2**

votes

**1**answer

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

**0**answers

13 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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**3**answers

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

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

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

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

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

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

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

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

**0**answers

19 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

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

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

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

**4**answers

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