**0**

votes

**1**answer

23 views

### Find multiple matches

The first column of my spreadsheet is a list of team names. The next few columns contain player names. A player may be on more than one team. Finally, I have a column with a list of player names.
...

**0**

votes

**0**answers

17 views

### Excel 2013 Color a row based off of 1 cell with different types of information

In Excel 2013: I have created a conditioned format cell in column F so that if the cell value is 10 then the cell is colored yellow. If the cell value is 16 then it is colored red. If the cell value ...

**1**

vote

**1**answer

76 views

### Excel - Parsing data to template

I'm not sure if this is possible in Excel.
I have a sheet that looks like:
+---------------+-------+--------+-------+-------+-------+-------+-------+-------+
| | August ...

**0**

votes

**0**answers

22 views

### 2 EXCEL (array?) questions

I am trying to perform some lookup calculations on a pivot table and having some abysmal luck finding the correct function/formulas to use. I've searched the Interwebs and can't find something that ...

**1**

vote

**1**answer

20 views

### Excel Deleting duplicate entries

I want to delete duplicate entries in the following table:
The problem is that I only want to delete the duplicates in the left hand column, and the right hand column entries must stay with their ...

**2**

votes

**2**answers

31 views

### SUMIF/ COUNTIF (look up names from column 1 then sum numbers from column 2)

I need to look up names from column 1 then sum numbers from column 2. Some names in column one appear more then once. (The spread sheet I am working on has 7400 rows!!!)
Example:
Column A ...

**-2**

votes

**1**answer

29 views

### VBA dates filter [closed]

easiest way to explain this is to use a example.
I have two dates(f.e.) "2014-08-08T8:11:31" and "2014-08-11T13:53:29".
I need to gave them proper form(date),exclude weekend(Saturday, Sunday ) and ...

**0**

votes

**2**answers

31 views

### Excel not using comma as default separator for .csv files

Need to make Excel use comma as a default delimiter if I drag a .csv file to Excel window or select a .csv file from Windows Explorer. None of the suggestions on this site or combinations therof ...

**0**

votes

**1**answer

16 views

### Is there a way to have groupings of bars in a bar chart in?

I know this may be bad style, but I want a bar chart that groups certain bars together. For example if I was comparing the speed of two models of cars, and considering the speed under wet and dry ...

**-1**

votes

**1**answer

18 views

### In Excel 2013 Is there a way to code an auto-complete function ibased on values in another tab

I want to create an auto complete cell in Excel for the resource name. The list is too long for a custom list and I really do not want a drop down list as in data validation. Does someone have an ...

**0**

votes

**0**answers

15 views

### How to import a csv file into Excel on Microsoft Office Live [migrated]

I'm working with Moodle to export a csv file. The file is encoded as UTF-8 but Excel doesn't recognise it and so displays odd characters.
I've modified the code to insert a BOM as per ...

**1**

vote

**2**answers

57 views

### How to generate 1,2,3,… sequence in Excel with each member repeated Ntimes

Let's consider a sequence: 1,2,3,4,5.... That is obviously easy to create in Excel. But how would you create a derived sequence, where each of the member of the original sequence is there N-times in a ...

**0**

votes

**1**answer

24 views

### Data analysis from Excel tally chart

This is a bit of a complicated question.. so bear with me!
I have a spreadsheet which I've set up as a tally chart - for ease of inputting paper-based data.
The D column has a relatively simple ...

**0**

votes

**3**answers

212 views

### Run excel macros (vba) from vbscript file

I have a vbs file that pulls information from my database and exports the data to an Excel file (C:\file.csv). Once this is done, I run a series of macros (vba) to format this data. These macros are ...

**0**

votes

**1**answer

12 views

### extracting labels of data in a pivot table

