The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

17 views

### How to print multiple filters of a pivot table at once?

I have a pivottable with filter. The filter contains a list from 1 to 20, each of which must be printed separately. That is, each time I have to change the filter and print the filtered result.
Is ...

**0**

votes

**1**answer

30 views

### VLOOKUP across multiple worksheets in different workbook (Excel 2010)

Apologies if I placed this in the wrong place.
I am trying to create a VLOOKUP across multiple sheets in from another workbook, all the sheets have the same data and same layout, the VLOOKUP is in a ...

**-1**

votes

**0**answers

8 views

### Add a new row in excel 2010 using information from a user form

I am very bad with excel and have been asked to do several projects for work so you will probably see me posting here a lot within the next few weeks! I created a user form and I want users to be able ...

**0**

votes

**4**answers

69 views

### Can Excel update sheet reference (like it can with cell) when I paste content of one sheet to another?

I have a document where I create a new sheet which represents days (has to be that way). Each sheet has a reference to the same cell in the sheet that represents the previous day. So sheet "Tuesday" ...

**0**

votes

**2**answers

49 views

### Excel function that works out the average by first excluding all zeros and then excluding the minimum and maximum value

I have around 300 values on an excel spreadsheet (many of which are zero) and I want to work out the average by excluding the zeros, the highest value and the lowest value after zero. What would be an ...

**1**

vote

**1**answer

48 views

### Is it possible to add some vertical lines to a Waterfall Chart in Excel 2010?

I'm using a (modified) Waterfall Chart to show progress while tracking IT Certifications (amount) on a monthly basis. This is intended to be an ongoing work but all I'll be tracking is the last 12 ...

**1**

vote

**0**answers

12 views

### Error when connecting an Access query to an excel sheet -expression in query prevents connection being made

SCREENSHOTI have an excel sheet which is linked to a query in my Access database (both 2010 version). It works really well and I decided that I wanted to have the same excel sheet but to only contain ...

**0**

votes

**0**answers

8 views

### Combine multiple workbooks according to a given criteria

I have difficulties writing a VBA code for a situation I am facing with. Below, I will give a short example.
I have a folder with multiple files and they are saved with the following name format:
...

**0**

votes

**1**answer

23 views

### How to automatically create a copy of a list that filters out rows that have/do not have contents in a specific column?

I'm trying to manage a customer list.
I have a sheet that has all customers on it.
Some customers have emails, and others don't.
From this full list, I need to create two separate lists.
A list ...

**0**

votes

**0**answers

19 views

### Excel Truncates values with spaces between the text

I have a strange situation with Excel 2010 VBA. I am using ADODB recordset to get data from Teradata database and assign the value to Excel cells. One of the values which has spaces between the whole ...

**0**

votes

**0**answers

14 views

### Refresh Excel Connection without source being open

Morning all,
I have a query regarding refreshing Excel connections.
I have a company workbook that has many sheets and is in constant use all day, however I have a connection created to this which ...

**1**

vote

**0**answers

28 views

### How to Mirror Cells when the source is a data validation list? (Excel 2010)

I have a workbook with two tabs. The first tab is being used as a table for data validation lists I'm creating in the second page. For example, one list is called "Supervisors". This list starts cell ...

**0**

votes

**1**answer

38 views

### Turn cells in a column a color based on another column

My spreadsheet has conditional formatting that turns a cell in Column M a color when the cell value is NOT "N/A." How do I also change the color in Column A based on the corresponding cell in Column ...

**0**

votes

**1**answer

44 views

### Transfer one digit to one cell in Excel

I'm trying to transfer one digit of a number into one cell from one workbook to another.
Example:
Worksheet 1: 1,234.56
Worksheet 2: A1 A2 A3 A4 A5 A6
1 2 3 4 5 6
...

**1**

vote

**0**answers

14 views

### Excel 2010 populate based on another sheet

I need some help with dynamic range and auto populate.
I have a sheet with 2 Columns, 1 is the name and the other is the age between 6 and 12. There are 20 rows.
http://imgur.com/utTJzF3
In another ...

**-1**

votes

**0**answers

8 views

### Compare and Highlight Duplicates/repeatition in Workbook after Workbook has been updated

I have periodically updated workbook sent to me. The issue is that it is difficult to identify the difference between the older workbook and the updated ones because there are hundreds of rows. Is ...

**1**

vote

**1**answer

21 views

### Horizontal Axis of Line Chart Does Not Adjust - Excel

