The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
10 views

Parameter VB Code Please

MS Excel 2005 and up. There are three parameters in the spreadsheet tied to a data feed: Parameter1 Parameter2 Parameter3 There are three options to choose: Prompt for value using the following ...
1
vote
0answers
10 views

How to find and replace the character “*” in excel text values in cell, but NOT formulas

Very similar to this question: How to find and replace the character "*" in excel But I need to leave formulas untouched. I've got about 50+ sheets that have two types of cells with "*" ...
-2
votes
0answers
20 views

Excel: How do I use multiple (3) cells to retrieve a value from the fourth column in a table? [on hold]

I am creating a worksheet where I need to use the values in three cells (K9, L12, and L13) in one workbook to retrieve a value from a multiple row and multiple column table in a different workbook. ...
1
vote
2answers
19 views

Values in Excel indented to left, Invisible charecters?

I converted this text file to a comma delimted file, then I set this coulumn of dollar amount to account type, but I am having this issue of number being indented to the left as shown in the picture ...
1
vote
1answer
14 views

How to calculate only in all cells have value

The formula that ONLY displays a sum when ALL the cells it's calculating contain values, otherwise it remains blank. For example, if the formula calculates over 3 cells but only 2 of those cells ...
-2
votes
1answer
12 views

What does “error061160_02.xml” mean?

What is "error061160_02.xml"? I've tried researching to no avail. Any information would be helpful so that may remove the error from my file. Thank you!
0
votes
0answers
15 views

Populate information from on spreadsheet to another on same excel File

I am creating two sheets for one excel file for business conferences . One sheet will be an inventory list of items being sent to conferences, the other a sheet that contains details of the ...
0
votes
0answers
10 views

How do I send a range to comment?

I have a master graph which tells me how many total hard drives I have in stock between front stock, and back stock. It pulls info which is broken down all the way down to part number. One thing I ...
3
votes
1answer
19 views

Checking a range of dates

I would like a formula that will return Yes only if a range of cells in the same row all have dates in the future, and if five other cells in the same row have the value "Yes". I tried to just check ...
0
votes
1answer
11 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
8 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
22 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
27 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
34 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
20 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
23 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
10 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
19 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
1answer
18 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
24 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
50 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
45 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
30 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
39 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
25 views

Is it possible to share a hyperlink in 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
36 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
40 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
39 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
38 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
22 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 ...