Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
3answers
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
1answer
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
0answers
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
3answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
3answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
0answers
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. ...