The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

35 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

51 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

22 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

12 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

20 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

16 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

25 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

43 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

42 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

50 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

48 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

27 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

36 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

77 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

26 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

31 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

16 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

427 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

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

**0**

votes

**0**answers

19 views

### Excel macro to copy a pdf or a .doc from Windows Explorer

How would I code an Excel macro to copy a pdf or a .doc from a folder Windows Explorer in to another folder in Windows Explorer?

**0**

votes

**2**answers

29 views

### The IF function in Excel is not working?

For example:
D1=3, D2=5, D3=3.5
I type the formula D1<=D3<=D2 which is obviously true but excel keeps telling me its false and then proceeds to mess up all my other formulas.
But if I ...

**1**

vote

**0**answers

45 views

### How to show collapse/expand button beside a sub-group in Excel that is the last child of it's parent?

I am experiencing this strange behaviour in Excel and am looking for either an explanation or a solution.
I am using Excel's grouping feature to create some parent-child nodes within my spreadsheet. ...

**0**

votes

**1**answer

33 views

### Sort excel table (multiple columns) by numeric column

I have this table from program profiling:
I need to sort it by Total column. But instead, the Excel sorts the numbers alphabetically. I can't even believe it's that stupid. Just check it out!
Of ...

**2**

votes

**2**answers

80 views

### How to flag rows with the pattern non-blank, blank, non-blank using Excel

I would like your help with something I have been trying to figure out for the past two days.
I have data with 1000's of rows and several columns. I want to insert a column with a (array) formula ...

**0**

votes

**0**answers

41 views

### Excel drop-down list formulas

I'm trying to create a smart Stats sheet in Excel 2013 (PC) using drop-down lists.
In Sheet 1, Column B contains similar drop-down lists with the following two choices: Project and Regular Work.
...

**0**

votes

**2**answers

31 views

### Typing date into a cell returns nonsense date in the year 7436

Excel is doing something funky.
I'm trying to type dates.
When I type 02022015 into a cell, it change the number to 2/1/7436.
Any ideas why it's doing this? Ghost? Operator error? Not enough ...

**-2**

votes

**2**answers

50 views

### How to find and replace a “*” character in a cell without deleting the entire contents in Excel 2010 [duplicate]

I have a large spreadsheet with a number of cells containing text that have a "*" character at the end. I would like to find and replace this character and delete it. This solution doesn't seem to ...

**0**

votes

**2**answers

63 views

### Combining numeric values that have been converted from text

I built a survey tool that our customer service agents use to track survey results. For ease, the agent simply chooses a survey value (text) from a drop down menu. There is data being collected from 5 ...

**0**

votes

**0**answers

7 views

### excel sheet updating / copied sheet isn't

my excel spreadsheet is set on auto calc. The original sheet is updating when I make corrections. The sheet I have copied into my financial workbook (with the same formulas in it) is not updating ...

**0**

votes

**2**answers

55 views

### Turning CSV into rows not columns

I have a file with unique references in column A (e.g.company names) and one or more values returned related to that unique value in column B (e.g.accounts). These are comma separated, some companies ...

**0**

votes

**1**answer

53 views

### getURL excel UDF

So in reference to a previous question I asked about displaying text and its hyperlink by referencing it in another cell, I found someone wrote this macro command for excel to retrieve the URL ...

**0**

votes

**0**answers

23 views

### How can manage stock as FIFO bases

Can someone help me to manage stock as FIFO bases?. (date wise or batch wise)
suppose, i have purchase the calculators having batch # 3 on date 1/1/15 and batch # 6 on date 10/1/15, now I want to make ...

**0**

votes

**0**answers

17 views

### Is there any formula in Excel 2010

How can I use formula value of one cell in another formula of another cell?
Suppose, I have a formula =(B2+C2+D2)/3, now I want to use the result value of this formula in another formula i.e, ...

**0**

votes

**1**answer

27 views

### Can excell put fields in a template that can then be copied as regular text?

Ive been trying to figure this out but havent found many answers for this function. Essentially what I am trying to do is have Excell put my data fields in a text template so I can copy and paste ...

**0**

votes

**2**answers

35 views

### Excel Find+Replace lowercase after a certain character

I have a column that requires specific formatting for summaries of articles. Everything after a : should appear as an uppercase for consitency
Example 1 - Markets: Comment on Ugandan Shilling
...

**0**

votes

**0**answers

32 views

### Is there a way to enter negative time into cell in Excel?

I am trying to enter a negative time value into a cell and receive the error "The formula you typed contains an error." I have tried changing to the 1904 date system but receive the same error. The ...

**0**

votes

**1**answer

49 views

### Excel - compare cells of columns and delete row if they contain partly the same value

I try to delete rows of a CSV file, where two columns contain partly the same value, like this:
ColA ColB ColC ColD
mydom/users/michael mydom2\michael ...

**0**

votes

**1**answer

243 views

### How to find matching cell values between 2 columns but return the value of another cell. Excel 2010

Image of the excel file is above/attached.
I have data in Column D that are matching in Column A
What I need is for Column C to output the value in Column B same row
So in an essence:
D2 has a ...

**2**

votes

**2**answers

51 views

### How to convert a string referencing another worksheet to an equation?

I have this cell:
="='C:\Daily Reports\" & A1 & "\" & B1 &"\[Report " & C1 & ".xls]Report'!K4
which creates a string like so:
='C:\Daily Reports\2015\11\[Report ...

**0**

votes

**1**answer

30 views

### Categorising overall probabilities of jobs in Excel

EDIT
So I've managed to get everything largely working using the SUMIF function as follows.
For <30% and >70%:
=SUMIF(D2:D392,"<30%",E2:E392)
For 30-70%:
...

**1**

vote

**0**answers

70 views

### Programmatically rotate a pie chart to fix the labels

Part 1
I'm looking at a way to automatically rotate (with VBA) a pie chart depending on the data. The data is changed dynamically depending on the month selected. Here is an example of the kind of ...

**0**

votes

**0**answers

29 views

### Excel 2010 - multiple sheet error

I have a problem with multiple sheets: every time I try make a change in more than 1 sheet at a time it doesn't work properly.
The problem: If I select 2 or more sheets and write anything in cell A1 ...

**1**

vote

**1**answer

40 views

### Show only one window in taskbar per file in Excel?

In MS Excel 2010, under Options -> Advanced -> Display, there is a checkbox called "Show all windows in taskbar". As far as I can tell, this options is global for all files opened and local to the ...

**0**

votes

**1**answer

24 views

### Date range for jobs & conversions SUMPRODUCT

I'm trying to run a report within Excel that shows the total number of jobs completed by employees within a date range and also a count of the number of conversions per employee within the same date ...

**0**

votes

**0**answers

24 views

### How can I turn table column headers which hold dates into pivot table and be able to consolidate by fiscal year or quarter

I have a table that we use to standardize client company financial information.
How can I manipulate this table so that I can easily use pivot tables and group the dates by Year or by Quarter?
...

**0**

votes

**2**answers

39 views

### Excel: count unique instances across two columns

I have a spreadsheet that has a column for cell sites and another column for frequency like this:
SITE FREQUENCY
MA1084 687
MA1084 687
MA1084 687
MA1084 4382
MA1084 4382
MA1084 ...

**0**

votes

**0**answers

41 views

### Looking for nearest value in multi-row / multi-column data

For my bachelors-paper I need to look up a value for the area (AE) of a rail given the current it must be withstand (Iz). So, I need to search for the value or the value closest to it. Also I must ...