**0**

votes

**1**answer

36 views

### Excel Adding multiple values

How do I sum the "1"s separate from the "2"s when they are in the same column?
1
2
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
2
1
2
1
2
2
1
1
...

**0**

votes

**2**answers

34 views

### Excel 2010 formula to delete repeated content based on value (instead of second highest the lowest)

I've read a Question topic about picking the second highest value. I need the same but a bit different:
Excel 2010 formula to delete repeated content based on value
Maybe it is a bit rude, but I ...

**3**

votes

**4**answers

110 views

### How to identify duplicates within text in two columns in Excel

I have a worksheet where column A has various names in varying formats:
A1 John Smith
A2 Jones, Mary
A3 Sally Gomez
A4 The Gonzalez family
Column B has similar data:
B1 ...

**0**

votes

**1**answer

17 views

### Find multiple cells with the same value in col A then search col C for a particular number

Say I have multiple cells in column A with the same value (e.g the number 22). I want to identify those rows then search for the existence of a particular number in column B (e.g. the number 10); ...

**1**

vote

**1**answer

33 views

### Add an area to a scatter plot in Excel

I'm desperately trying to layer an area chart on top of a a scatter plot in Excel 2013.
The scatter plot has been successfully used to visualize the deviation from the mean of different Key ...

**-1**

votes

**0**answers

14 views

### How do I link other workbooks to a master file?

I want to know how to link different workbooks, which have similar names. For example, I have one master file, which needs to get populated from various other workbooks (from different worksheets). ...

**0**

votes

**1**answer

24 views

### How can I return a count of a specific criteria in a range of duplicated items?

I have two sheets (tabs) in an excel document, Sheet 1 and 2. As can be seen below Sheet 1 has 3 columns [1 row], and Sheet 2 has 2 columns [5 rows].
I am looking for a formula that will return the ...

**2**

votes

**3**answers

62 views

### How to round off an hour value?

I need to round some hour value in excel at the first quarter after):
9:01 ==> 9:15
9:10 ==> 9:15
9:15 ==> 9:15
9:16 ==> 9:30
and so on

**0**

votes

**2**answers

24 views

### Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...

**0**

votes

**2**answers

30 views

### Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign.
If I have 3 columns DATE | ...

**0**

votes

**1**answer

25 views

### How to create a reference table in MS Excel?

I would like to create a reference table in Excel like this:
So everywhere in my workbook or worksheet I type X111, Excel shows the value of 2400.
How could I do that?

**0**

votes

**1**answer

43 views

### How to search in column A for specific data and return an answer in column B (“Yes” or “No”) [closed]

Using Excel for Mac 2008.
I'm looking for a formula that will do two things: search in Column A and provide a result from the search in Column B. Column A has a long list of comma-separated data in no ...

**1**

vote

**2**answers

32 views

### Find information about range of Excel data. Is it constantly growing or cyclical?

I am (short-term) monitoring the sizes of several UNIX files and can easily export the numbers to an Excel spreadsheet. The files will eventually be indexed by Splunk and that team wants to know the ...

**0**

votes

**2**answers

71 views

### How to convert text to date in MM-YYYY format

I have a column in Excel with the following entries in text format:
7.2013
7.2014
8.2013
8.2014
9.2013
9.2014
10.2013
10.2014
11.2013
11.2014
12.2013
12.2014
1.2015
How can I convert this ...

**0**

votes

**1**answer

36 views

### Chart created from range of dates includes dates not in source data

I have a chart and its source data is read from a range which contains dates. When I plot it out into a chart, the x-axis includes dates that are not included in the range.
How do I avoid this?
For ...

**1**

vote

**1**answer

18 views

### how do i just copy excel to txt with space and '\n' as delimiter

When I copy excel to txt, the I can't get the delimiter for different columns as space, ' ' and the delimiter for different rows as '\n'. Is there someway for me achieve that? Because I am building a ...

**0**

votes

**1**answer

68 views

### Excel colon in function

I am learning excel functions and modeling from Google and trial and errors so just want to clarify the following point to get my fundamental understanding correct:
When it comes to colon in excel, I ...

**0**

votes

**1**answer

35 views

### Excel changes my settings for column width and row height

