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)

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