The 2010 version of Microsoft's spreadsheet application.

**-1**

votes

**1**answer

19 views

### Excel Date Formatting Issue

A common question but I've tried the usual methods of transforming the dates in this data set such as DateValue and Text.
Also not sure if there could be problem with the dates going back further ...

**0**

votes

**1**answer

16 views

### How to create unique values per group?

I have a column with postcodes where several rows can have the same postcode. I would like to create a unique value which takes the postcode value and adds an underscore followed by a number where ...

**-1**

votes

**0**answers

16 views

### Unlocking Excel 2010 file locked by 'another user'

I have a file that I need to edit. When opening, I get the message "... locked for editing by 'another user'". I am quite sure that this is a system glitch and not someone indeed using the file. I ...

**0**

votes

**1**answer

27 views

### Excel: Changing and updating a future value based on past occurrence and lookup in a table

I have a big dataset, dataset is in such a way that each time a customer is called a row will be created. So the customer Number is the unique ID here. Based on their current and past response type, ...

**0**

votes

**1**answer

16 views

### VBA code to superscript a number after decimal point

What will be the VBA code to detect a decimal point of a number in a cell and then superscript the numbers after the decimal?
For instance in the number 3.45 I wish to superscript 45 and then remove ...

**0**

votes

**0**answers

11 views

### Excel 2010/Hancom Automate the inserting process across multiple sheets

I'm in the process of creating a complicated excel spreadsheet which is where my knowledge runs thin. It's currently consisting of 17 sheets. I currently have 10 pages which require a daily entry of ...

**0**

votes

**1**answer

12 views

### Copy rows on condition to another Worksheet

I have an Excel file with 1 Worksheet. In that Worksheet there is data in 1 column and 250,000 rows.
I want to select rows which contain a specific string say "workspace" in that 1 column. So for ...

**2**

votes

**1**answer

26 views

### Error using Count If

I have an error using countif to check if values are present in an array.
I have a list of values called "All Points". There is a subset of these called "Plotted Points", that have coordinates. I am ...

**0**

votes

**1**answer

29 views

### How to navigate to cell by typing destination?

Suppose I'm at the cell A1 and I wish to move to the cell P234 simply by typing on the keyboard.
I know I can click on the box which displays the cell name and type the destination P234 there, but ...

**0**

votes

**1**answer

38 views

### Setting and starting autofilter in Excel

I have a spreadsheet and it links to another workbook. The issue is when the filter is on it does not change as new data is added; you have to refilter the data.
(Click image to enlarge)
I know ...

**2**

votes

**0**answers

12 views

### Odd Excel/VBA behavior - Creating sheets that do not exist

Excel 2010 Professional Plus (32bit) seems to have created a new set of worksheets and renamed all the original worksheets in the VBA screen, e.g. Sheet10 becomes Sheet101, Sheet13 becomes Sheet131. ...

**0**

votes

**1**answer

29 views

### Excel If Function With More Condition with Match Function

i had a problem with if function with more condition and match function. May i had Solution?
Currently I try using this array formula but cannot get any result.
...

**0**

votes

**1**answer

22 views

### Excel: how to add random decimals to numbers with a macro