I select the entire Column
right click and select "Column width"
enter 2.54mm
hit enter
When I check the column width, it is 2.38mm.
Similar issue with row height. I try to set it to 2.49mm; ...

**1**

vote

**1**answer

58 views

### Looking for an excel formula to match credit card purchases to batch payments reflected on bank statement for account reconciliation [closed]

How can I match credit card batch payments from bank statement to credit card purchases in a spreadsheet?
CC Purchases Batch Payments
1 0.05 A 1,913.91
2 ...

**0**

votes

**2**answers

62 views

### How to renumber a sorted column to start from zero in Excel

I have 2 columns of numbers in excel. After sorting them, I want to convert the numbers to sorted numbers from zero, which the minimum number converts to 0, second number converts to 1 and ... . For ...

**0**

votes

**0**answers

20 views

### Group dates as MM-YYYY on Pivot Table

I'm using Excel 2011 for Mac. I have a sheet with dates that I have grouped into a Pivot table.
The data spans across months of 2013 and 2014. I want to chart the trends over a month of a year, but ...

**-1**

votes

**0**answers

32 views

### Excel OR function with several criteria, how to make better?

I'm making an Excel document (for Mac 2011, ver. 14.0.0) with a drinks list, and right now I'm making a sheet where you can enter what ingredients you feel like using (up to four) and the sheet will ...

**0**

votes

**1**answer

38 views

### How to highlight a cell when I double click on another cell?

Friends I am using MS Excel 2010 and I want when I double click on a cell say a1 it should highlight c1 cell. Similarly when I double click on a2 cell it should highlight c2 cell. It is possible by ...

**1**

vote

**0**answers

34 views

### Excel Charting - How to edit the X axes for positive value on both sides?

I have a stacked chart, with the X axes at bottom. So there are two bars protruding along the y axes from each category. to get an idea of the X axes, it's something like this
How to plot positive ...

**2**

votes

**0**answers

26 views

### How to enable macros on an external hard-drive

I have an external hard-drive that I have mapped locally to the e:\ drive. There is a subfolder that contains Excel sheets with macros that I am unable to run.
In File->Options->Trust ...

**0**

votes

**2**answers

33 views

### 1 A, 2 A, 3 A automatically becoming 1:00 AM, 2:00 AM, 3:00 AM in Excel 2010 [duplicate]

I use MS Office 2010. While using Excel, whenever I type 1 A, 2 A, 3 A up to 12 A and move to next cell by hitting Tab or Enter key it automatically becomes 1:00 AM, 2:00 AM.....12:00 AM. This problem ...

**-3**

votes

**2**answers

39 views

### How can I scrape only word data from a website? [duplicate]

I want to download all the word content from a particular website. Save the results in MS Word, Excel or Notepad and check which words are repeated most often and how many times.

**1**

vote

**2**answers

30 views

### How to use validation to make sure cell value starts with specific word

