The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
9 views

Nested Ifs for personal accounting sheet

I have a personal accounting sheet with 5 columns. C is Debit, D is Credit and E is Balance. I want to do 3 things but I've been confusing myself for the past hour. If C5 and D5 are both blank, ...
0
votes
0answers
5 views

Sort a pivot table according to % of Row Total

My pivot table compute the sum of sales amount of products in different regions (row field) according to product type (column field). The values which we want is the % of Row Total (so that we can ...
0
votes
1answer
14 views

How to delete a row if first word of 2 cells in that row is a same

This has 4000+ entries. I just want to keep the rows where the Property Address is not similar to the Owner Address. Example: Property Address Owner Address 4 Belar Street 1 BELAR ST ...
-2
votes
0answers
19 views

Formula wanted please [on hold]

A B C 705513390 AB-BC-123 10 705513390 AB-BC-123 10 705513390 BBBB-123 5 I need a formula that will return column C based on a search for AB-BC or BBBB and also ...
0
votes
1answer
25 views

Special format of date in excel

A customer wants a special format of a date column in excel. What he wants is that the date (for example 02.06.2014 and formatted as short-date) changes to a number (41792) when the format changes to ...
1
vote
3answers
32 views

How to find average of first difference in one set of column excel/google docs?

I have one column with numbers eg. 130, 131, 135, 140, 120.., I would like to find the differences eg. 131-130, 135-131, 140-135.. and find their average without using another column to find the ...
0
votes
1answer
18 views

Excel 2010 adding to an adjacent cell

I want to add B3 to C3 leaving the answer in C3, I have tried =C3+B3 in C3, a message regarding circular references, I continue and the result becomes a zero
0
votes
1answer
22 views

Excel 2010 VBA to remove duplicates and then sumif base on the unique data

My work requires data comparison from 2 different sources (sheet 1 is source 1 and sheet 2 is source 2). Both sheets contain duplicate values (the Delivery Order) Because I need to do this kind of ...
0
votes
1answer
9 views

Share Excel “Template Formulas” between sheets

I have a spreadsheet that takes user inputted values and performs some fixed computations to generate a number of cells. I plan to use these computations in a number of sheets with different user ...
0
votes
1answer
17 views

Look up specific string in row (not column) and return value of cell x columns left of that location

My data looks like this: Sheet 1: A B C D E F 1 2 3 a b c 1 2 3 a b c 1 2 3 a b c Sheet 2: A B a b c Now on Sheet 2 in Column B I would like to return the result of: look up each value of ...
0
votes
0answers
4 views

Failing to use a split cell range as data source for a pivottable

I want to create a pivot table from this table I have, but I want to leave out some of the rows. So, suppose I want to keep the header row, leave out the next ten rows, and use the next 10 rows. This ...
1
vote
1answer
24 views

Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...
-3
votes
0answers
15 views

Have data from one worksheet auto populate different tabs

I have a large spreadsheet data twenty columns, hundreds of rows. In column A, I have many sub categories. I sort by sub category and then cut and paste each sub category into a separate tab. The ...
3
votes
1answer
21 views

Freeze multiple columns in excel using macro

Under the Freeze panes, Excel currently offers Freeze panes, Freeze first row and Freeze first column options. I was looking for an option where I can freeze the first N-columns. I did a record macro ...
0
votes
1answer
12 views

Turn off automatic display of properties

In my workplace, any time I open an Excel sheet (Office Professional Plus 2010) the "Document Properties" or "Other Properties - Server" docked dialog appears at the top of the document, dominating a ...
0
votes
1answer
18 views

Date values displayed as numbers instead of dates

Whenever I type a date into one of my worksheets the cell displays the value as a number not a date. The cell's value is a date and the format is date but the text displayed is a number. ? ...
0
votes
0answers
9 views

Show the filtered name from a list in a different cell

I have a table of data. The field headers are: Date, Name, Result, Running Avg. From this data, I have created a graph. I want to filter by 'Name' and the graph will show only that Name's Result ...
-1
votes
0answers
14 views

How can I list the highest repeated pair of numbers from 47 million pair of numbers in MS Office Excel 2010?

How can I list the highest repeated pair of numbers from 47 million pair of numbers in MS Office Excel 2010? The highest repeated pairs will be around 400 000 to 600 000.
1
vote
1answer
44 views

Excel 2010 VBA to Hyperlink Active Cell to itself, so it would lead to it's exact location from when that cell is pasted and sent in Outlook e-mail

Objective: Excel 2010 - VBA to Hyperlink Active Cell to itself, so it would lead to it's exact location on spreadsheet from when that cell is pasted and sent in Outlook e-mail. I need to keep the ...
1
vote
1answer
43 views

Excel : how to put a literal dot into a cell format

Whenever I put a dot character into a custom cell format Excel will interpret it as if I want a decimal separator in that location of the format. The problem being that decimal separator changes with ...
1
vote
1answer
17 views

How do I take the information from 1 spreadsheet and count it on another spreadsheet based on a set range of values?

I have 2 spreadsheets in the same work book. On the first, I have dates names and others values (y/n, amounts). I need to be able to put in a date range on the second spreadsheet and have it take data ...
0
votes
1answer
26 views

Excel issue with =MID()

I pull a report, In Column B it has about 125 words, 1100 characters including spaces. I wrote a =mid() Formula which pulls the server name out of the text without an issue. =MID(B2,FIND("Old ...
5
votes
2answers
34 views

How can I add / upload bulk entries to Excel 2010 Autocorrect?

I currently have about 200 entries of autocorrect but it's painful to add one by one manually to "autocorrect" (File > Options > Proofing > AutoCorrect Options > AutoCorrect tab). These entries are ...
0
votes
0answers
4 views

Is it possible to autofit a resized row with wrap text?

I want to autofit a resized row that is wrap text enabled. It is wrapping the text but it is not autofitting. Is it possible to auto-fit a resized row (without VBA)? I resized the row to 30 pixels ...
0
votes
0answers
25 views

Exteremly Slow Microsoft Excel operation in LENOVO G550 series Laptop; Shall I add more RAM?

I am doing complex Macro operations in Excel 2007/2013 which generates random numbers and does many multiplications/divisions in each cell value. It also copies data to multiple worksheets and text ...
1
vote
1answer
30 views

How do I create a cascading drop down link in Excel?

I want to create a cascading drop down link in Excel 2010. My requirement is when we click when we select any color from dropdown list related color fruits will displayed beside.
0
votes
0answers
29 views

Macro to copy distinct values to another sheet, based on value in another cell

I'm using MS Excel 2010. My data set consists of a list of calls performed by employees of three different companies. My workbook has one sheet (let's call it "Sheet1") where each row corresponds to a ...
0
votes
0answers
9 views

How to unhide rows, when Format, Visibility, Unhide doesn't work?

All I did was highlight rows 29,30,31,32 I then right clicked and selected Hide Rows. Now I want to unhide them. But nothing seems to work. I've tried the following: Placing my cursor between ...
0
votes
2answers
38 views

IF statement with multiple criteria and multiple possible results

I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...
0
votes
2answers
27 views

Microsoft Excel 2010 the difference between two times in two different cell

Other answers helped but have a problem with the following Start Time 23:56 End Time 0:32 difference is 36 minutes. Start Time 21:53 End Time 22:05 difference is 12 minutes. What formula can I use ...
0
votes
0answers
23 views

Is it possible to share a hyperlink in en outlook email to a specific excel worksheet?

I have an Excel workbook which I can shared by sending a hyperlink to this file by e-mail. But I do not just want to share the file, but link specifically to a certain worksheet. I know that linking ...
1
vote
1answer
33 views

Grand total of calculated field of pivot table

My pivot table summarizes the total number of items sold and calculates commissions, say: ItemA 15 $150 ItemB 6 $30 ItemC 9 $45 Total 30 $300 I want to calculate commission to salespersons: For ...
0
votes
2answers
37 views

Fill cell with sheet name Microsoft Excel

I have an excel file which has around 100 sheets in it. Each sheet is for a student, and each sheet name is the firstname_lastname e.g Mark_Hope so what I want to do is that in each sheet there are ...
0
votes
1answer
13 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
0
votes
2answers
36 views

Combine Excel tables

I need to combine two excel tables(Table 1 & Table 2) to result as Table 3. New week column will be added every week with new data. The Table 2 could be added to Table 1 or can be combined into a ...
0
votes
1answer
38 views

Need macro to transfer Word data into Excel

I am very new to VBA and need help ! I have VB macro in Excel that grabs the data from a Word document and imports it into Excel worksheet. Currently, the code in macro has expression that clears the ...
0
votes
1answer
37 views

Group values in Excel

I have 500 rows of items. I need to enter these in an application where I can enter a maximum of six items at once by creating a unique Group ID for these six items. The items in a group share the ...
0
votes
2answers
23 views

How do instruct a cell to display a minimum value?

I currently have the following formula in a cell:- =CEILING(E9*0.85, 1.25) I would like the cell containing this formula to display a value no less than 20 but only when the value of E9 causes ...
0
votes
0answers
7 views

getting formulas to update correctly

I have one main spreadsheet (call it A)that imports totals from 2 other spreadsheet (call them B & C) every so often I have to enter new names and delete old names on Spreadsheets A,B,C. How do I ...
0
votes
1answer
20 views

Combining 2 named ranges into a single series line chart in Excel 2010

How do I combine 2 named ranges into a single series. I have months on the X axis and average hours per month YTD on the Y axis. I want to separate the average hours into financial years i.e. the ...
0
votes
1answer
21 views

How to copy range from an unactive workbook

I'm simply trying to copy and paste between workbooks in VBA without first activating each workbook that I want to perform actions on. My code stores the active workbook and sheet in variables before ...
1
vote
1answer
28 views

Compare efficiency of excel formulas

Is there any way to directly compare for calculation efficiency side by side two different formulas for achieving the same goal in excel? Say I want to know which is more processor intensive (or if ...
0
votes
1answer
34 views

How do I set a dropdown in excel to populate different data in cells below based upon the option selected from the dropdown?

I am attempting to clean up a spreadsheet that we have that tells us what permissions to grant for certain roles in our ticketing system. I have used the Data Validation tool to create my dropdown ...
0
votes
2answers
29 views

Excel removing my last significance digit

I am building from external data a table where columns can have one or two decimal numbers. For one decimal number I want 1.0 instead of 1 and for two decimal numbers I want 1.40 instead of 1.4 The ...
0
votes
1answer
14 views

How to create header in MS Excel?

How to create header in MS Excel? So they will not move while I am scrolling the page and will not be affected when I am sorting any column. Till now I use: select row, go to View > Freeze Panes > ...
0
votes
0answers
14 views

Split single spreadsheet into multiple sheets based on highlighted values in three different columns [on hold]

I am using Excel 2010. I have a single spreadsheet with 10 columns, the last three columns (for instance L, M and N) having conditional formatting, i.e. highlights a minimum value among three. I want ...
0
votes
1answer
37 views

Excel - How to check if and in how many rows a certain value/string is present in range

I have a list A of strings and I want to see if and if yes in how many rows each string is represented in range B. My data looks something like this: List A: aaa bbb ccc Range B: 1 aaa --- --- ...
1
vote
2answers
45 views

Reducing rows in column to match another column in Excel

I have two columns in Excel of the same type of variable called Reduced Store Numbers and Original Store Numbers. Reduced Store Numbers has fewer rows than `Original Store Numbers. I want Original ...
0
votes
0answers
15 views

Save filter options, specifically on a Pivot table, without copying the table

I have a bunch of data summarized in a pivot table that gives me a list with multiple filters. Normally, at this point I would paste the whole list as values, before then selecting other filter ...
4
votes
1answer
371 views

Does Excel always calculate hidden rows?

If I have Excel sheets with long filtered lists, and I recalculate while a filter is applied, when I remove or change filters, can I always guarantee that Excel will have already calculated all hidden ...