**0**

votes

**0**answers

7 views

### In Excel, how do I select the column down to the first blank row in the adjacent column?

In Excel 2010 I have several columns with data. I insert a column, and type a formula in the top cell of that column. I want to fill the formula into the remainder of the column, down to the same ...

**0**

votes

**1**answer

10 views

### Subtracting time formats in excel

I want to calculate the difference between hours. I tried using the formula mentioned above which uses ABS function with TEXT function and IF function, but that didn't work. I also tried activating ...

**2**

votes

**2**answers

28 views

### IF statement formula for overdue DVD rentals

I am creating a spreadsheet for my local parish church to keep track of borrowed DVDs:
The DVDs have to be returned 14 days after they are borrowed. If the current date is over 14 days after the ...

**0**

votes

**2**answers

27 views

### If Difference Higher or Lower than Display

I need a excel formula that will show:
* "1" if B is less than A by more than 2
* "0" if B is within 2 of A
* "-1" if B is higher than A by more than 2
Can someone please tell me whether this is ...

**0**

votes

**1**answer

21 views

### Calculate time difference in percentage

I'm trying to make some statistical data on the performance of a specific task.
One of the data points gathered is how long time it took to run. I'd then like to compare that against the expected ...

**-1**

votes

**0**answers

11 views

### Automatically synchronise two excel spreadsheets

I'm trying to connect two separate excel spreadsheets and automatically update the data from the second one from the first one. which already comes to me with the new data monthly, and I have to ...

**0**

votes

**0**answers

15 views

### Documenting Excel Spreadsheets

I am managing a fairly large Excel workbook with about a dozen worksheets, several
macros, and 100+ columns total. Are there any best practices when it comes to
documenting Excel spreadsheets?

**2**

votes

**2**answers

11 views

### Limit Excel Macro Usage to Certain Users

I want my Excel macros to activate for certain users recognized by Windows Excel. How do I do that?

**-2**

votes

**1**answer

41 views

### Excel show list based on cell value

Basically, I wanna do something like this :
=IF(B1="APPLES","Show First List",IF(B1="ORANGES","Show Second List"))
But I'm not sure how to make a proper formula.

**0**

votes

**1**answer

19 views

### Excel formula to show multiple cell address or row locations?

I'm using the following formula, which returns a numeric value:
=SUMPRODUCT((A3:A176="Thing1")*(B3:B176="Thing2")*(C3:C176="Thing3")*(U3:U176="No"))
However, I'd like to also know the cell address ...

**0**

votes

**1**answer

32 views

### Extract text between emails with < >

Original link
Extracting Data Between two Characters in Excel
I have a combination of cells where some have nicknames and some without nicknames.
Some will have nickname < > emails and same will ...

**0**

votes

**1**answer

18 views

### Averageifs in Excel

I need help with a formula that will provide answers for the yellow shaded cells below. I think it's an average ifs function. I keep getting DIV/0
In the example below, I'm trying to get the ...

**1**

vote

**1**answer

24 views

### Referenced cell containing date-time showing up as a number in Excel

I am pulling values from one sheet to another. Sheet 1 has ticket ID and Sheet 2 has various values associated with ticket ID. I am finding the matching ticket ID on Sheet 2 and pulling the multiple ...

**0**

votes

**1**answer

65 views

### How to return all the cells in a row if first column matches a value on another worksheet

I have 2 worksheet tabs in an Excel workbook, tickets and tickets info. I have values in Column A of tickets (from A2:A500). I want to search for each value from A2 to A500 of the ticket sheet looking ...

**5**

votes

**2**answers

52 views

### How to split a CSV file into multiple files based on a text string?

I have multiple text files (CSV) with a structure similar to this:
funkiana,23.55,-99.866
funkiana,24.634,-98.701
funkiana,24.717,-98.901
geminiflora,22.25,-104.6166667
...

**3**

votes

**2**answers

33 views

### Filtering Data Excel Data from Survey to Obtain E-mails

Over the summer we conducted a survey for a number of students to indicate their interest in a number of clubs. The way the responses were scanned in gave us a column for each club and a '1' in each ...

**0**

votes

**3**answers

47 views

### What is the delimiter for the CSV file below?

I'm having trouble importing the CSV file, below, into Excel 2007. I can't figure out what the delimiter is.
...

**-3**

votes

**1**answer

25 views

### Entering every Monday Tuesday and Friday as a date

Hi I need to enter the date of every monday, tuesday and thursday on top of a sheet to use as a register, I have looked at the one below and this works for two days, could you please help me to extend ...

**1**

vote

**2**answers

23 views

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

In Excel, suppose I have a row with, say, 26 formulas horizontally from A1 to Z1, and then I move down to cell A2 and type a formula. Now I want to fill that formula to the right, through cell Z2. The ...

**0**

votes

**2**answers

31 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

**0**answers

20 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

**0**answers

26 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

**1**answer

13 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

**1**answer

13 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

**1**answer

16 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

**0**answers

24 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

**2**answers

25 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

**1**answer

42 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

**1**answer

21 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

**2**answers

56 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

**1**answer

13 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

**3**answers

38 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

12 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

17 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

15 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

25 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

**0**answers

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

**2**answers

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

**1**answer

26 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

21 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

**1**answer

16 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

31 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

35 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

9 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

11 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

**2**answers

17 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

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

**1**

vote

**0**answers

24 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

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