The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
14 views

If Statement Vlookup doesnt work

I have the following statement. =IF(AG5="","",(IF(VLOOKUP(AK5,'Daily CC'!H:K,4,FALSE)="split","S",(VLOOKUP(AG5,$AH:$AI,2,FALSE))))) It looks to make sure there is value in AG5. If AG5 has value, ...
0
votes
2answers
19 views

Day of the week and Time Graphing in Microsoft Excel

I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed). How can I graph this so ...
0
votes
1answer
25 views

In Excel, 'ALT and =' is returning a symbol instead of the sum function

In Excel 2010, Alt= is returning a symbol instead of the sum function. How do I get sum function back?
0
votes
1answer
22 views

Excel - Copy multiple Rows and paste using formula

In Excel, columnA I have values which need to trippled in columnB So I currently have A 1 val1 2 val2 3 val3 I'd like each value to be trippled in column B, such as A B 1 ...
0
votes
1answer
30 views

Excel - Look up list of substrings within large strings

I've been struggling with the following; might be a bit of a challenge. I have an Excel file that was exported from an XML application. Sheet 1 contains rows of strings like those below. Every ...
0
votes
1answer
19 views

Calling a function from another workbook

I've got a pile of data in one worksheet that I am trying to save to individual workbooks based on values in several columns. The approach I am taking (for better or worse!) is to copy the relevant ...
0
votes
1answer
23 views

Read one worksheet and load data into another one but not just as a reference

I have a list of equipment assets and attributes which is a raw data dump from a database. Among attributes like equipment status (like running, in standby etc.) or Oil level it also includes things ...
-2
votes
0answers
10 views

Move to Excel Open Office? [on hold]

Along recent years , I´ve had problems with my Excel (Office 10) archives.But none was lost. E.g. one had 5000 contacts but with only 4 fields. No formulas nor formats. A technician, saw my ...
1
vote
3answers
39 views

Subtract values only if all are numbers

I want to subtract four cells in excel from one specific cell but only if any of the four cells have a value. More specifically in my case the formula in cell L2 is currently ...
-2
votes
0answers
18 views

Excel Formula Multiple If Statements with text value [on hold]

I am trying to develop a closed product log. The hope is to have a product, say "Apples" or "oranges," be selected and then once it is also selected as a closed sale, it will apply a point value for ...
1
vote
1answer
18 views

Excel: Conditional formatting not filling in cells if adjacent cell is filled

I am trying to fill a pair of cells in if both are blank. Which works unless the cell next to the pair is filled in. How do I go about resolving this issue? Formula: =AND(ISBLANK(F2),ISBLANK(G2)) ...
0
votes
1answer
11 views

Selecting and highlighting in a column using row numbers from different cells

Help: I have two cells in the same column in Excel marked with an x (for convenience). I want to use the row numbers of these cells to highlight and select a range in another column between these 2 ...
0
votes
3answers
27 views

Excel multi table lookup, can you find a more elegant solution?

This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...
1
vote
0answers
26 views

Combining INDIRECT() and UDF [on hold]

I have created an Excel UDF to find the nth occurrence of a value in a range. The UDF is based on the one at http://www.ozgrid.com/Excel/find-nth.htm: Function Nth_Occurrence(range_look As Range, ...
1
vote
2answers
29 views

Count number of selected cells

How do I count the number of selected cells, regardless of cell content?. There are two use cases. I need use case 2 right now: When I make one or multiple selections, I want to know how many ...
7
votes
4answers
618 views

Formula comparing cell to fixed date always returns false

The following formulas in Excel 2010 both give me a "No" answer: Formula: =IF(S8="24/03/2015","Yes","No") where S8 has format/value dd/mm/yyyy / 24/03/2015 =IF(S9>"30/06/2013","Yes","No") ...
0
votes
0answers
29 views

Excel: Find duplicates among 2 colums

Giving an excel file with 2 columns: A: 5000 numbers (some repeated) B: 525 unique numbers I want to know if for each number in A there is a instance of that number in B. Meaning: for A1, is ...
0
votes
2answers
49 views

