# Tagged Questions

The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

11 views

### How to add a percentage calculation to raw data in an Excel pivot table

I'm trying to figure out how to calculate percentages of values that are downloaded through a data connection in an Excel pivot table. The percentages are targets of values that are downloaded in the ...

**0**

votes

**0**answers

28 views

### How to increase the excel value 1 after to leave the few cells

I enter the following data on a sheet:
Roll-No:- 801
Maximum Marks
20
20
20
20
20
20
Sig. of Class
...

**0**

votes

**1**answer

18 views

### Conditional formatting in Excel according to today's date

I have an Excel file that links to some documents, certificates and such, which are valid for a year. For example, since Feb 20, 2014 until Feb 20, 2015.
To the right, I have a column in which are ...

**0**

votes

**1**answer

17 views

### What formula can I use to find the MAX in the next 12 rows?

I need a formula to find the maximum value of C10:C21 then C22:C33 then C33:C45 then C46:C57 and so on... as you can see it finds the max of the next 12 rows.
Here is what I want it to do: ...

**-1**

votes

**0**answers

15 views

### Modify Excel data connection without disconnecting the connection file

I have several workbooks which connect to the same SQL server data source. I would like to store the details of the data source in a file in a central location, so that if the database is moved to a ...

**0**

votes

**0**answers

14 views

### Count unique items from Filtered range

I have been trying to solve this one for a while. I have a main Excel list for tickets logged since 2013.
The list contains the columns:
Ticket number Date Username engineer name
I use filters ...

**1**

vote

**1**answer

22 views

### how to find partial text in excel

I have two columns "A" & "B". Column "A" contains Complete Text (1000 line items) & Column "B" contains partial text (250 line items). How I can find & place all Partial text(Column B) ...

**0**

votes

**1**answer

33 views

### Count filled cells in row, given from adjacent column not being empty in Excel 2010,

I have a two worksheets, one in which I have a list of tasks as well as several other columns listing the status of the task and one column listing if the task is imortant or not. In the other sheet, ...

**-2**

votes

**0**answers

10 views

### How to split many excel by equal values [on hold]

How to split the excel into many workbook by equal values. I will don't make any try for this. I want a macro for split excel into many workbooks by equal values

**0**

votes

**1**answer

13 views

### How to search a range of cells for specific txt, then copy to adjacent cell

I have a range of cells, e.g. g1-g1000 that contains two type of entries: xx.xx or xx.xxCR, where xx.xx are numbers.
I want to search the range of cells for xx.xxCR and when a cell is found, copy ...

**0**

votes

**0**answers

18 views

### Delineate Excel Formula Without Using Wizards

Is there a combination of excel formulas that I could use to do this without using VBA or the import wizard? I know how to insert comma delimited data from a text file and to split a cell into ...

**-1**

votes

**0**answers

10 views

### Excel - Formatting one cell from a series of cells

I am trying to format one cell (H) from a series of cells (C, D, E, F).
For example
if column C = "x" then column H = 120
if column D = "x" then column H = 160
if column E = "x" then column H = 200
...

**2**

votes

**0**answers

14 views

### Mapping Excel sheet to XML Schema - using a column for multiple attributes

I have data like this in Excel:
I want to export XML using XML Maps feature like this instance, based on a schema that cannot be modified:
<someRootElement>
<Foo Key1="A" ...

**1**

vote

**1**answer

18 views

### In Excel, populate array based on table with value (and coordinates for desired array cell). All array cells are populated (default to be zero)

I am reasonably good with Excel but a near novice at VBA. I have a three column table. Column A & B have coordinates for an array, with column C having the value to be placed as defined by the ...

**1**

vote

**1**answer

23 views

### How do I use fill color for negative values in spider chart?

Is it possible format the Spider Chart so that the negative area is always filled with red color and the positives with green.
For clarification:
The color filling is done manually and if the ...

**1**

vote

**1**answer

22 views

### Excel: combine strings based on duplicate keys

I have two columns
Key and Value
(standard map)
There are duplicated keys. It is trivial to delete the duplicated keys (namely the delete duplicates button). But that would delete some useful data in ...

**1**

vote

**0**answers

35 views

### How to align column values with their matching value in another column?

I have several columns of data that I need to align with a master column.
The following is an example of what I hope to achieve, but with a table containing more larger strings and more rows. The ...

