The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

6 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

**0**answers

2 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

**1**answer

20 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

**0**answers

13 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

**1**answer

18 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

**1**answer

11 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

**1**answer

16 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

**0**answers

8 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

**0**answers

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

**1**answer

37 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

**1**answer

42 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

**1**answer

16 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

**1**answer

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

**2**answers

32 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

**0**answers

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

**0**answers

24 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

**1**answer

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

**0**answers

23 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

**0**answers

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

**2**answers

37 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

**2**answers

25 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

**0**answers

22 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

**1**answer

31 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

**2**answers

32 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

**1**answer

12 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

**0**answers

25 views

### Filter Unique values in Columns or Cell Ranges from Multiple Worksheets in an Excel Workbook? [closed]

Excel 2010: Filter Unique values from Columns or Cell Ranges from Multiple Worksheets in a workbook?
Essentially, combining data from the 3 cell ranges/ columns in multiple worksheets
Then filtering ...

**0**

votes

**2**answers

34 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

**1**answer

35 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

**1**answer

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

**2**answers

22 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

**0**answers

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

**1**answer

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

**1**answer

20 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

**1**answer

26 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

**1**answer

33 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

**2**answers

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

**1**answer

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

**0**answers

13 views

### Split single spreadsheet into multiple sheets based on highlighted values in three different columns

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

**1**answer

35 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

**2**answers

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

**0**answers

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

**1**answer

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

**0**

votes

**0**answers

30 views

### Create unique and similar list among three columns in MS Excel

I have a dataset from three different sources of the same variable that needs to be consolidated. The three columns need to be combined into one based on similar rows. Three more columns need to be ...

**0**

votes

**0**answers

15 views

### Macro Issue Microsoft Excel 2013 [closed]

I'm currently having trouble with Excel 2013 (Recently upgraded from 2010)
Issue is when running a macro in any sheet it stops me from using any other sheet ie. inputting data into another sheet
...

**0**

votes

**1**answer

16 views

### Putting certain values at the bottom of sort in excel

I have a table that counts the win percentage of players, looking like this:
name games score percentage
name1 6 3 50
name2 10 8 80
name3 2 2 100
⋮
...

**0**

votes

**2**answers

28 views

### Adding time in Excel, for a bus timetable

I am constructing a bus timetable.
I am starting with a base time of 9am (Cell B2), with irregular intervals:
09:05-Cell B3
09:12-Cell B4
10:14-Cell B5
10:20-Cell B6
When the bus comes back to ...

**0**

votes

**0**answers

20 views

### Formulas suddenly become text

I've been working on an extensive Excel list with cell references between sheets and it's been working like a charm, up until now. There is this one cell that refuses to acknowledge that I have ...

**0**

votes

**1**answer

14 views

### graph of computed averages requires data in all cells

I am using Excel 2010 and have created a spreadsheet that allows me to enter questionnaire responses from patients every week and display their average scores for each week on a line graph. Ideally, I ...

**1**

vote

**1**answer

31 views

### Excel: Checksum-like function to check if table copied correctly

I have the following scenario:
I have a spreadsheet A with a large table.
I open spreadsheet B and copy the table from A into it.
I want to check if I copied the table from A to B correctly.
In ...

**3**

votes

**3**answers

81 views

### How to make Excel chart intelligently select data

I got a set of memory usage that I am trying to plot on Excel. I got time, total RAM, used RAM, used SWAP and free SWAP each with its own column.
But if I select all of columns for a line chart the ...