Excel - Manipulating data in awkward format

I have a dataset that I want to analyse, but it is in quite a strange format. See below: > Account_Details Account_Name > account # 1 client name > product 1 name ...
2
votes
2answers
32 views

Hide data label containing series name if value is zero

I have made a chart in excel in which I would like to hide the data label if value is zero. For data labels that contain the value itself this is done by using custom formating as explained here How ...
0
votes
1answer
14 views

How can the content of multiple cells be copied to a single cell? [on hold]

I need to copy content of cells from immediate left but not a range, but selected cells into a single cell. The cells will either have a normal number or a currency figure. How can I do this? I ...
1
vote
1answer
28 views

How do you create a conditional nesting formula on excel 2010 with more than 3 conditions?

I have "A, B, C and D." I need " if a>0, use a, otherwise, use b. If b has the error "#N/A", use c, otherwise use b. If c=0, use d/61, otherwise use c. So far, I have this: ...
-2
votes
1answer
64 views

Determine if a financial year has a leap day in it in Excel

Our financial year runs from the first of March to the last day of February. I need a formula in Excel that tells me if the financial year has a leap day (the 29th of February) or not. For example ...
2
votes
2answers
66 views
+150

Protect formatting in Excel 2010, and allow editing of text

I am using Excel 2010 with a shared workbook. I need the formatting protected, but allow users to edit text and select from drop-down boxes. Following the instructions in this answer to Protecting ...
0
votes
1answer
22 views

How to chart two columns of data in excel

I have the following data and I want to create a simple chart in Excel 2010 but can't work out how to get this to work. I've tried scatter charts, switching axes, etc. and nothing seems to give me ...
1
vote
1answer
25 views

Excel to show icon

I want to have icons that will signify increase, decrease or equal from the prior cell. For example below in C2, the icon should increase when compared to B2 (because its value is greater). The ...
2
votes
1answer
81 views

Excel 2010 scrollbar goes too far

My problem is illustrated in the PrintScreen below: I've searched a lot on the Internet and almost all sources say to delete the empty rows at the end of the sheet and save the document. For ...
3
votes
2answers
27 views

How to format text between branches excel using a macro Excel 2010

I found a little macro to change all the text between "[" and "]" red in excel. But i can't get it to work in Excel 2010, i get some errors. Can someone help me debug this? At the end i wish that in ...
0
votes
2answers
30 views

Copy Table values from one sheet to another

On the first sheet of the spread sheet I have the following: 1 Item Item Description 2 xxxxxx yyyyyyyyyyyyyyyyy 3 4 Object 1 Object 2 Object 3 5 AAA ...
1
vote
1answer
23 views

How do I display the value of one cell in a cell on another sheet?

I would like to build a spread sheet with multiple sheets. The first sheet is the main 'working' page. The additional sheets would be filters of data found on the first sheet. On the first sheet on ...
0
votes
2answers
35 views

Merge two Excel files and only retain new data?

I manage a daily shipping report (an Excel file) that has many date fields (departure, arrival, etc.) that are populated automatically from our shipping system. In the last column of the report I add ...
0
votes
0answers
12 views

How do i get a cell to read multiple options for a seperate cell [closed]

I am trying to get a cell to read another cell with different possible names in it and be able to reference the names to a separate items. Example: cell b5 has different items and cell c5 reads a ...
2
votes
2answers
25 views

Excel text to appear on screen but not print [duplicate]

I am creating a contract in excel and I do not want the line item pricing to appear when printed. Changing the font color to white is time consuming so not an option. Hiding the group of cells would ...
0
votes
1answer
27 views

Excel Office Pro 2010 SUMIF

Hi Im trying to SUMIF(range;"<>#N/A";range) but the cells im selecting to sum are not in a row adjacent, its every 4th cell in the row. But when i try it gives an argument error each time i try ...
3
votes
1answer
38 views

Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column? Let's say I ...
-1
votes
0answers
19 views

Replace cell references with values without F9 using macro (2) [duplicate]