**-1**

votes

**0**answers

19 views

### Schedule Spreadsheet Questions [on hold]

I have recently been promoted to division supervisor at a security company and one of my biggest duties is making up the weekly schedule. The current setup uses Excel. I am very low-level when it ...

**-1**

votes

**0**answers

20 views

### How can I activate this hyperlink? [on hold]

Copy and paste the folder file path into a web browser (Chrome). Then CTRL + A the browser page into an Excel document. This will hyperlink all the names. Then it's just a matter of sorting. There are ...

**0**

votes

**0**answers

21 views

### Error when running a VBA in Excel

I am trying to merge 150.000 different .xls files into one only one master sheet. I have done this many times before but I am suddenly receiving a error in the middle of the process.
Here is the VBA ...

**0**

votes

**1**answer

15 views

### How to graph values versus time axis? [duplicate]

I'd like to use Excel 2010 to show on the x-axis when discrete events occurred and on the y-axis the magnitude of those individual spurious events. My goal is to try to visually analyse when different ...

**1**

vote

**2**answers

20 views

### How do I Calculate Variance with Missing Values coded as -99?

I am trying to calculate individuals' variances on multiple measures, however, if they skip a question it is coded as -99. I would like my formula to calculate the variance for these measures while ...

**-1**

votes

**1**answer

50 views

### Excel 2010 display two dates in one cell which sum invoices of that period [closed]

MONTHLY INCOME AND EXPENSES
INCOME gen-15 feb-15 mar-15
Pension €1.571,97 € 1.571,97 € 1.571,97
Previous Month €1.143,62 ...

**0**

votes

**1**answer

30 views

### How do i do a “tweaked” VLOOKUP?

So here is the problem: I have 3 lists (adjacent columns) in a spreadsheet.
The 1st list contains the values I am searching for
The 2nd list contains the first half of table array which I am ...

**0**

votes

**1**answer

36 views

### Excel formula that returns row if value is found in a column

I have a list of DNS entries that I need to sort to get the good records.
In sheet1, I have a dump of the raw data, in column 1 is a zone ID which is a number.
In sheet2, I have a column made up ...

**0**

votes

**0**answers

34 views

+50

### How to change Control-Y behavior in Excel-VBA's IDE

Excel VBA's IDE register's a Control-y as "cut this line of code".
By contrast, redo-ing is accomplished by Alt-e, R.
Is there any way to change this behavior and make Control-y be the much more ...

**-1**

votes

**1**answer

20 views

### Compile a Separate excel files to a single file [closed]

I have 10 separate sheets/files of employees with information of leave plan for the year(Jan to Dec).
How can I compile all the detailed information with a single sheet/file in excel.?
An early ...

**0**

votes

**0**answers

14 views

### Adding attachment to cell in excel

How can I insert an attachment (Word or PDF) in a cell in Excel? Meaning that if I refer to the cell I will refer to the attachment itself.
If i insert an objective and i try to link to it i got ...

**0**

votes

**1**answer

22 views

### Unable to do an arithmetic calculation in MS Excel

probably not relevant. my laptop is win8.1, lenovo yoga11s. the excel version is excel 2010
I am doing this chem lab report and I need to do some simple arithmetic calculation. I need to subtract the ...

**0**

votes

**0**answers

14 views

### How do I keep a value the same in a cell

I do a monthly budget type of thing and have some hobby shares around $3000 value. I have managed to link my Yahoo share page to my budget excel sheet. I put a monthly total of bank accounts shares ...

**0**

votes

**0**answers

34 views

### copy and paste according to a order in a column

I want a macro that will fetch data from Series B and Automatically paste it according to the serial of Serial A. ASeries B and Series A data are same but Series B is not ordered. So i'm looking for ...

**0**

votes

**1**answer

20 views

### How to make a custom selection on excel?

