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
36 views

How do I edit a Gantt Project Bar Graph in Excel

I'm not sure how to edit a Gantt Project Bar Graph in Excel. When you first open Excel 2013 (current version I have), you can start with a template and that's exactly what I did. I selected a Gantt ...
1
vote
2answers
35 views

Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet. First Sheet: (yes I need these merged cells) Second Sheet: Unfortunately Google ...
0
votes
1answer
41 views

Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F) I need to list only those data from columns A/B/C when column B data has no corresponding ...
0
votes
1answer
27 views

=excel 2013 if function not working as it should be

For example i have 4 cells:A1, A2, A3, A4 : A1=50 A2=10 A3=if(A1>A2,"-1","0") A4= if(A3=-1,"ok,"not ok") but the problem is that A4 keeps giving "not ok" ! whats wrong here?
0
votes
2answers
20 views

Cells show formula, not formula result

We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or ...
-2
votes
2answers
27 views

How do I convert list to table in Excel 2003

I have a list: date item name quantity 1.7.2014 A 5 1.7.2014 B 2 1.7.2014 C 10 2.7.2014 B 5 3.7.2014 A 1 ...
1
vote
1answer
19 views

IF Function and Time Subtraction

Coach: I've got a simple time card spread sheet drawn up. My question is I would like to set a function that if a cell is less than or equal to my base, it subtracts from my base to give a total. ...
1
vote
1answer
18 views

Office 2010 on Mac OS 10.8: Drawing a Chart

I have a simple data set and I want to make a graph for it. Years Upper Band Lower Band 2010 0.73 0.63 2020 1.04 0.83 2030 1.36 1.06 2040 1.74 1.31 2050 ...
1
vote
1answer
19 views

How do you auto update row count in a formula that yields a percentage?

How does one get a formula to auto update when a row is added when this formula is meant to yield as a percentage, which is directly linked to a pie chart? For example: my formula reads ...
1
vote
2answers
57 views

Excel- How do I find common text values from multiple (>2) columns?

I have 9 columns of text data and need to know the common terms that are found in all nine columns (or possibly different combinations of columns). I can do 2 columns ...
1
vote
3answers
25 views

How to remove duplicate values in col A from col B in MS Excel?

I need to remove the values from column B that exist in column A in an Excel spreadsheet. Data > Remove Duplicates doesn't seem to offer this as an option, so how else can I do this? I need to remove ...
0
votes
2answers
16 views

How do I get Excel 2013 to recalc the used extents of a worksheet?

Using Excel 2013, how do I force a recalculation of the last used cell in the worksheet? For example, Ctrl + Shift + End selects a bunch of cells, as expected, but it also selected some blank cells. ...
-1
votes
1answer
33 views

Automation Error Catastrophic Failure

I am trying to use excel VBA to copy some charts to Powerpoint slides using the below codes, but it shows error "Automation Error Catastrophic Failure". I can not figure out what is the problem. I am ...
1
vote
1answer
28 views

Excel automaticly adding an extra row which already contain formulas for the inputed number of years

I am looking to build a model, I would like is have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...
0
votes
1answer
24 views

Microsoft Query in Excel Returning Blank

In this post I was given a solution that relies on the following SQL: SELECT `S1`.DATES , `S1`.NAMES , MAX(`LS`.DATES) FROM `C:LOCATION`.`Sheet1$` `S1` LEFT OUTER JOIN `C:\LOCATION`.`LargerSheet$` ...
0
votes
1answer
41 views

How to automatically replace Excel formula with value when date/time condition is met

I need to record results of a constantly changing cell based on external criteria. Cell B3's value is changing, and I need to record the value of B3 at specific points in time. Cell D2 contains the ...
0
votes
2answers
22 views

How do i change the date format to UK in Excel 2011

My Excel 2011 for Macbook will accept input of dates only in US format MM/DD/YY. I would like to enter dates in UK format DD/MM/YY.
1
vote
1answer
25 views

How to have a cell that displays the cumulative value of all values entered in another cell?

I want to have a cell on my spreadsheet that updates in a cumulative manner, in response to values being changed in another cell. What would the code for this cell be? For example the original value ...
0
votes
2answers
17 views

How to use SUMIFS function for summing values if criteria range exists in a range?

My data: A B C a 3 d b 1 a c 8 e d 5 I want to use SUMIFS function, sum range is B1:B4, if the corresponding value in column A exists in column C, sum the values in column ...
0
votes
3answers
22 views

How to add Time to Date in Excel

I have a cell that contains "01.08.2014", which is a date. I want to use a formula to turn it into "01.08.2014 00:00:00" which is supposed to be date and time.
0
votes
0answers
21 views

How to stop Excel from holding copied data in that window?

It's not the best title, but what I am trying to do is: Copy cell from Excel Paste into Chrome, find the needed data on Google Go back to Excel and paste the new data in different cell What ...
0
votes
1answer
28 views

Change text in a cell depending on date in another cell

I have used conditional formatting to change color based on the text in column H. Now I want to change the text in column H's cells depending on the date in column L. If the date is equal or later ...
0
votes
1answer
24 views

Conditional Formatting of a column based on values of another column

I have two columns in a spreadsheet both with text values and over 30,000 rows. I need to highlight the cells in column B if the text from column A exists in column B. So, if the text in A23 is found ...
0
votes
1answer
26 views

Ignoring value IF “[Value_if_false]”

I am trying to figure out the average difference in monthly sales versus previous years, and I have an IF function within an Average function. I want to skip zero values in the average function if the ...
0
votes
1answer
20 views

Excel: Referencing a named range inside a formula

I have two tables, the first table has 6 column and each column has a defined range name as follows: Col 1: Broker_Name Col 2: Broker_Market Col 3: Client_ID Col 4: Client_Location Col 5: ...
-5
votes
1answer
17 views

Putting a value to a cell

I'm not sure if this can be done, but I figured I would ask. I am creating a spreadsheet and I want each cell to have a dollar value. so for example b6 I want it to be worth $11.00 but I also just ...
0
votes
0answers
14 views

Creating a chq database in Excel

I have made a spreadsheet for printing on business cheques. I was hoping transfer the information into another sheet which will list all of the chq's I have printed. Ideally, I would like the ...
0
votes
1answer
11 views

Excel (Dependent) Data Validation Across three seperate fields

I am looking to create a data validation formula which will allow me to check against multiple fields. Amount Claimed, Amount Approved, Amount Paid. The Amount Claimed is first entered. From there, ...
0
votes
2answers
34 views

Excel SUMIF Advice

I was hoping you might be able to help. I'm collected data in excel from a data source. The data source has 3 headings Active,Occurrence,Time (seconds) TRUE, 1, 0 TRUE, 1, 12 FALSE, 1, 12 ...
0
votes
1answer
21 views

Excel formula to calculate the total hours worked

I am working on our activity in lab. I want to know how to get the total hours worked while considering the following: If the employee worked before 1:00pm, deduct the hour the employee came out to ...
0
votes
1answer
18 views

Excel - import data from cell automatically when a new tab is created

I am working on a spreadsheet summarizing data from standard templates inserted in a joint Excel file as separate tabs. Is it possible to automatically import data from a specified cell into a ...
0
votes
1answer
34 views

Compare multiple columns with another sheet and if matched return true

I have a sheet named Test with columns [Category],[SubCategory],[Name], [Is in share?] that need to be compared(except for the column [Is in share?]) with the sheet named Share. Share also has ...
1
vote
3answers
39 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
39 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
26 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
20 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
20 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
22 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
42 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
25 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
44 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
37 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
58 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
35 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
23 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 ...