I tried to use the macro in this post but it doesn't work on mine. Can you help to tweak this macro abit? I want to change from this: =((J26*J27*J28+J34*J35*J36+J30*J31*J32)*24/1000000) ... to ...
1
vote
2answers
20 views

Finding repeating digits at the end of a string of digits

I have a list of 10 digit toll free phone numbers. I would like to identify those that contain at least 3 repeating digits in the last 4 digits of the number. For example: 8xxxxx5444 8xxxxx2220
1
vote
2answers
17 views

Copying many cells to one location

I transfer data around a lot in Excel. I want to be able to copy many random cells to another location so that they are side by side. E.g. I want to copy a3,d21,aa32,cd121,etc. so that ...
1
vote
1answer
56 views

Excel chart for rail car movements

I need to display the movements of a group of rail cars between two locations. Each car has dates for "left location A", "arrived location B", "left location B", "arrived Location A" - repeatedly ...
0
votes
2answers
59 views

How to translate months automatically from a language to another?

I'd like to translate a billing report from Portuguese(Brazil) to English. It is accurate by months and it is an automated sheet. A contract may start on January, but it's commonly started in the ...
-1
votes
0answers
26 views

Extract address from HYPERLINK cell in Excel 2010

I have a HYPERLINK cell in Excel 2010 where I have many rows on it. I want to extract underlined address from that HYPERLINK cell. Below macro is not working for me. Function GETURL(HyperlinkCell As ...
1
vote
1answer
27 views

Excel conditional drop down lists causing massive file size

I have an excel file which relies heavily on data validation. There are about 20 drop down lists per row. One column has a 35 formatting conditions. One column is a conditional drop down list (using ...
0
votes
1answer
32 views

Functions (specifically text functions) within a countif function

Is there any way to nest text operators within a countif? I want to check if the first 4 characters of a file are in the form A**. =Countif(Left(A1,4),"A??.") doesn't work, but I can put in a ...
1
vote
1answer
53 views

How to fetch data from another excel file and sort it under name?

I have 2 excel files, one of them is a list of workers and the other is a list of absences. I need to have the reason and the ending date from the absences list to be fetched into the main list, and ...
1
vote
0answers
29 views

Matching a column range based on a column label

I have written a spreadsheet for Excel 10 and am struggling with the last bit of formula. I wrote this: =SUMPRODUCT(--(ISNUMBER(FIND(B7,'PO SHEET'!$K$7:$K$74))),('PO SHEET'!$W$7:$W$74)) However, ...
-4
votes
0answers
23 views

Get the average of the last 5 non-zero cells in a row (not column) [duplicate]

Objective: Get the average of the last 5 non-blank cells in a row (not column). I am using Excel 2010. I have a row of 12 cells and weekly will enter a number or sometimes nothing at all. After ...
2
votes
1answer
39 views

Excel Strange Extra Digit

In Excel 2007/2010, I get this strange behaviour: Formula in cell: =2.6+1.4+4.62-8.2 Result in cell: 0.420000000000002000 Weird extra '2' about 14DP in. Can anyone explain why this is happening ...
1
vote
1answer
35 views

Excel add-in not loading when opening Excel from VBA

I'm using excel reg-ex add-in and it works well, the only problem with it that it doesn't load when excel is started by VBA. I've a macro in word to collect some data in Word and copy it to excel, ...
1
vote
1answer
30 views

Generating coefficients for SERIESSUM formula in Excel

I'm modelling a cash collection spreadsheet where a company sells products each week and wants to collect cash over a number of weeks (n; between 42 and 336 weeks). Assuming n is ≤ 52: To calculate ...
0
votes
2answers
29 views

how to insert a helper column?

I have an excel spreadsheet where each data set covers three rows. I want to sort the data based on the value in column K, which is in the third row of each data set, there are no values in rows 1 ...
1
vote
2answers
37 views

Excel 2010 Advanced Filter issue

I ran into something I can't really explain trying to filter a huge pile of data using the advanced filter... I had a document with hundreds of thousands of lines (.xlsb) containing a whole bunch of ...