The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

12 views

### Calculating partial values for use in a weighted average

I have a spreadsheet with the following information:
Column A contains a list of courses (eg Course 1, Course 2, etc)
Column B contains the number of credits available to each course
Column C ...

**2**

votes

**1**answer

10 views

### Index-Match returning value in cell above desired value

I have a couple index matches going on in a workbook I'm playing with. I basically have a huge lists of addresses in a table and I'm trying to pull specific ones to get mailing codes. I index match ...

**0**

votes

**1**answer

17 views

### Selecting a value based on a lookup value that fits between two values

I have a Worksheet in which I have two "tables" looking like this:
What I'm trying to achieve is to do the following:
Take the first two digit in Column D (for the first row 77)
See which row in ...

**0**

votes

**2**answers

40 views

### Convert YYYY-DD-MM HH:MM:SS to Days

I've extracted data from a power grid website and the time stamp corresponding to each power value is in the format YYYY-DD-MM HH:MM:SS on Excel. I need to convert this to days but am struggling. The ...

**0**

votes

**0**answers

11 views

### Spreadsheet using data connection plots line graph points as zero

I have an Excel 2010 spreadsheet that uses a data connection to transfer data from another Excel 2010 spreadsheet.
When I try to draw a line graph of date (column A) against ammonia (column I), all ...

**-1**

votes

**0**answers

17 views

### using powershell, is it possible to convert an XLS file to XLSx?

I am trying convert and Xls file to XLSX format using powershell but I cant seem to get this to work
$xlExcel8 = 56 This command does not seem to want to convert to XLSX, not even sure what that ...

**0**

votes

**1**answer

38 views

### comparing and updating columns in excel [on hold]

I have 2 columns: id and contact number.
column A contains few id
column B contains their corresponding updated contact numbers
column D is full list of id
column E is their corresponding full list ...

**0**

votes

**0**answers

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

**1**

vote

**0**answers

18 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

38 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

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

**3**

votes

**1**answer

25 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

20 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

26 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

22 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

19 views

### Excel problems with £ sign

I'm making a spreadsheet and some of the columns have phone numbers included. I keep adding to the sheet, and as I do, the new rows aren't letting me type a leading 0 or the £ sign.
I need to use ...

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

21 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

62 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

23 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

48 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

326 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

33 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

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