The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

8 views

### Copying data from a mixture of protected and unprotected workbooks in Excel

I've been given 16 productivity-tracking spreadsheets from a team, and tasked with pulling the numbers from all the sheets into one, for a 'team average' type deal.
Two of the 16 workbooks are ...

**0**

votes

**0**answers

8 views

### Excel VBA Run-time error '1004': Applicated defined or object-defined error - Need code assistance

This is the code that I am having an error on in Excel:
Sub Start_EndDelayInMonth()
With Sheets("Analysis Worksheet")
Dim i As Long
Dim LastRow As Long
LastRow = Range("N" & ...

**0**

votes

**0**answers

7 views

### Excel 2010 Worksheet Auto Populate

I have several tabs in my workbook. Information is everywhere. In one tab I have Net Revenue by project number. In another tab, I have the names of all the projects, the states where they are and ...

**1**

vote

**2**answers

33 views

### Microsoft excel - formula dragging

How can I drag a formula to all the adjacent columns with similar intervals in it?
For example:
in column F, the formula is ('Time sheets'!G10-'Time sheets'!F10)*24
and in column G, it's ('Time ...

**0**

votes

**1**answer

19 views

### Microsoft Excel spreadsheet to JSON?

I would like to create a JSON file from an Microsoft Excel (.xlsx). The sheet has all of the cells a certain height and width. I would like to have the top of each column be titled and used as a key ...

**2**

votes

**1**answer

24 views

### Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget.
Cells look like this
A B C D
DATE WEEKLY BILLS TOTAL
2015 $50 $1,956.73
Jan ...

**0**

votes

**0**answers

14 views

### EXCEL macro opens document but does not ask to “update links”

I have an WORD doc with links to cells in an EXCEL document
If I open the linked document manually, it asks to [Update automatic links] and works perfectly but, when I use the macro
...

**1**

vote

**0**answers

28 views

### Shortcut for Direction Keys — To keep hands on QWERTY end of the keyboard

I use a lot of Excel and finally got myself used to the ThinkPad pointer whereby I no longer need to take my hands off the keyboard for scrolling.
But now I need to take my right hand off the ...

**0**

votes

**0**answers

11 views

### Performing and interpreting a Fourier Transform with the Excel Data Analysis Pack [migrated]

I am confused about how to perform a discreet fourier transform in excel and what the output means. There are many math.stackexchange questions about this topic (see for example ...

**-1**

votes

**0**answers

17 views

### How can I automate the process of printing 2 rows of data from one sheet after pasting it onto the form on another sheet?

Sheet 1 of my spreadsheet has the following form:
A B C D
They are just columns named 'A','B','C' and 'D'.
Sheet 2 has the following data:
A
1
2
3
4
5
6
7
8
9
10
I want to print pages of ...

**-2**

votes

**1**answer

23 views

### How to remove password from password protected and shared excel workbook?(.xlsm file) [on hold]

I have an excel file that I need to crack. My excel version is 2010 but I do not know what version of excel this file is originally made with. This file has the name of file extension, '.xlsm'.
I ...

**0**

votes

**1**answer

22 views

### Color a cell in MS Excel sheet, if do not fall in range

We need to enter lots of data in a excel sheet. Later we want to color code that data.
I will be the one preparing this excel sheet and sharing with team. What I want is the moment I put a number and ...

**0**

votes

**2**answers

35 views

### Data validation in Excel- all values in comma-delimited list within cell range

I have a reference table of memos and some information about them, including what other memos they reference and are referenced by. I want to make a data validation rule that will appear red if any of ...

**1**

vote

**1**answer

21 views

### How can I count all cells in a row based on the value in a column in MS Excel 2010?

It's hard to word this correctly, so I'll try to describe it better here.
I have a spreadsheet:
(this is a very simplified version I just made to illustrate what I'm after).
Each person has an ...

**0**

votes

**2**answers

17 views

### Excel problems with £ sign

I'm making a spread sheet and some of the columns have phone numbers in. I keep adding to the spread sheet and as I do the new rows arnt letting me type 0 in first or £ signs. I need to use these a ...

**0**

votes

**1**answer

11 views

### Unable to remove columns based on data-type using Power Query

I am trying to automate a load process and want to know if it is possible to perform column wise operations in Excel Power Query. Specifically I want to know how to either keep or discard columns ...

**0**

votes

**0**answers

20 views

### Locked cells are editable. Why?

Why am I able to edit the contents of a locked cell when the sheet is protected? What am I missing. When I select "Protect Sheet" the only choices I make available are to select locked cells or ...

**-1**

votes

**1**answer

59 views

### How do I reference another cell based on the value of another cell?

No one understood my question which is understood due to my bad explanation.
I'll put an example to avoid further confusion.
In Sheet2 I want to change A2's formula then it will fill B2,C2, and ...

**0**

votes

**0**answers

39 views

### multiple IF conditions and answers

This is a cashflow spreadsheet. I want the column next to the expenses column to show me the source of the expense.
The expenses are arranged in spreadsheets, so for example; checks, taxes, general ...

**-1**

votes

**2**answers

23 views

### In a table of groups and members, how to reduce a certain percentage of members per group?

I have an Excel spreadsheet with a table of groups and members. For example:
A Jonathan
A Roger
A Donald
B John
B Lilya
C Richard
C Lorry
What I want to do is to reduce the number of members per ...

**0**

votes

**1**answer

19 views

### Problems with Excel 2010 “Find” function returning #value

I'm trying to use the Find function to determine the presence or absence of a substring in a text cell. When I use =FIND("string",B21)>0, I get TRUE if the string is found and a #value error if not. ...

**0**

votes

**1**answer

19 views

### Why is the MATCH function is not resolving my lookup array?

In Excel 2010, I am using two Excel tables. One table (ActiveDS) has a single column and contains a list of our active data sources. The other table (ApproverRole) has a number of columns, including a ...

**0**

votes

**0**answers

12 views

### Running Oracle (11g) script in VBA to extract data to Excel [closed]

We have a number of saved Oracle scripts (PL/SQL queries) that we routinely run to extract data to Excel for end users. I know its possible to convert these queries in VBA and add 'buttons' to an ...

**1**

vote

**0**answers

22 views

### Excel - How to link Index/Matching formula with Indirect formula for dynamic column reference

I have a worksheet in which I am looking to utilize the Index/Matching formula to pull in exact values for the unique intersection of Department & Account values on a separate data sheet.
However ...

**1**

vote

**1**answer

47 views

### Extracting Text (Capital Letter)

I download bank transaction history and would like to extract the name of customers which is located at the end of the Description line. Some lines have one or two words preceding the names of the ...

**1**

vote

**1**answer

14 views

### Excel formula to compare two cells for getting lowest value

I need the formla to find lowest price of each category of fruit and SET True for lowest price.
This is the data
**Fruits Price Result**
APPLE 100 False
APPLE 125 False
APPLE 85 ...

**0**

votes

**1**answer

19 views

### Excel TODAY() function

I have two tables in excel
The first table is called Oranges, it shows where the oranges were produced and where they were exported to:
The second table is supposed to show the total oranges ...

**0**

votes

**2**answers

29 views

### Is it possible to have an =if equation involving text and math?

This is what I'm shooting for:
=IF(LEFT(Q3,2)="By","see authorizing lab"&"-"&SUM(Q3-L3))
I'm trying to say IF Q3 says "By" the return "see authorizing lab" if not then subtract L3 from Q3 ...

**3**

votes

**1**answer

323 views

### Omit weekends and/or holidays in days to complete formula

Is there a way to not include weekends and or holidays in an Excel formula involving dates? Example:
=Q2-Q1
(a date in q2 minus a date in q1 = so many days) Excluding weekends & holidays?

**1**

vote

**0**answers

17 views

### Is it possible to maintain internal links when converting Excel workbook to PDF? [duplicate]

I'm trying to add a table of contents page to a report I make with Excel 2010, so that if I click on an item in the table, I will jump to the corresponding page / tab in the workbook.
I'm able to do ...

**1**

vote

**1**answer

13 views

### In Excel 2010, is it possible to desc order series on chart without changing the order of source data table?

I have a source table that looks like this:
What i'd like to do is, for each period, create a separate column chart that displays Items by their values in desc order. There will be 5 charts in all.
...

**0**

votes

**0**answers

17 views

### How do i expand the very 1st column in excel 2010 showing the numbers

Using excel 2010, when I scroll down to row 100, I cannot see all 3 digits and only see 00. I cannot widen the column.

**0**

votes

**1**answer

9 views

### auto-fill a formula referring to table columns without mouse (keyboard only)

I'm working with formulas summarizing table columns (e.g. SUM(Table1[Column1]) and I would like to fill the formula to the right using only the keyboard.
When I autofill my range by mouse drag, it ...

**0**

votes

**1**answer

7 views

### Display empty cell if referencing empty cell (formula)

I'm working on an excel spreadsheet, and im aiming for a clean interface with almost all cells filled with specific formula.
Ex formula on column V : =IF(G1=" LNN ","PENDING", "N/A")
What's ...

**3**

votes

**2**answers

24 views

### Drop Down List and one formula

I am trying to get an average depending on two drop down lists.
But i would like to get an average even when the second drop down has no input in it.
The formula I use is a simple: AVERAGEIFS with: ...

**0**

votes

**1**answer

31 views

### Is there a formula to look for partial text in a cell?

This is what I'm using right now in the formula:
=IF(E6="Mix Design Gr S","By Mix Design","")&IF(E6="R-Value","By Soils","")&IF(E6="PS Package","By Soils","")
Is there a way to only look for ...

**0**

votes

**1**answer

9 views

### Display blank rows within subheading in Excel 2010 [on hold]

New to pivot tables--I have a pivot table that shows regions and lists states under the appropriate region based on data table. I would like all states within each region to show, even if there are ...

**0**

votes

**1**answer

28 views

### How to default Macros to run from This Workbook, NOT All Open Workbooks?

We have a macro enabled workbook (ver. 2010) that many people use. A few of these people have macros in their Personal.xlsb workbook. We have a situation where the macro in the shared workbook is ...

**0**

votes

**2**answers

32 views

### How to extract the string from between the Nth and N+1th occurence of a character in Excel 2010?

I have a spreadsheet with a column that contains a list of one or more database names. Unfortunately, the turnaround time to get this report altered is long. So I need to manipulate the data.
The ...

**1**

vote

**1**answer

39 views

### Finding unused names in Excel [duplicate]

I was curious if anyone would be able to help me or give me some direction. I have a worksheet with the following sort of data.
+---+----------------+--------+-----+----------------+
| | A ...

**1**

vote

**1**answer

28 views

### How to Calculate Total Less Duplicates?

I am attempting to create a formula that calculates deviations from a certain parameter threshold in hours. The parameters being recorded are water flow in gallons per minute and chemical addition. ...

**0**

votes

**2**answers

44 views

### EXCEL VBA works with F5 - but will not run automatically when cell values are changed

The VBA formula works perfect with F5
Column E cells E3:E5 have Functions that calculate to a dollar amount or $0.00.
This is the formula pulling from =SUM('MEDENT Proposal - Creator'!B15*15)
...

**0**

votes

**1**answer

18 views

### EXCEL automatic Tab Color change not updating

I have a formula for Automatic Tab color change that works when I manually change the cell, but it does not work when the cell is changed by a function updating it from another sheet: =SUM('MEDENT ...

**0**

votes

**0**answers

40 views

### EXCEL formula - Runtime Error 28

I have a VBA that works - but leads to a Run Time Error 28 after a while.
Colum B3:B11 have Hide or Show from a function in them
=IF(E3=0,"Hide","Show") E3:E11 has a dollar amount or 0 from another ...

**1**

vote

**1**answer

35 views

### Carrying a conditional formatting formula from one reference row to another reference row

I have month wise reference row to use conditional formatting. They are arranged like Target Date as reference row and actual dates are arranged below the target date suppose it contains the actual ...

**0**

votes

**1**answer

40 views

### Automatically run VBA macro whenever a cell value changes

I have a macro that works perfectly - except that I have to manually run it.
I cannot figure out how to have it automatically run when I change values in other cells.
Sub ...

**0**

votes

**1**answer

18 views

### Within a Cell TEXT then A1 then TEXT

I wrote a function that allows me to pull data from Cell E2 and insert it after text.
Cell E2 has number 555.
In cell E3 I have added function ="Total: "&E2 giving me output Total: 555.
I want ...

**1**

vote

**0**answers

9 views

### Link with UNC path is broken after copying cells from Excel 2010 to Word 2010

I am trying to copy an Excel table to Word in Office 2010. Basically, if the hyperlinks are pointing to my local hard drive, there are no problem at all. However, if the hyperlink is pointing to a UNC ...

**0**

votes

**0**answers

13 views

### Converting traditional pivot table to data model based

When creating a pivot table, there is an option to add data to the data model. If a pivot table was originally created without this option enabled, is it possible to convert it to a data model backed ...

**0**

votes

**0**answers

21 views

### How can I speed up functions in Excel? How I can make my sheet/worksheet faster? How do I know how long took create something in Excel?

I have long functions in Excel that use other sheets in my worksheet for example :
{=INDEX(
Sheet1,
MATCH(
$A2 &
MAX(
IF(
( 1 * ( $A2 =
...