Is it possible to make a custom selection on a spreadsheet and in particular on excel ?
If yes, how to do it ?
(for example, I would like to select one cell on 3 among a column
or select only the ...

**2**

votes

**1**answer

45 views

### Why is my formula pulling the result CELL NAME and not the value of that cell?

I am creating a worksheet that compares two sets of data pulled on different dates. The column that everything pulls off of is created by an array formula comprised of combined unique values from the ...

**1**

vote

**2**answers

56 views

### Need an Excel Macro to sum a variable length range

I am trying to create a Macro that is able to recognize how many rows have values above it and only sum that range. If you look at the attached image, I need to be able to click in cells B4, B10, and ...

**0**

votes

**1**answer

24 views

### Microsoft Excel Query - Formatting Columns

I have got an excel sheet data that looks like this:
Order Id Rate Item Quantity
XXX 4 Ball 100
XXX 4 Hockey 500
XXX 4 Hockey 500
AAA ...

**1**

vote

**1**answer

41 views

### Is it possible to hide #VALUE! in a cell?

In A1, I input 1,2,3,4 and so on.
B1 remains blank because this is where I will enter a number (qty).
C1's content is:
=IF(ISNA(VLOOKUP(A1,'Item ID'!$A$4:$E$11166,3,FALSE)),"",(VLOOKUP(A1,'Item ...

**0**

votes

**1**answer

22 views

### If statement in excel 2007

I have a if statement in a cell that looks for the value in two different cells depending on which one is >0. Both target cells have a formula that selects a value based upon the value of the cell as ...

**0**

votes

**1**answer

18 views

### Subtarcting from total in one cell, based on data validation on another cell in Excel 2010

I have 5 columns from A1 to E1, labelled as Name, date, amount owed, status, total owed.
Column D is data validated as Paid in full, Installment, Pending. What I would like to do is when the data ...

**0**

votes

**0**answers

7 views

### auto reference cells in worksheets built per month; worksheet selected based on the current date

I want to have a dynamic master list of clients that are being seened.
The names of the clients change as they come and go. I have a standard list of names with a date when they came in. It is 4 ...

**0**

votes

**0**answers

59 views

### Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version.
They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content.
...

**2**

votes

**0**answers

18 views

### What function (or functions) can I use to pass worksheet title to a reference?

I have a number of cells on a worksheet that reference another worksheet. Pretty straight forward except I have to type the name of each worksheet in each formula which is becoming monotonous. What I ...

**0**

votes

**1**answer

37 views

### Excel 2010 workbook startup error

I have an Excel workbook that causes an error when it is started on a particular PC. No other workbooks give the same error on this PC, and the workbook itself causes no problems on any other PC. The ...

**0**

votes

**0**answers

27 views

### How to separate/filter out number with 3 decimal places into another column?

Please help,
currently i'm working on a massive number of data (up to 50 000++). i need to separate or filter out
the numbers which have only 3 decimal places into a new column (as bolted in the ...

**-1**

votes

**1**answer

30 views

### Excel Macro Radiobuttons dependent on cell value

I have a cell A1 which is filled with a dollar value eg. 20000 based on a vlookup. Depending on the value which is found I want 1 of 4 radiobuttons to be selected.
0-40K 40-150K 150-300K >300K
...

**0**

votes

**2**answers

51 views

### Referencing cell only by column name in Excel 2010 VBA

In Excel 2010, I need to go through a data table row by row and manipulate the data in VBA.
My original function reads like this:
Private Function GetValue(ByVal myRange As Excel.Range, ByVal strCol ...

**-1**

votes

**1**answer

49 views

### counting if certain things match

I have a set of data that looks like this:
Period Address Name City Carrier Move ID
P1/2014 WAL-MART CANADA INC. MISSISSAUGA CMV0066539
P1/2014 ...

**0**

votes

**1**answer

15 views

### Excel: Using the TEXT function for spreadsheets used by users with different regional settings

I am using the TEXT function like =TEXT(B1, "ddd") where B1 is formated as date to display the weekday. This works fine on an english regional system.
On a machine with a german regional setting the ...

**0**

votes

**1**answer

38 views

### How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...

**0**

votes

**1**answer

18 views

### excel 2007 updating new adjacent cell value when reference cell i s updated

I have to copy or update cell value to new adjacent cell every time when reference cell value is updated.
I have Cell A1 with some formula, which updates it value frequently. what i need to do is, ...

**1**

vote

**0**answers

30 views

### Excel 2010: Combine Two Tables in Pivot Table

I have two named tables on separate Excel worksheets in the same Excel 2010 workbook. These tables contain the exact same header items. I could get the results I want by copying the data from one of ...