# Tagged Questions

The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

42 views

### How can I search for a value that's repeated in excel?

I have a spreedsheet (Sheet2) that has 4 columns:
ID | Name | Semester | SemesterAvg | Overall Avg | Period |
1 | John | 1 | 2.5 | 2.5 | 20132 |
1 | John | 2 | ...

**0**

votes

**0**answers

8 views

### 3D Graphics with 3 Colums as Data

I have an excel tab as attached :
I want to make a graphic with 3 axis. On the first one, the Type, on the second, the projet, and on the third, the date.
However, I've tryed several things, and I ...

**0**

votes

**1**answer

122 views

### Creating folders and subfolders from Excel cell values

I'm trying to create a directory named as the value in column E within a directory (c:/Site Information), then create a further directory called the concatenated value of column A, B, C, and D. This ...

**0**

votes

**1**answer

33 views

### Excel Month() function does not detect some date format

I have a simple table like this in excel:
The formula i used was =IFERROR(IF(LEN(B3)>0,MONTH(B3),""),""). I check if a cell is blank by using LEN, if so ignore, else, convert it to month no.
I ...

**2**

votes

**0**answers

9 views

### Excel Conditional Formatting when adding extra columns

I've created a worksheet and added conditional formatting to it. Unfortunately whenever I need to add extra columns to this sheet, my conditional formatting messes up. Not only the range when this ...

**1**

vote

**1**answer

96 views

### How do i right align an icon set arrow under conditional formatting so that both number and arrow are on right side of cell neatly together?

Cell displays a conditional format arrow Icon set which is on far left side of cell. The number in that cell is right aligned and I want to bring the arrow directly next to the number. I want the ...

**0**

votes

**1**answer

27 views

### How to create a dynamic date title in excel 2010 using different tables and data

My friend has asked for help with an excel assignment and they have 2 tables, HRM and Data_Tables.
Data_Tables has corresponding month numbers from 1-12 in column I from I3-I14. In J column there is ...

**0**

votes

**1**answer

35 views

### Running macro on multiple sheets

I can run macro on individual worksheets but not all open worksheets.
I want to run this macro on 700 worksheets. We are trying to delete one column.
Sub RunMacroOnAllSheetsToRight()
For i = ...

**0**

votes

**1**answer

32 views

### Count unique values within specified variable date range

I'm attempting to create a report that includes a count of unique values from a table. I'm using Excel 2010. Normally this would be an easy matter of adding a column to the source data with a formula ...

**0**

votes

**2**answers

66 views

### Needs VBA solution - Clear contents of 4 cells to left of cell with N/A Error

I have a table of data in which column L has a vlookup formula. In the rows where column L (i.e., the vlookup returns "#N/A"), I would like to clear the contents of the eight cells to the left ...

**3**

votes

**1**answer

62 views

### Excel to count number of concurrent sessions based on start/end times

I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time.
I am trying ...

**0**

votes

**2**answers

57 views

### Check if a cell contains any of words from a dynamic list

I want to use a formula to populate the "RESULTS" cells. I need it to check if the adjacent "CHECKED CELL" contains any of the words listed in the "KEYWORDS" cells.
Ideally, I would be able to add ...

**0**

votes

**0**answers

20 views

### How to save .xls file to tab-delimited(.txt) and specify Shift-JIS encoding

What I want to do is save .xls file to tab delimited .txt file with specifying SHIFT-JIS encoding. I tried specifying encoding in web options however when I save to tab delimited still japanese ...

**0**

votes

**0**answers

11 views

### Using IF to compare name of a worksheet with worksheets in workbook

I have two files Main file and Result.
Main file have multiple worksheet like delhi, moscow, paris, scotland and each one has same type of date and same heading ie.:
S_No. , Vendor, VendorId, ...

**0**

votes

**3**answers

37 views

### How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?

This is probably an easy fix. I have one cell (Cell B8) with say the number 2000 in it. I have another column of 6 numbers (Cell A1 to A6) (Say 4000, 3050, 2100,2100, 1150, 200) that will change with ...

**0**

votes

**2**answers

92 views

### How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)?
Let's say the choices ...

**0**

votes

**1**answer

24 views

### Excel playoff bracket

I've created a playoff bracket and want to setup a way to automatically move the team name to the next round (another cell) once 4 wins are achieved. I'm using Excel 2010.
Example:
Compare the value ...

**0**

votes

**1**answer

21 views

### Dropdown + Autofill

