The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
14 views

Aggregate a range of worksheets with errors

I have several worksheet in Microsoft Excel and I am currently adding them like this: =SUM(MySheet1:MySheetN!A2) This funtion adds the content of all A2 cells on all the worksheets contained ...
0
votes
1answer
16 views

Referencing a worksheet in a formula in Excel 2010

I am using Excel 2010. Let's say I have a workbook that contains 13 worksheets. The first worksheet is named "Summary" and the remaining 12 are the months of the year (January-December). In ...
0
votes
1answer
15 views

Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled

I'm trying to adopt the solution from this post & I've modified the macro slightly (I only need to add on button click) so that it's now Sub AdjustValue() Dim btnName As String Dim ...
2
votes
1answer
29 views

Stacked column chart in Excel

I have data in a sheet like the image below. The relevant portions are subtasks, shown in column B, subtask times, shown in column I, and daily totals, shown highlighted in green in the row at the ...
0
votes
0answers
10 views

Having reading software read cells in excel

I am creating a Excel list template. The people using it are using text reading software - such as ZoomText or NVDI - to read the spreadsheet. How can I have the software read something different then ...
1
vote
0answers
26 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
1answer
16 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
1answer
22 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
2answers
44 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
0answers
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
0answers
19 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
1answer
41 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
0answers
16 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
0answers
22 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
0answers
10 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
2answers
39 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
1answer
23 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
1answer
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
0answers
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
0answers
29 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
23 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
27 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
1answer
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
2answers
36 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
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
2answers
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
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
22 views

Locked cells are editable. Why? [on hold]

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
66 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
41 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
14 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
0answers
26 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
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
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
328 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
18 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
14 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
10 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
32 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 [closed]

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