**0**

votes

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**3**answers

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

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

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

**1**answer

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

**2**answers

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

**1**answer

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

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

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

**2**answers

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

**0**answers

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

**1**answer

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