I have a address list(name, street,city,telnumber)
On another sheet I have a form, where I can choose the name from an dropdown list. Now I want to get street,city, telnumber for this name. Is this ...

**0**

votes

**1**answer

15 views

### Excel odd @ formula in table

I have an Excel workbook from ancient times. A table with header and rows of data are recorded in it. I insert a new column next to an existing one and start typing in an if formula in the first row.
...

**2**

votes

**1**answer

56 views

### Excel - keyboard shortcut to double click on format painter

Double clicking on Format Painter has the effect of allowing you to click a few times and apply the same format in all those places.
Alt-H-FP has the same effect as a single click on format painter.
...

**4**

votes

**3**answers

55 views

### Keep Specific Columns From Repeating in Excel

There is a report that I pull from our ERP system that lists order detail information. It will list the order number, customer code, customer name, order date, order status, order total, product code, ...

**0**

votes

**1**answer

16 views

### Can you change the type of an object in EXCEL

I created a rectangle object with text inside an EXCEL document and formatted it a lot, if I want to suddenly change it to circular (oblique) type, is there a way to do this in EXCEL?
Right now, I ...

**0**

votes

**0**answers

43 views

### Excel, macro move one row down and then delete the row

I'm trying to clean up duplicate rows. My data is in a table with filters applied. I have tried using the Excel feature to remove duplicates, but get the following error.
Cannot complete ...

**0**

votes

**1**answer

43 views

### Multiple Formulas in one Cell for hotel

I am trying to create a housekeeping spreadsheet where when a room number is entered into a cell a 0 or 1 (0 is for studio and 1 is for a 1 bedroom) is automatically populated in another cell. I have ...

**2**

votes

**0**answers

18 views

### How to return results of SQL query to Excel sheet with VBA function [duplicate]

I'm trying to create a VBA function in Excel to affect dynamic value from Access to Excel sheet. This is my code.
Public Function SQL(DB As String, Query As String)
Dim conn As ADODB.Connection
...

**0**

votes

**0**answers

15 views

### Strange behaviour of pivot table - entry masked

I've a very strange issue in Excel 2010 pivot table. One entry of my data gets replaced to " " (space) in pivot table. "GR45ZF1402010" is not visible as you see below, if I change just one character ...

**0**

votes

**0**answers

9 views

### When moving data in Excel, how do I get data validation from destination

I have a workbook with three sheets, Active, Finished, and Tables. Tables contains auxiliary Tables for data validation.
At some point a row in Active will be moved to the Finished sheet. Both those ...

**0**

votes

**1**answer

38 views

### MS Excel - Cumulative sum of a column based on “id values” in another column?

I have been trying to figure out how to make a formula that calculates cumulative sums of rows in a column based on their id values in another column but still haven't found any solution for it. I try ...

**0**

votes

**0**answers

20 views

### How to determine or highlight cells their values will Sum a particular given number?

If the sheet contains a column of values, and I would like to determine or highlight the cells that their values will sum a particular given number (value):
For Example:
If the column contains these ...

**1**

vote

**1**answer

61 views

### How can I replace forbidden characters in a file names before saving in VBA?

This will be very simple for somebody who knows VBA better than me. I used a code original provided by user Nixda on this forum to split excel worksheet into multiple CSV files based on column value ...

**0**

votes

**1**answer

75 views

### Hotkey to open filter drop down menu in merged cell in Excel 2010

