The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
10 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
1answer
20 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
0answers
10 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
0answers
25 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
0answers
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
0answers
15 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
1answer
20 views

How to remove password from password protected and shared excel workbook?(.xlsm file)

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
1answer
21 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
2answers
34 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
1answer
20 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
2answers
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
1answer
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
0answers
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
1answer
57 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
0answers
38 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
2answers
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
1answer
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
1answer
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
0answers
11 views

Running Oracle (11g) script in VBA to extract data to Excel [on hold]

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
0answers
16 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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
30 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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
17 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
0answers
39 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
1answer
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
1answer
38 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
1answer
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
0answers
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
0answers
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
0answers
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 = ...
0
votes
2answers
28 views

defining a measure of unique value counts

How do I define a measure in a data model (withing the PowerPivot feature) with a formula that needs to get a unique count of values. For example, something like this: reset_rate := ...
3
votes
3answers
44 views

Finding previous row with a given value

Let's say I have a table with three columns (order is important and can't be changed), rows are sorted by A: A B C date ID last_date 10/05/2015 ...
0
votes
0answers
21 views

MySQL for excel: import with many digits

I use MySQL for Excel to import data from MySQL to Excel In the MySQL I have this entry values 0.22 0.26 When I import the values to a Excel sheet, I get values 0,219999998807907 ...
0
votes
0answers
8 views

A single scatter plot from multiple XY (100+) series in excel

I have 100+ series to add in a single scatter plot. Adding them one at a time manually will take lot of time. How can I speed up this process?