The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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