I have a line graph whose source data come from a pivot table. However, the number of rows in this pivot table may change and the chart's horizontal axis do not adjust to that. How can I adjust my ...

**0**

votes

**1**answer

23 views

### CountIF/CountA using Array Functions

I have a list of projects in various countries (each row is a distinct project; countries are listed in Column A). Each project can have multiple tags (e.g., demand, pedagogy, ICT, etc.). For a much ...

**0**

votes

**1**answer

49 views

### How to change a negative value to a positive number not exceeding 49

Hi I have the following question that I am struggling with solving
I have si numbers from a lotto draw to which firstly I would like to subtract each number by 25 and record into cells , therafter if ...

**0**

votes

**1**answer

77 views

### Mirror cells when a change in either cell updates the other

Gary's Student answered this question before and it worked great for only 1 cell per sheet.
If I wanted to mirror multiple cells what could I do? I have tried the following and it does not work. I do ...

**-3**

votes

**0**answers

22 views

### How to take inputs and create database in excel

I apologize in advance for the broad question.
I am using excel to keep a database of a group of around 20 people and (theoretically an infinite amount) of companies for a school club.
Basically, I ...

**0**

votes

**1**answer

41 views

### First date that matches criteria

I have 2 columns, LotNbr and ShipDate. I'm looking to create a column that contains whether the ShipDate was the first date for that LotNbr:
LotNbr | ShipDate | FirstShipment
aaaan1 | 1/1/2016 | yes
...

**0**

votes

**1**answer

51 views

### Excel Sheet Format, Showing Parent/Child nodes & Information

I currently have the following format in excel:
Does anyone have any suggestions on how to display this information in a 'prettier' way? I will have many nodes and many 'information columns'.

**0**

votes

**1**answer

23 views

### What is the correct If Then Else formula to use in this situation?

Column A Column B. Visa. MasterCard
5429********6324. 12.75
4728********7632. 75.16
Column A and B represent the format in which I receive downloaded credit card payment ...

**0**

votes

**0**answers

22 views

### Use VBA to set printing settings for multiple workbooks

I have more than a hundred workbooks within a certain folder and I need to set the printing format as "Landscape" & "Fit all columns on one page" for all of these workbooks.
Is there a Macro that ...

**0**

votes

**1**answer

31 views

### Excel Graph Display Data

I have been attempting to create a line chart where my month data is on the left and my name is on the bottom, and for the graph data labels are added to show the count for the past 90 minutes and I ...

**1**

vote

**2**answers

34 views

### Excel 2010 - set format on all cells - even blank ones

So an odd question, maybe really easy. I have a large spreadsheet, with a few columns that will be filled in by various users as time goes on. Currently those are date columns, however, this question ...

**0**

votes

**2**answers

28 views

### How to deal with blank cells on an IF (OR) statement

I have a formula that works, but my problem is with column G.
If the cell is blank in column G then it returns #VALUE.
Does anyone know of a simple way I can fix this?
The formula is below:
=IF(...

**0**

votes

**2**answers

43 views

### In Excel, I am trying to calculate a percentage of two sums

I have a rather large dataset, 44 columns and about 8k to 9k rows each month. The table has every trip that our customers have either completed or not shown up for. I have started with a simple pivot ...

**0**

votes

**0**answers

15 views

### Excel Windows 2010 - have database and want one column to sort automatically as data changes

I have an excel spreadsheet with formulas
a) one column sorts the difference from the current price (col K or L) and the old price ((g or I)
b) there are 20 rows
this is the column formula (M) ...

**0**

votes

**0**answers

20 views

### Pivot Table to Show Percent SUCCESS Scores ONLY

How would I adjust the pivot table to show only the percent of scores with SUCCESS and hide the FAILS? Hiding the fails changes the SUCCESS scores to all 100%. I can hide rows in the pivot table, ...

**2**

votes

**3**answers

101 views

### Allow selecting but not editing a chart and slicers in a protected Excel sheet

I would like to share an excel file that has slicers and charts in it. I want users to be able to use the slicers for filtering and then select and copy the charts. But I want to protect the sheet and ...

**0**

votes

**1**answer

80 views

### Excel 2010 - how can I combine 2 rows of data into 1 row (multiple columns of data) across numerous rows

I have multiple rows of contract data that have the same 'Synonym ID' that require the information from 'Device1' and 'Service1' columns to be combined on the first row with that particular Synonym ID....

**1**

vote

**1**answer

22 views

### IF statement that is between two values

