# Tagged Questions

The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

9 views

### Pick matching data from a column and copy the row to a corresponding tab

I have a column of dashed part numbers and data in Master tab - A1-3, A1-45, B2-56, C1-2, C1-4, C1-5….
I separated the first two string characters (Part Family Identifier), removed the duplicates ...

**0**

votes

**2**answers

23 views

### Excel - Copy cells without formatting / style data

I'm trying to copy a range of cells from an Excel 2010 spreadsheet and paste them into a table in AutoCAD LT 2016. My problem is Excel applies formatting information to each of the cells. AutoCAD uses ...

**0**

votes

**1**answer

22 views

### adding criteria to an existing equation

I have this existing equation with two criteria
=SUMPRODUCT((kshc2013D=A6)*(kshc2013A=1))
what I want to achieve is if I add a third criteria wherein it will only count month January and April to a ...

**1**

vote

**1**answer

18 views

### Summing up values from a user-defined range

I have a spreadsheet from January 1 to present. and I needed to sum up the value parallel corresponding from the range which the user defines.
For example:
in Column A are the dates January 1 - ...

**1**

vote

**0**answers

18 views

### Barcode in Excel 2010

I need for my company the possibility to create easy a barcode in excel. It should convert 123456 into a Barcode Code 128. Is this possible? We don't want to download a Software or any other stuff ...

**-1**

votes

**1**answer

14 views

### Count How many times an item appears in relation to a value from another cell

I have 2 worksheets, what I want to achieve is to count how many times an item in column B appears if column A has a value of "1" on it.
Worksheet 1
Column A (A2=1, A4=1, A7=1, A10=1, A13=1, A14=1, ...

**1**

vote

**2**answers

20 views

### Excel Function: Count the number of Rows that do not have a certain value and are not blank

I am trying to count the number of rows which do not have the values "X", "Y" or "Z". Also, the values should not be blank.
I am using the formula below to count the number of rows that have the ...

**0**

votes

**2**answers

25 views

### Count only rows containing one of a specific set of values

I am trying to build a formula in Excel 2010 to count rows in which columns A1:A1005 and U1:U1005 contain either Y, N or NA. I want to exclude rows that are blank or have any value other than Y, N or ...

**0**

votes

**2**answers

21 views

### How to combine values from multiple rows into a single row with a comma separator

I have an Excel file that lists product SKUs in one culumn and product image URLs in a another column. My problem is that the file has multiple rows for the same product...
...when the CMS I use on ...

**1**

vote

**2**answers

25 views

### Counter in Excel

My file has 50 sheet inside, which each sheet is a standard form. Lets name as Form1, Form2, Form3.
I want to create a print sheet, where I select which form I want to see, so that I don't need to ...

**0**

votes

**1**answer

21 views

### Excel Formula Is unwantedly automatically changing

I have created a product referral log and needed to have a system that automatically calculates points for those products once they are closed.
My solution for this was to make a separate sheet ...

**0**

votes

**2**answers

25 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

**1**answer

28 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

**1**answer

23 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

**1**answer

36 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

**1**answer

22 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

**1**answer

31 views

### Read one worksheet and load data into another one but not just as a reference [on hold]

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

**0**answers

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

**3**answers

41 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

**0**answers

20 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

**1**answer

19 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

**1**answer

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

**3**answers

30 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

**0**answers

27 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

**2**answers

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

**5**answers

635 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

**0**answers

31 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

**2**answers

50 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

**2**answers

35 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

**1**answer

15 views

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

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

**1**answer

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

**1**answer

65 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

**2**answers

86 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

**1**answer

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

**1**answer

27 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

**1**answer

82 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

**2**answers

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

**2**answers

31 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

**1**answer

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

**2**answers

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

**2**

votes

**2**answers

26 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

**1**answer

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

**1**answer

42 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

**0**answers

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

**2**answers

21 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

**2**answers

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

**1**answer

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

**2**answers

61 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

**0**answers

29 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

**1**answer

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