I use Excel 2010 and use Alt+Down arrow to open filter drop down menus.
Sometimes my header contains vertically merged cells (e.g. autofilters are in the second row and in some columns cells in rows ...

**0**

votes

**1**answer

42 views

### SUMIFS w/ multiple Criteria

Base on the Emp ID and the Pay End date I'm looking to sum up the Total Earnings and if it is equal to or higher than the WC Cap in the exposure column I'd like to return the WC Cap value. If it's ...

**0**

votes

**2**answers

65 views

### How to give worksheet tab a color if range of cells contains text

I have tried code that I've found on SE, and elsewhere but they aren't working as I think they can. I'll list them below. I'm almost certain this is an easy question.
What I'm trying to do: If in any ...

**1**

vote

**2**answers

40 views

### How to list all possible solutions for missing digit?

In Excel, I want to add 2 numbers with missing digits and would like a list of all possible solutions.
For example: Given 5.x1 + 2.y1 = 7.32, what are the possible combinations of x and y?
In this ...

**1**

vote

**0**answers

19 views

### Deleted record keeps reappearing in data file using MS Word 10 merge/Excel 10 spreadsheet

I am unable to remove one particular record from my data file. I remove it from the excel spreadsheet, but when I try to merge it is back--even after I have changed the file name after removing the ...

**0**

votes

**0**answers

11 views

### Task descriptions from Excel to Outlook 2010

After creating in Excel the appropriate column headers for the export to Outlook, the name "description" exports the data into an Outlook calendar item, but does not do so into an Outlook task item. ...

**0**

votes

**1**answer

37 views

### Plotting 3000 data vs date in excel [closed]

I have 3000 data which are registration numbers and every reg.number corresponds to a date. Some dates have several registration numbers. It looks like this:
Date - - - - - - Registration number
...

**1**

vote

**1**answer

18 views

### Leave a pmt cell blank until data is entered

I am making a spreadsheet with the pmt function. I want the cell with the pmt to remain blank until interest rate, time, and pv is entered.
I have the pmt formula: =PMT(C2/12,C3,C4) And I do not want ...

**0**

votes

**0**answers

37 views

### Mysterious “Reference not valid”

Error dialog: Reference not valid
I have a big sheet with 30+ pivot tables made from the same 3 named tables.
Every time i run refresh all I get the Reference Not Valid-error.
I have no idea which ...

**-2**

votes

**1**answer

42 views

### Is there a way in Excel 2010 to have a formula in one cell and show in a different cell? [duplicate]

I want the formula to be in one cell, and the result in another cell. I do not want the answer to populate the cell that contains the formula.

**1**

vote

**2**answers

86 views

### How to convert a number for a salary amount, to a specific, 9 digit, format in Excel

If I enter a salary dollar amount as 34512.15, I'd like to have a formula return this amount in a specific format as follows:
M(HT)(TT)(TH)HTOCC
M=Millions
(HT)=Hundred Thousands
(TT)=Ten Thousands
...

**0**

votes

**1**answer

35 views

### Count items in comma separated list in single cell

Is there a formula that will count the number of items in a cell, each separated by a comma?
For example:
CELL A1 = "Dell, Apple, Samsung, Acer"
Formula would return 4.

**-1**

votes

**1**answer

29 views

### Why doesn´t Excel function change cells for calcuation

I have the following function:
=SUMIF('Pivot'!$A$5:$A$51;'Projects Overview'!E4;'Pivot'!$B$5:$B$51)
I need it to automatically change $B$5:$B$51 to $C$5:$C$51, $D$5:$D$51, etc. when dragging the ...

**0**

votes

**1**answer

17 views

### count the number of sequential duplicates in excel but start back at 1 if there are more than 3 sequential duplicates

I have a spreadsheet displaying hardware equipment in sector level. For instance:
023008_SHELBY
023008_SHELBY
023008_SHELBY
023009_SWAN_29TH_ST
023009_SWAN_29TH_ST
023009_SWAN_29TH_ST
...

**0**

votes

**1**answer

90 views

### How to use Index and Match formulas for multiple criteria

I have a spreadsheet that contains Olympic information, with the following fields in columns:
A) Athlete, B) Age, C) Country, D) Year, E) Closing Ceremony Date, F) Sport G) Gold Medals.
I want ...

**0**

votes

**1**answer

44 views

### How can I make a Scattered chart in excel where the dots are different colors?

I have the following info:
Question | Importance | Percentage
1 | 2 | 15%
2 | 1 | 98%
3 | 1 | 35%
4 | 3 | 22%
5 ...

**2**

votes

**1**answer

26 views

### Horizontal array constant definition issue

I can't understand where I fail (except following MS-original help :-D) in attempt to enter horizontal array constant (C+S+E seq) per MS guidance accessible either from Excel 2007 or 2010 help, or at ...

**1**

vote

**1**answer

39 views

### In Excel, How can I add values in a specific column if I have a checkbox type spreadsheet?

The Excel sheet is linear with column B being the distance walked each day. Across are a column for each participant. As they join the walking group each day, I'd like to keep a count on total ...

**0**

votes

**1**answer

19 views

### minimized workbook has no restore button

When I minimize work books they do not have a restore (or maximize) button, just the close button. Makes it hard to restore them! Any ideas? is there a registry setting that is messed up that makes ...

**0**

votes

**1**answer

46 views

### Find column number in excel based on header names using formula

I have a table in excel with the following 2 header row layout:
A B C D E F G H I
1 qtr01, qtr02, qtr03, qtr04, qtr01, qtr02, qtr03, qtr04, qtr01
2 2013, ...