I have a list of gps coordinates for a map that we need to randomize a bit as we cannot provide the exact addresses. I would like to shorten the original coordinates (that is the easy part as I just ...

**1**

vote

**2**answers

20 views

### Automatic column width in Excel

In Word 2010, there is an "AutoFit" feature for table columns, that makes the column automatically be an appropriate width for its contents. How do I get the same in Excel?
I can double click on the ...

**0**

votes

**1**answer

30 views

### Count the numbers of matches between a row and a column in Excel

I have a data set in which I need to count the number of matches between any ID numbers in a column and equal ID numbers in a row. I have attached a data set example image and hopefully that will ...

**0**

votes

**1**answer

15 views

### Error running macro after trying to run it from pesonal workbook

So I wrote a macro. The scenario of use is:
I open a fresh and new CSV file downloaded from somewhere
My macro runs and does some magic with the data
Since I don't want to copy-paste my macro to ...

**1**

vote

**1**answer

31 views

### Concatenating multiple characters with different formats in excel

I need to create a large series of multiple machine numbers with the following character formatting: Machine Number(first 4 digits)_Date(last 6 digits) as provided in the sample image below:
One ...

**0**

votes

**2**answers

45 views

### Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added

I have a big data set. What I want to happen is for each customer number occurrence, when the transaction type column has an entry CC or SO, it needs to be calculated as a donation. So for each ...

**0**

votes

**1**answer

25 views

### Convert a column B into a comma separated list , “ORDER BY” Colum A

trying start with VB in excel
just need understand how it works , this task can be done in SQL,
but I really want to know how can be easy done in excel
column A contains par numbers , column b models ...

**1**

vote

**2**answers

29 views

### Calculate the minimum starting from today (excel)

I am trying to get excel 2013 to display the minimum for a structured table but only from rows that are dated today or after.
The table is a standard structured table, and most of the formulas I have ...

**0**

votes

**0**answers

12 views

### Auto Update data from one column in Excel file A to another column in Excel file B

I have 2 excel files for example myemployee.xls and salary.xls.
In myemployee.xls, I have two columns: employees code and names like this and new employees will be entered here continously.
A ...

**0**

votes

**1**answer

25 views

### How to compare the Values in two different columns if the Values are same get the values

Column B has Values of customer Number (multiple times) till Row 1000 and column A has the sales orders information like below.
Column A Column B
ORDER1 KRISHNA
ORDER2 RAVI
...

**0**

votes

**0**answers

22 views

### How to make 2 Excel sheets read each other and combined into 1 excel sheet

I have 2 Excel Sheets with gas card numbers and date stamps on 1 and another with date stamps and driver names. I need to know if there is a way to have the first sheet read the second and combined ...

**0**

votes

**1**answer

35 views

### How To Return the Three Letter Month Abbreviation of a Date in Excel 2010?

I've searched here and other site without being able to find a solution. I've been able to do this in the past but can't figure it out now. I have an Effective date in, lets just say cell B1. I want ...

**0**

votes

**1**answer

21 views

### Combining SUMIF and SUBTOTAL

I have looked at each of the other posts regarding combining these two functions, but I don't understand them enough to apply them to my specific task. I have to manually create an AR aging for a ...

**0**

votes

**0**answers

25 views

### How do I create a Range named by another cell

is it possible to name a data range based on the value of another cell?
for example, lets say A1 has "blue" in it, then range B1:B5 is named Blue (because that is in cell A1. but then i change the ...

**-3**

votes

**0**answers

23 views

### Excel worksheet coding needed

I need help changing this code
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim int_range As Range
Set int_range = Intersect(Target, Range("B:B"))
If Not (int_range Is Nothing) Then
...

**0**

votes

**0**answers

25 views

### Select specific cells in Excel

I have an Excel 2010 spreadsheet with thousands of rows and columns. I want to select specific cells from it. Is there any way to select:
every 7th cell in a column
every 7th cell but restart the ...

**0**

votes

**1**answer

24 views

### Excel Formula COUNTIF Issue

This is what I have for my D2 cell:
=COUNTIF(B1:B50="yes",=SUM(A2)-1),IF(OR(C1:C50,"yes",=SUM(A2)+1))
Basically what I'm trying to accomplish is this.
I have =SUM(A2) in my E2 cell for it's ...

**0**

votes

**2**answers

33 views

### Converting a flat list into table in excel

How would I go about automating the conversion of a very long list in a format like this:
Into a table like this:
I am using Microsoft Excel 2010 on Windows... because of the layout of my data ...

**0**

votes

**0**answers

11 views

### How to reconcile various fields in excel from different worksheets

I ran into a problem in trying to reconcile some data.
(Worksheet A)
Date
Reference No.(1)
Reference No. (2)
Amount Name
(Worksheet B)
Date Reference No.(1) Reference No. (2) Reference .No (3) ...

**0**

votes

**1**answer

11 views

### conditional formatting to highlight the cell

I'm using Excel 2010 and would like to know if there's any way I can choose conditional formatting to highlight the cell from a table/list after a value has been entered.
For instance, when entering ...

**0**

votes

**0**answers

10 views

### How to combine multiple databases in excel into one strong and efficient database

I'm working in a highly reputed government company as a data entry clerk and my responsibility is to keep the contact information database updated by adding new contacts and making sure that all the ...

**0**

votes

**0**answers

14 views

### Formula in Excel which allows me to identify equal values in rows

I want to build a formula in Excel 2010 which allows me to identify EQUAL, GREATER or LESS values in rows.
if column A is greater than column B or C (put the word GREATER in column D)
if column A ...

**0**

votes

**0**answers

13 views

### Possible to have template folder that has referenced worksheets inside?

It's hard to explain what I'm trying to do, but I would like to create a folder template that would have a bunch of smaller Excel spreadsheets that are referenced to a larger, master copy that has a ...

**0**

votes

**1**answer

21 views

### I would like excel to highlight a cell based on vlookup if then statement

I deal with contract changes every month. Each month I have to account for the money changes that happen with those contracts. I keep a running spreadsheet of each time I make a change that will ...

**0**

votes

**2**answers

24 views

### Excel: Separate empty cells from having 0 value

I wanted to know if there is an option that doesn't allow empty number cells to obtain the 0 value when there is a function that takes values from these cells. For example, if I want to add the ...

**0**

votes

**0**answers

18 views

### Conditional formatting of pivot table cells based on value of a separate field

I have a pivot table which has, for the purpose of this question, "document-ID" as a row label, "person" as a column label and "date signed" as value field. Is it possible to give each cell containing ...

**0**

votes

**0**answers

34 views

### How do I load external images into Excel cell comments?

How can I make a VBA macro to open an external image (i.e., local file, URL, etc.) in cell comments?
I am not a VBA expert, but have tried the solution proposed in other topic (How do I load external ...

**0**

votes

**1**answer

12 views

### How to sum a series of values each time an index # changes

In the event I want to sum all the rows (column B), belonging to each index # (column A), how would I do this? The amount of rows for each index # varies.
What formula (s) would I use in column C?
...

**0**

votes

**0**answers

19 views

### EXCEL Data queries will not “refresh all”

I am using Windows 7 running Office 2010, and Excel will not "refresh all".
Every "external data query from the web" in my worksheet will work when I use it as a single "data refresh" but hangs when ...

**0**

votes

**1**answer

21 views

### Counting words in a noncontinuous range in excel 2010

I need to count how many times a person's name appears in a noncontinuous range in excel. I used a formula on a different sheet that worked as it only looks at a column, but I need to look at ...

**0**

votes

**1**answer

22 views

### Changing Excel Cell colours once a word/value in another cell is entered/changed

I currently have a spreadsheet with a list of deadline dates in row C and status updates in row E.
I need the cells in row C change to green once the words Complete/ Completed is written in any of ...

**0**

votes

**1**answer

29 views

### How do I implement the VBA module to copy filtered data

I need to implement a VBA Macro that copies data from one excel worksheet and puts certain column into another one.
Sub sbCopyRangeToAnotherSheet()
'Method 1
Sheets("Sheet1").Range("A1:B10").Copy ...

**0**

votes

**1**answer

18 views

### Expand colour of formatted cell to rest of the row in a table

I have applied conditional formatting to several cells in column A, whereby if I type 'I' this cell will turn grey. What I want to also happen is that colour to expand into column B-I without changing ...

**0**

votes

**0**answers

18 views

### how to get cells containing keywords separated by a comma to become filter keywords on activating the filter

I have a table of recipes:
Dish | Ingredients | Tools |
Soup |tomatoes, basil|bowl, fork |
Pizza|eggs, cheese |pan, knife, plate|
Pie |meat, eggs, ham|skillet, knife |
If I ...

**0**

votes

**1**answer

26 views

### Custom fill sequence excel

I want to do a custom fill sequence in Excel that i can drag. For the life of me i can't find the answer to this.
Two desired outcomes:
A1=B1,
A2=B7,
A3=B14,
A4=B21,
But what i really like is:
...

**0**

votes

**0**answers

9 views

### Count values in another table matching a cell value in row of current table

In excel 2010 I have a table of projects, and a table of initiatives (one project to many initiatives). I would like to create a "total initiatives" column in the project table that counts initiatives ...

**6**

votes

**2**answers

345 views

### How to generate random string from a set of available strings in Excel?

I want to generate a column which will have random string values in any order. Those string values have to be from ('New', 'Mint', 'Very Good', 'Good', 'Acceptable', 'Poor') strings? Can anyone let me ...

**1**

vote

**0**answers

39 views

### Excel 2010 Password Protected Book Accepts More Than One Password

I use Excel 2010 64 bit (14.0.6023.1000)
A workbook that is being protected by password "flu" and be unprotected by password "flu" OR " ab". Why is that? First of all, I thought beginning with Excel ...