When I move the mouse pointer over data in a pivot table it displays what are the row and column labels (names of pivot items).
How can I extract them so I can later use them in a code (when I want ...

**-1**

votes

**3**answers

32 views

### how to remove multiple data in excel

I have a email list on excel
that looks like this:
123@abc.com
ad@aaa.com
ydd@asd.com
offf@rty.com
7ff@vvc.com
ass@aaa.com
yss@asd.com
oas@rty.com
I want to remove the below data from email list.
...

**1**

vote

**1**answer

134 views

### How do I extract the following data from an Excel data collection?

Below is a small example database that I have created for reference.
What function can I use to only display users that have 0 'Data Used', 'Minutes Used' and all 'Amount Used' rows must be no more ...

**-1**

votes

**1**answer

17 views

### Calculating difference of days accounting for weekends and holidays

Is there a way to calculate a difference between days (example 22.5.1999. + 200 days) but exclduding weekends (saturday and sundays) and holidays (1.6., 3.7., 9.8. <- made up for the purposes of ...

**0**

votes

**1**answer

29 views

### How to display series name inside bars of stacked bar chart?

I have a very busy stacked bar chart, some 20 or so series over time
I am not interested in the actual numbers, I just want to show the overall trend over time.
The default colours in Excel 2010 are ...

**0**

votes

**1**answer

21 views

### Looking for a formula(s) that will return the next date (higher than the starting date) from a row of dates, then the next date from that one

Worksheet 1 lists all of the "legs" flown by our aircraft. The leg or legs for each day would then go to Worksheet 2 for Day 1, Worksheet 3 for Day 2, and so on. Legs are listed in columns starting ...

**0**

votes

**1**answer

21 views

### How to make changes on an excel column by changing another column

So I want to have a column that when I make changes there, the changes are aplied to another column, and by changes I men even deleting columns, I tried using the =&A! formula but all goues down ...

**1**

vote

**2**answers

30 views

### Why would all text columns in an Excel spreadsheet begin with a leading single quotation mark

I'm trying to import into a database some data sent to us in Excel, which I rarely use. A single quotation mark is coming across as part of the data of each cell that contains a text value:
...

**0**

votes

**3**answers

32 views

### Convert a column to allow total in hours and minutes

I am trying to convert data on an excel sheet from hours recorded in format 1.40 (being 1HOUR 40 minutes) to 01:40 so I can add up a column. Can anyone help

**-2**

votes

**0**answers

45 views

### VB macro for excel

Coding a lil' macro so it pulls data from one book and paste's it into another book and I'm a little stuck. It copies data but only from the book I created the macro/button in, and not any other book.
...

**1**

vote

**2**answers

31 views

### How can I hide 0% value in data labels in an Excel Bar Chart

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a ...

**1**

vote

**1**answer

19 views

### How can I demonstrate that a user data validation selection clashes with a previous user data validation selection?

Using multiple tiers of drop down lists, I have created a series of user selections. The user selects from the first list on the left. Then depending on the first selection 'Role', the user can select ...

**0**

votes

**2**answers

20 views

### When I change number of decimal places then value in the cell changes

For example I set 5.555 to the cell. When I change number of decimal places to 2, value changes to 5.56. If number of decimal places is 0, value in cell is 6.
If I add decimal places it does not ...

**0**

votes

**1**answer

25 views

### Match and report similarly arranged set of cells in ms excel worksheet

I have a set of cells like : Each alphabet is in seperate cell
A B C D E F
D E F G H D
H J E R T U
X Y M N N O
There are around 2000 to 3000 rows like this.
In same worksheet, this set has ...

**2**

votes

**1**answer

47 views

### MS Excel: Count frequency of similar values in between blank cells

I'd like the count the frequency of identical values in a row. The value must occupy at least two cells and must be beside each other.
I'd like to post the image here but i do not have enough ...

**0**

votes

**1**answer

22 views

### How do i find the nearest value and place it in a third column?

this may sound dull to you experts but i have no expertise whatsoever in Excel and am hoping you can help me..
I have the following:
COLUMN A (A1:A100) FULL OF VALUES
COLUMN B (B1:B100) EMPTY
And ...

**0**

votes

**1**answer

24 views

### How to update range of columns in excel

I have an excel sheet where from one sheets's Id used as reference in next sheet.
The Id's are sequential. Like this :
Sheet 1 Sheet 2
ID Name ID Sheet_1_ID Text
1 ...

**0**

votes

**0**answers

32 views

### Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like:
I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not).
I have checked for ...

**0**

votes

**2**answers

30 views

### multiple entries from existing excel file

our customer provides us with an excel file listing drivers names and the number of tickets they get for a free drawing, such as "bill smith (next column) 17 tickets
is there a way to take that and ...

**-2**

votes

**1**answer

28 views

### Display formula result only if inputs are defined

I have a simple spreadsheet, with one row of equations to get sums or differences. What I'm trying to do is enter an equation so that if only one part of the end equation is present, the field is left ...

**0**

votes

**1**answer

24 views

### Add a series to a chart by pasting its formula no longer works in Excel

I used to be able to add a new series to a chart by typing or pasting a =SERIES() formula into the formula bar when a chart's PlotArea was selected, as indicated here: ...

**-1**

votes

**0**answers

22 views

### MS Excel 2007 Copy Range Across Worksheets and Increment or Offset by 50 rows

I'm looking to copy and paste a list of names from Sheet 1 to Sheet 2 but space them out. For example, I'd like Sheet1!A6 -> Sheet2!A51, Sheet1!A7 -> Sheet2!A101.... Sheet1!A41 -> ...

**0**

votes

**1**answer

34 views

### Excel - How to add/remove a row without affecting formula in a column

I have column B with a formula full of IFs with each cell referenced to the cell above it.
From time to time, I need to delete some rows. Once a row is deleted, the formula in column B gives #REF for ...

**1**

vote

**1**answer

24 views

### How do I consolidate values in Excel?

I need some help with an Excel spreadsheet.
I have a large data set that contains multiple expenses of multiple individuals over time. What I want to do is to consolidate the costs of individuals per ...

**0**

votes

**0**answers

17 views

### How can I calculate the grouped averages and maximums per day for a range of dates and times?

I have a CSV dump describing the utilisation percentage of some servers in my organisation, covering data samples from several times per day. Each server belongs to a group. For each group, I have to ...

**1**

vote

**1**answer

29 views

### How do you create a mail merge from excel in microsoft word and then overlay multiple images on top of each other

I know how to insert images into mail merge in word one at a time and have them next to each other, but I want to mail marge three images each onto a printable label.
The first image is a background ...

**0**

votes

**2**answers

37 views

### Generate 4 columns of data such that each row sum to 100

If I wanted to randomly generate 4 columns of positive numbers such that the numbers for each row sum to 100, how do I do this in Excel or some other program that you can recommend?

**0**

votes

**0**answers

22 views

### Avoiding duplicate rows in an EXCEL Pivot Table

I am running EXCEL 2007 and try to do a Pivot table.
The data are the following ones:
And the table pivot result:
As you can see, I have some duplicate lines in the pivot table that I don't ...

**0**

votes

**1**answer

21 views

### Bit.ly link without http://

I am creating bitly links and want to save them in an Excel spreadsheet.
When I copy and paste them I get the http:// component of the address in front of the bit.ly
How can I not get this as it ...

**1**

vote

**2**answers

38 views

### Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure:
text, text, 01/27/2001 01:00:00 PM
I need to update ALL csv files with this datetime format:
text, text, 27-Jan-2001 13:00:00
Is there a known ...

**0**

votes

**1**answer

14 views

### Excel adding rows based on if they are a number

I'm trying to add rows in a column based on whether or not they are a number.
Some rows are numbers and some are not.
I have something like the following. But it's not right:
...

**0**

votes

**1**answer

15 views

### how to get cell number as a result of a function

i need to get № of a cell that contains the result of MAX(J4:J24) and write a word from the same row instead of the actual max number
the word can be written i guess via =INDIRECT("A"&formula ...

**0**

votes

**0**answers

12 views

### Named Views for Excel Pivot Table?

While I'm an advanced Excel user and developer of addins, I apologize that I'm not very familiar with pivot tables.
I have a simple pivot table worksheet based on a simple set of data in another ...

**2**

votes

**1**answer

53 views

### Remove a known Excel password without Excel

Is it possible to remove a known password from an excel sheet if excel isn't installed on the machine? We receive uploaded excel files (2007 and 2010 format) and we know the password for those excel ...

**0**

votes

**1**answer

35 views

### Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20)
The 3 columns are each 1 digit of a 3 digit number.
Some of the rows have 3 digits, some are blank.
I need a way to return all the non-blank rows of 3 ...

**-1**

votes

**1**answer

25 views

### Formula to return values into a number of cells based on another cell's value. [closed]

If I have a cell (A1) value is "2" (set value)
& another cell (A2) value is "4" (number of cells in 1 column i want the set value to appear in)
How do I return the values in B1:B4 to all be "2"?