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