**1**

vote

**3**answers

36 views

### Excel: How to skip specific rows when importing a CSV

I want to skip the header and last rows when importing a CSV into Excel, just like I can skip specific columns. Is there a way to do this?

**0**

votes

**1**answer

34 views

### Excel 2010 area chart drop off

I'm trying to create an area chart that shows data over a year. All the data for each month always add up to 100%.
An image is probably worth 1000 words, so here we go:
I would like the area ...

**1**

vote

**1**answer

25 views

### Dropdown, multiple values in dropdown

I'm trying to make something for my hobby, and for that I was wondering on how to do it:
These are my input values:
And via dropdown you can choose one player and it autofills the other values:
...

**0**

votes

**1**answer

19 views

### Formula that returns all the different text strings in a range

I have a row with multiple models of cars. Every model in own cell but models repeat multiple times. I want to create formula in Excel 2010, that returns every different model just once.
Look like ...

**2**

votes

**2**answers

26 views

### I would like to copy data from 1 row to another in Excel

I am trying to solve the following issue in excel: I am working in two sheets, Sheet 1 and Sheet 2. There is a column of data in sheet 1 (say from A5 to A20). I need every row from that column to be ...

**0**

votes

**1**answer

18 views

### Excel 2013. Address from Value

I have two spreadsheets, one with a Calendar, and the other one with Data Chart.
I'm trying to make it so that the Data Chart will only start using Data from Today's date in the Calendar. (Note: ...

**-1**

votes

**0**answers

16 views

### Comparing and updating two excel sheets

In one excel file I have have 7 sheets divided according to users.
My second excel file has one sheet which keeps adding data after each month. So I need help in developing a method by which -
I can ...

**0**

votes

**3**answers

17 views

### Spell check across multiple work sheets in excel

Im trying to spell check across multiple sheets in excel and I've come across numerous sites that say you can select all worksheets in a doc, then when you use spell check it should check all sheets.
...

**0**

votes

**0**answers

21 views

### Difference Between Values in Two Filtered Tables

I have a pivot table with two variables and a filter containing two distinct options. I would like to take the absolute difference between the tables created by filtering for each of these two ...

**0**

votes

**1**answer

21 views

### Is there a way to add a scroll bar to a few columns only in Excel?

Most columns in my Excel sheet are only filled in till about row 50. However, I have 3 consecutive columns that are filled in till about row 150.
Is there any way I can add a scroll bar to these 3 ...

**0**

votes

**1**answer

40 views

### Transpose Groups of Rows to Column

I have a table like this in Excel:
Row | Question | Answer
1 | Q1 | a
1 | Q2 | b
1 | Q3 | c
2 | Q1 | d
2 | Q2 | e
2 | Q3 | f
and I want ...

**0**

votes

**2**answers

23 views

### Difficulty Graphing Excel Data

I'd like to create an appropriate graph for the following sort of data. I'm using an example as the actual data is 1000+ lines.
Date Player Points
02/06/2014 Bob 2500
...

**0**

votes

**1**answer

41 views

### Adding calculated columns to Excel Pivot without details

Is there a way to add a calculated field that would apply to total column only, without adding unnecessary detail for each column item?
Consider the following example.
The data is as follows:
Year ...

**0**

votes

**1**answer

17 views

### How to count only shown in filter heading using COUNTIF (Excel 2010)

I have a list of names, company, meals etc. and there is a filter in each column.
In the top, there is a list of the 5 type of meals, and COUNTIF() is used to count the different types of meal in the ...

**0**

votes

**1**answer

33 views

### Postbox/Outlook 2013: Strange Contact Import Behaviour

I'm experiencing a very strange error with regards to importing contacts that were exported from the Postbox 3 address book.
The CSV file itself is fine - everything maps out nicely in Excel, but ...

**1**

vote

**2**answers

38 views

### Excel conditional formatting if value is between or equal to values

I have been trying to use conditional formatting to create a Gantt chart. So far I have not been very successful. Here is a screenshot of part of the chart:
The current formatting is hand made.
I ...

**0**

votes

**0**answers

33 views

### How to make windows os append a numeric index to filename choosen if file already exists

I am creating a lot of microsoft excel files and backing them up to amazon storage.When i am creating the files,usually on my laptop or desktop computer,i may forget what the filename i had given any ...

**0**

votes

**1**answer

21 views

### How do I get an entry to re-show up for auto-completion

I have a column of, let's say colors "blue" "yellow" "red" "green". As I'm manually typing in these entries, it makes it easy on me if I can just hit b and blue comes up and I can just hit enter. I ...

**0**

votes

**0**answers

14 views

### How to update the cells in one excel sheet with the values in the survey sheet in excel online

Well i have created an excel online form .. The users are entering the information in it and it is being saved in excel sheet named as survey1.... Now i want this information to be populated in a ...

**0**

votes

**1**answer

23 views

### Combining Two Differently Formatted Spreadsheets

I'm relatively new to excel and am having some issues comparing two sheets of data. We're looking at the benefits over the fiscal year by month. One spreadsheet has the project ID on the left, and the ...

**0**

votes

**1**answer

41 views

### How can I disable changes to folder last modified date?

When I open an excel file, for some reason the last modified date of the containing folder changes to the current time-stamp.
I want to disable this, it causes lots of confusion, especially when I ...

**-1**

votes

**0**answers

21 views

### Excel 2010, IFERROR, INDEX, MATCH

I've got a sheet consisting of various lines like the following.
POH-00006366 CYM001 Cymot NAD 6000
POH-00006366 CYM001 Cymot NAD 7000
POH-00006366 CYM001 Cymot NAD 8000
...

**1**

vote

**3**answers

48 views

### Excel VBA - adding an element to the end of an array

Simpel Question I like to add a value to the end of an array and increase it automatically? I was not able to find such a simple example
Public Function toArray(range As range)
Dim arr() As Variant
...

**0**

votes

**1**answer

25 views

### Excel: Find number of records matching multiple criteria AND using time since the first record was created

I am looking for some help with a formula. On my 'data' sheet, I have data in the format below:
A B C D E F G H I ...

**0**

votes

**0**answers

39 views

### Copy random data in one column and arrange to single column [closed]

I have data formatted like this:
Column A
1
2
3
4
1
2
3
4
5
1
3
5
And I want to convert it like this:
A B C D E
1 2 3 4
1 2 3 4
1 ...

**0**

votes

**1**answer

24 views

### Timestamp in Excel…not working?

I know this question has been asked numerous times, and I have truly searched and attempted to work it out with the given solutions to no avail. Maybe I'm doing something wrong, but I don't know much ...

**0**

votes

**0**answers

38 views

### comparing two columns for matches then return values meeting certain conditions

I have the following:
column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300)
column H ( 50 values )
column E & column F & Column G; they are to ...

