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

20 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

38 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

22 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

39 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

27 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

27 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

31 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

17 views

### Lost Excel file on Mac [closed]

I have located the Office 2011 AutoRecovery folder from your previous posts. Thank you! However, there are only three word documents in it and no excel files. Autosave has been on my Mac but my lost ...

**0**

votes

**0**answers

12 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

19 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

38 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

20 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

38 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

24 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

38 views

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

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

21 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

34 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

26 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

42 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

29 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

19 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

38 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

78 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

20 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

16 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

20 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

14 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

48 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

21 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

126 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

8 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

31 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

16 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

20 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

16 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

29 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

27 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

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