I need to check if the value of a cell starts with the term superuser.
The entered value then should, for example, look like this:
superuser template
If the user enters super user template (with a ...

**0**

votes

**1**answer

45 views

### Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...

**0**

votes

**2**answers

42 views

### Combine first letter and last word in excel

I have a spreadsheet of usernames. First and last name are in the same cell. Is there a formula to take the first letter of the first word and the whole second word?
For example;
Cell A1 has Jon ...

**0**

votes

**1**answer

36 views

### Finding Clustered/Consecutive Values in Excel

I am trying to find values in an Excel spread sheet where numbers greater than 0 will be highlighted. However, those highlighted must be clustered, consecutive numbers which should be (at least) three ...

**0**

votes

**1**answer

33 views

### Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B.
I need to compare another list of document numbers (alphanumeric), ...

**0**

votes

**1**answer

23 views

### Sorting cells in rows to match respective column headers

I'm trying to sort the cell value in multiple rows to match the value of a column headers.
What it looks like:
A B C D E
---------
D
A C
C E
B D E
E
What I want it to look like:
A B C D E
...

**0**

votes

**1**answer

56 views

### Sheet name dynamically assigned from a cell value

Sub CreateWorkSheetByRange()
Dim WorkRng As Range
Dim Ws As Worksheet
Dim arr As Variant
Dim template As Worksheet
Dim xTitleId As String
On Error Resume Next
xTitleId = "Select Range"
Set WorkRng = ...

**1**

vote

**2**answers

70 views

### Index of N'th largest value in a range

I have a range of values that may contain duplicates. It looks something like this:
A B C D
----------
1 23 1
2 12 2
3 23 3
4 36 4
5 19 5
I want to display the 3 largest values, but I ...

**0**

votes

**1**answer

18 views

### SUMPRODUCT where the product is computed from the row

I have a range AG6:AS38. It looks like this:
AG AH AI AJ AK AL AM AN AO AP AQ AR AS
--------------------------------------------------------
6 | 1 A B C D ...
7 ...

**-2**

votes

**1**answer

20 views

### EXCEL, I need to take data from 1 column & arrange in another column so the data loops [closed]

EXCEL, I have 4 columns. one column having part numbers, a blank column, column with group number & 123 count column.
I need to take item 1 of the 1st group copy it to blank column but in the ...

**2**

votes

**1**answer

12 views

### Excel Autofill Linegraph with Time

I must admit that I am not the expert on excel, but I need help creating a graph with some data. In column A, I have over 500 cells filled with temperature values from a probe. Now, technically each ...

**0**

votes

**0**answers

13 views

### To show data about one Excel file in another

An Excel sheet gets data from another, the source file, using DDE. How can I show, in a cell of the Excel sheet, the date/time when the source file was last amended or saved?

**1**

vote

**0**answers

26 views

### One dynamic named range not staying dynamic while another in the workbook is

I am attempting to use dynamic named ranges to make it so I can pre-set the column portion of the print ranges in a workbook without assuming a number of rows. So I opened the name manager and ...

**0**

votes

**0**answers

16 views

### Dynamic field names in Excel queries

As explained here, Excel queries accept dynamic values (e.g. "where name = ?" and "?" can be linked to a cell of your choice).
Alas, Excel queries don't seem to accept dynamic field names (e.g. the ...

**0**

votes

**2**answers

31 views

### Excel formula to identify and group figures

I have two columns A and B
In column A, I have figures in some currency say US Dollars. In column B, I have account codes to which the figures should be grouped.
A B
USd Codes
2,500 ...

**0**

votes

**1**answer

37 views

### Excel 2013: moving X-Axis values to the middle of the columns

How could I move the X-Axis values to the middle of the columns?
For example, the month values in the chart below (it's not my chart, it the state I want to reach) appear in the middle of the column. ...

**1**

vote

**1**answer

21 views

### Column of text needs “summed” based on assigned value

On one sheet, I have a table with an employee name in column A and their associated rank in column B. On a separate sheet, I have a blank master schedule with all possible shifts in column B and days ...

**0**

votes

**0**answers

15 views

### Outlines of merged cells not staying consistent when a filter is applied

I have a spreadsheet that uses merged cells for visual clarity. The merged cells are in the B column (dates), and in the A column there are various values. I use filters in column A, and in my other ...

**0**

votes

**0**answers

15 views

### event-click sub in VBA for Excel

I have an ActiveX listbox on an Excel worksheet. Can I put the listbox click-event sub in a module? If I double click on the listbox in design mode, Excel wants to put the sub on the code sheet that ...

**0**

votes

**2**answers

51 views

### How do you get excel to ignore zero or blank values in an Average?

I am making a spreadsheet to score recipe ingredients, averaging scores for quality of the ingredient, packaging, and accuracy of serving size, and then using that data to create an average for the ...

**0**

votes

**1**answer

25 views

### How can I get a count of values for one column as compared to a second column?

I have a spreadsheet with a list of companies that submit data, the type of data they submit, and the date they submit. I need to a do a count of the number of times per day they submit, but only do ...

**0**

votes

**2**answers

28 views

### How can I prevent changes to formula results after first use?

We have an Excel 2013 workbook that we use when we create new user accounts (column A for first name, column B for last name, column C for the password, etc.).
First name Last name ...

**0**

votes

**1**answer

42 views

### How can I search for a value that's repeated in excel?

I have a spreedsheet (Sheet2) that has 4 columns:
ID | Name | Semester | SemesterAvg | Overall Avg | Period |
1 | John | 1 | 2.5 | 2.5 | 20132 |
1 | John | 2 | ...