**2**

votes

**2**answers

27 views

### Problems figuring out weekly scheduling and hours past midnight

This is a screenshot of what I have
What I'm trying to do is have the hours for each individual person posted as shown or a way that the hours can be posted like this and then have the total amount ...

**2**

votes

**1**answer

48 views

### how to generate all possible 3 digit combination of the numbers 0-6

This may sound dull to experts and excel pros.. i am in desperate need for help please
i am using excel and am trying to generate a table (3 columns) that presents all possible combinations of the ...

**0**

votes

**1**answer

31 views

### Make the background/text colour follow another cells background or text colour

Ok so I have a large spreadsheet (so I don't want to have to set each cells colour individually or manually) and I have many cells copying other cells. So for instance I have cells N9, N
3, N80, N117 ...

**0**

votes

**2**answers

20 views

### How do I make a date field in Excel/LibreOffice Calc that is 180 days from today?

So I have two columns, one is the current date (currently using a 09/06/15 format) and I have another column that is meant to be for a date 180 days into the future. How can I create a formula that ...

**0**

votes

**1**answer

50 views

### How to bypass the VBA project password from Excel

I need help with password retrieval or bypassing the password on a project that was done at work. The author has used MS Excel to do the project, and it's in the client's server. The server that we ...

**3**

votes

**3**answers

83 views

### Excel Scheduling - trying to calculate hours after midnight so they're not negative

If anyone can give me any type of help on why I have negative numbers instead 40, which is what it should equal please help. I'd be so grateful. Thank You!

**0**

votes

**1**answer

21 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

75 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

21 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

28 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

25 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

17 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

50 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

23 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

161 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

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