Hi im trying to make an IF statement that if data is input in a certain column that isnt between 0 and 100 then it comes up as an error and if it is then it comes up as ok
I want it so that if data ...

**0**

votes

**1**answer

45 views

### Divide Sum of Field By the Sum of Another In Pivot Table Excel

How can I conduct the following calculation in pivot table? Sum the Total Hours and divide it by the sum of the Ticket Count for each Year-Month. Here's a snapshot of my spreadsheet.
The output ...

**1**

vote

**1**answer

31 views

### How can I both copy (not fill series) in excel using the fill handle while also ignoring formatting?

Using the fill handle (dragging the bottom right corner), I'd like to copy a cell down a column, but ignore the borders.
Simply dragging the fill handle will "Fill" the series, eg: count up
(see ...

**-1**

votes

**1**answer

16 views

### Excel Multiple Cells Included in an IF Statement

Hi im trying to make a IF statement using a whole column so that any rainfall data that is entered that is less than 0 is an error and if it is above it is ok
eg:
rainfall
0
0
1.2
3
data ...

**0**

votes

**0**answers

13 views

### List Sort with New Rows - Excel Macros

I am trying to record a macro that sorts my list, but am currently at a wall - I need this sort to adjust to my list depending on adding/removing rows.
My current code scans the list for which cell ...

**0**

votes

**1**answer

25 views

### Identify names with no match on another sheet [duplicate]

I have two sheets that contain mostly identical names but a few names with no match on the other sheet. For example:
Sheet 1
1. Kumar
2. Rajiv
3. Ranjith
4. Supriya
5. Sanjay
Sheet 2
1. Kumar
...

**2**

votes

**0**answers

91 views

### IF AND Statement with multiple condition

Need a formula that can return values MET & NOT MET in Excel 2010
The formula MET or NOT MET at the resolution time.
Below is the formula I tried but something is missing, because not sure how ...

**1**

vote

**3**answers

76 views

### Excel 2010 - Merging two “IF” functions in one cell

I apologize in advance if my explanation is confusing haha
I have two cells (D2 and D4) that I want to add up, but there are two conditions based on two other cells (B2 and B4): "if B2 is less than 1,...

**0**

votes

**3**answers

81 views

### Excel VBA - code to skip lines / goto command

I have built a code into excel to take the data from a pivot table and insert it into a chart, a pivot chart directly linked to the table wont give me the manueverability I am looking for. The reason ...

**0**

votes

**2**answers

83 views

### Why do I have to hit tab twice to Alt+Tab away from Microsoft Excel?

In other apps, when I hit Alt+Tab it switches to the previous app. Before I actually release the Alt key I can see a list of windows as well and the previous windows is selected. But in Excel 2010 (...

**0**

votes

**1**answer

24 views

### Sheet comparisons in Excel where content is mostly text

I've got a a document that entails recommendations for my place of business, specific to site (we own several smaller facilities) with several sheets. The first is a full, all-inclusive list. The ...

**1**

vote

**1**answer

29 views

### VLOOKUP error when looking up date

I have been trying to use the CONCATENATE function in the Excel for creating multiple values of the financial statements for different years. My main formula is as shown:
=VLOOKUP(TEXT(CONCATENATE(A1,...

**3**

votes

**1**answer

38 views

### TODAY() function with specified time

I need to get a date/time that represents the current day at 6:15 AM. The TODAY() function takes care of the date, but I can't figure out how to append the time constraint to that.
Usage will be in ...

**0**

votes

**1**answer

21 views

### Output blank cell when source cell is empty

I have a workbook with two spreadsheets - "Subscriptions CD" and "Subscriptions PD" - where I need to identify the new orders on the "Subscriptions CD" worksheet and mark these entries as "NEW" by ...

**0**

votes

**1**answer

43 views

### How to find the date of the last matching row?

So I have a master spreadsheet that has 20k+ rows containing monthly leasing data. It has information like a person's name, when they leased a car, what kind of car they have, etc. Most of the rows ...

**1**

vote

**1**answer

22 views

### Suggestions on how to integrate a very large block of text into Excel

I've been working on an Excel assignment where I have a data table of information, and beside it I want to write my analysis and recommendations for each of the lines of data.
Some criteria:
I don'...

**0**

votes

**1**answer

33 views

### Excel 2010: Blank pasted cells require activation causing formula issues

I'm having a problem copy/pasting from one Excel file to another.
I have a workbook with forms for entering data. Recently, I added a sub to auto-capitalize the entry cells.
Private Sub ...