The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

2 views

### Counting values in a column if a certain value exists in another column

I'm stumped. I'm trying to create a Summary tab in my spreadsheet that will summarize info from another tab. Primarily, the parent tab is a list of tasks, status of the tasks (open or complete), and ...

**0**

votes

**1**answer

6 views

### WMIC |more has extra rows when .csv opened in Excel

I am trying to output the name and version of each program installed on my system to a .csv file. I could do something more complicated with VBScript, but would prefer to keep this very simple to ...

**0**

votes

**1**answer

13 views

### How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013
"Column A" "Column B"
"tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp"
"tjc0058088269r" ...

**-1**

votes

**1**answer

27 views

### How to insert a button in MS Excel?

Friends I am using MS Excel 2010 and I wish to insert a button in Excel sheet whose name should be ‘1 ADDER’ and I want that whenever I press this button, it should insert 1 in the cell of column A ...

**1**

vote

**0**answers

11 views

### Automatically Printscreen from result of formula

I have a procedure in VBA to call a PrintScreen:
Sub PrintScreen()
keybd_event VK_SNAPSHOT, 1, 0, 0
End Sub
I want to call it every ten seconds, when the result of this cell
...

**1**

vote

**4**answers

40 views

### How do I drag down a pattern over 100,000 rows?

In MS excel, suppose I have a worksheet with over 100,000 rows. How do I use the dragging feature over all the rows from the top for a fixed column efficiently instead of dragging down and waiting a ...

**0**

votes

**2**answers

26 views

### Excel 2010 formula to delete repeated content based on value (instead of second highest the lowest)

I've read a Question topic about picking the second highest value. I need the same but a bit different:
Excel 2010 formula to delete repeated content based on value
Maybe it is a bit rude, but I ...

**0**

votes

**2**answers

17 views

### EXCEL: how to enter text verbatim

I am using MS Excel. How do I enter text into a box so that it shows up verbatim the way I entered.
E.g.
If I enter 4-2, I want it show up as 4-2 and not as 2-Apr automatically.

**0**

votes

**1**answer

28 views

### Why is Excel and Office always asking me to recover documents?

Since Office 2002 (probably even 97) until Office 2010 (probably even 2013), opening Excel and Word constantly results in me being shown a list of documents that I might want to recover. As far as I ...

**-1**

votes

**1**answer

18 views

### Extracting values from an excel table to build a graph

I have the risk register shown as an excel table. I want to extract the entry corresponding to a specific KRA value and plot its maximum on a graph. I need the method to be automatic so that any ...

**0**

votes

**2**answers

26 views

### Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign.
If I have 3 columns DATE | ...

**1**

vote

**2**answers

25 views

### Find information about range of Excel data. Is it constantly growing or cyclical?

I am (short-term) monitoring the sizes of several UNIX files and can easily export the numbers to an Excel spreadsheet. The files will eventually be indexed by Splunk and that team wants to know the ...

**0**

votes

**1**answer

21 views

### How to shift the data from one cell to another cell in excel?

Friends I am using MS Excel 2010 and I want As I type any value or word in a1 cell, it should automatically be transferred into d1 cell and a1 cell should get blank again. Similarly if i type any ...

**1**

vote

**1**answer

42 views

### Looking for an excel formula to match credit card purchases to batch payments reflected on bank statement for account reconciliation [on hold]

How can I match credit card batch payments from bank statement to credit card purchases in a spreadsheet?
CC Purchases Batch Payments
1 0.05 A 1,913.91
2 ...

**1**

vote

**1**answer

43 views

### Excel 2010 - Lookup from a table

I have a table that has a list of trainings for our field techs down column A.
In row 1 there are the names of the field techs.
Each corresponding cell in the table has either a Y or N depending on ...

**0**

votes

**1**answer

27 views

### How to automatic transfer the values in another cell?

Friends I am using MS Excel 2010 and I want As I type any value or word in a1 cell, it should automatically be transferred into d1 cell and a1 cell should get blank again. Please suggest me any way, ...

**0**

votes

**1**answer

29 views

### How to highlight a cell when I double click on another cell?

Friends I am using MS Excel 2010 and I want when I double click on a cell say a1 it should highlight c1 cell. Similarly when I double click on a2 cell it should highlight c2 cell. It is possible by ...

**1**

vote

**0**answers

21 views

### Excel Charting - How to edit the X axes for positive value on both sides?

I have a stacked chart, with the X axes at bottom. So there are two bars protruding along the y axes from each category. to get an idea of the X axes, it's something like this
How to plot positive ...

**0**

votes

**2**answers

27 views

### 1 A, 2 A, 3 A automatically becoming 1:00 AM, 2:00 AM, 3:00 AM in Excel 2010 [duplicate]

I use MS Office 2010. While using Excel, whenever I type 1 A, 2 A, 3 A up to 12 A and move to next cell by hitting Tab or Enter key it automatically becomes 1:00 AM, 2:00 AM.....12:00 AM. This problem ...

**0**

votes

**1**answer

24 views

### Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B.
I need to compare another list of document numbers (alphanumeric), ...

**0**

votes

**0**answers

24 views

### Optimize VBA code(efficient code) and ensure distributability

To perform the following actions:
Copy a particular "template"-worksheets as many times as the number of cells selected in the master database
Create worksheets (with names) based on the selected ...

**-2**

votes

**1**answer

18 views

### EXCEL, I need to take data from 1 column & arrange in another column so the data loops [closed]

EXCEL, I have 4 columns. one column having part numbers, a blank column, column with group number & 123 count column.
I need to take item 1 of the 1st group copy it to blank column but in the ...

**1**

vote

**0**answers

22 views

### One dynamic named range not staying dynamic while another in the workbook is

I am attempting to use dynamic named ranges to make it so I can pre-set the column portion of the print ranges in a workbook without assuming a number of rows. So I opened the name manager and ...

**0**

votes

**0**answers

13 views

### Outlines of merged cells not staying consistent when a filter is applied

I have a spreadsheet that uses merged cells for visual clarity. The merged cells are in the B column (dates), and in the A column there are various values. I use filters in column A, and in my other ...

**0**

votes

**0**answers

10 views

### Macro Hyperlink Error in Mac OS (Office for Mac 2011)

I am getting an error on a macro only when using a Mac. This macro was designed to solve a problem with a formula using the Hyperlink function to copy a link from another sheet for each row. (Excel ...

**0**

votes

**0**answers

22 views

### SUMPRODUCT & ROUND

Is there a way to get the product of the array with conditions to round to the 2nd decimal place before summing?
Current formula w/o rounding:
...

**0**

votes

**1**answer

22 views

### How can I get a count of values for one column as compared to a second column?

I have a spreadsheet with a list of companies that submit data, the type of data they submit, and the date they submit. I need to a do a count of the number of times per day they submit, but only do ...

**0**

votes

**1**answer

40 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

6 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

54 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

22 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

6 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

33 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

16 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

26 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

16 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

33 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

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

**-1**

votes

**0**answers

16 views

### How can a cell be displayed if another cell is marked?

I am a trainer for an organization, and we have a major conversion to a new core system coming up. We have been provided a massive spreadsheet listing all the training modules that each person must ...

**0**

votes

**2**answers

41 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

11 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

34 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

65 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

19 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

14 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

13 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

34 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

41 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, ...

**-2**

votes

**0**answers

31 views

### tallying with different criteria

An example:
Apple Worm Black
Apple Worm Black Sour
Apple Black
Orange Sweet
Orange Sweet
(5 rows and 4 separate columns)
How do I create a formula to tally all the Red apples with a worm or ...