The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
2answers
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
0answers
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
0answers
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
2answers
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
0answers
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
1answer
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
2answers
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
0answers
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
2answers
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
2answers
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
2answers
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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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 ...