**2**

votes

**1**answer

186 views

### Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple.
Suppose the following example:
There are two tables, one containing animals, and the other one ...

**1**

vote

**2**answers

73 views

### MS Excel Column content replication across two sheets

Microsoft Excel functional Question
How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...

**0**

votes

**3**answers

47 views

### In Excel replacing a column with another column

I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...

**0**

votes

**1**answer

94 views

### Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...

**1**

vote

**0**answers

55 views

### Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...

**0**

votes

**1**answer

45 views

### excel - if value grater than, use that value

I am having problems with my excel function. I want to:
if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell.
...

**0**

votes

**2**answers

35 views

### How can I work out days, hours and minutes from a total number of minuts?

In Excel I have a number of minutes that I need to convert in to days, hours and minutes, but I cannot figure out how to get the minutes. Here is how the data must be presented -
Total Minutes Days ...

**2**

votes

**0**answers

38 views

### CTRL+SHIFT+DOWN not working in Excel 2007

CTRL+SHIFT+DOWN is not working in Excel 2007. I have unchecked Excel Options>
Advanced> Tools>Options> Transition Navigation Keys.
CTRL+SHIFT+UP arrow is working fine. If I connect to an external ...

**0**

votes

**1**answer

44 views

### How to change the size of my 'glow' effect on excel, when I use custom color?

When I create a shape in Excel(2007) I apply some effects in it on Format > Shape Styles > Shape Effects, with one of them being "glow" with some predefined colors and sizes.
What I'm trying to do ...

**0**

votes

**1**answer

40 views

### New instance of Excel does not see already opened instance

I have Avizo.xlt with one Worksheet and a code which intended to put this WS inside already opened document, which is SLK report made by our ancient ERP system, and close this document.
Everything ...

**2**

votes

**1**answer

56 views

### Sumif range of criteria

I've checked different questions and answers on the site, but couldn't find what I'm looking for.
I try to have a sum of values, using multiple criteria (OR): When I use, e.g.,
...

**3**

votes

**1**answer

811 views

### Excel - Get rid of extra space in cell when using Text Wrap

When I type a long sentence (or more than one sentence) into more than one cell in a row, and apply the Text Wrap option to these cells, the cells have an extra blank line on the bottom of them. There ...

**0**

votes

**1**answer

545 views

### Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)

I have made a spreadsheet to specify decoration selections from a range of standard options.
There are five separate ranges so this is the first selection then within each range there are additional ...

**-1**

votes

**2**answers

26 views

### Referencing cells from a different worksheet

Im trying to reference data within a cell of first work sheet (active) on a second worksheet (trucks). When I use =active!$L$34 on my second worksheet (trucks) it bring the right number over. However ...

**0**

votes

**1**answer

17 views

### How to match Reg No. in one workbook to another

I want to find out a formula to match Reg No. for two workbooks.
First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in ...

**0**

votes

**0**answers

37 views

### How to see green and purple box around charts?

When I create a chart in excel and I click on the chart I would like to see the green boxes around all the data that the chart plots as well as purple boxes around the headings. How do I enable this ...

**2**

votes

**1**answer

75 views

### Excel inconsistent date conversion

I'm running Excel 2007.
I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...

**0**

votes

**0**answers

82 views

### Excel, Compare columns values between 2 sheets and if any match update data if one

I 've found many useful info at the past from the forum, but now i trully need a hand.
So, my issue is: i have 2 sheets containing some common columns, lets say Product Name, ID#, Price etc. How to ...

**0**

votes

**0**answers

47 views

### “Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...

**1**

vote

**1**answer

33 views

### What's the best way to merge 2 tables keeping 1 column aligned?

What's the best way to merge 2 tables keeping 1 column aligned?
Example: I have these 2 tables from which I want to make table 3:
TABLE1
color name1
red apple
orange orange
yellow banana
...

**0**

votes

**1**answer

42 views

### Method to Consolidate Cell Contents from Two Excel Files into One Excel File

I translated an Excel file in Chinese into English with OmegaT, a CAT (Computer-Aided Translation) tool, and a pure English file was generate by OmegaT.
However, the customer wants me to submit an ...

**0**

votes

**1**answer

110 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**0**

votes

**1**answer

1k views

### VBA Excel: Function to find a string in another workbook

I'm trying to create a function that searches a string (bom) in two different workbooks and returns a value next to that string. I know the ranges in those workbooks where I want to perform the ...

**0**

votes

**2**answers

291 views

### Excel - column width differences in copied worksheet

I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open ...

**0**

votes

**1**answer

31 views

### Separate cell content after “-” for multiple columns at once

--------------------------------------------
| Visible | Actual formula | I need |
--------------------------------------------
| 0 | =500-500 | 500 |
| 0 | ...

**0**

votes

**1**answer

231 views

### VBA Excel: How to select only numeric values in a range?

I used Range.Find to locate a string called "Qty", now I want to select all the numbers in that column.
I would use .End(xlDown) to get the last row, however the last used cell in that column is not ...

**0**

votes

**0**answers

47 views

### How to compose one table out of many tables?

I have a couple of tables which contain various data and I'd like all of them to be composed into one table.
In one of the tables I have a lot of entries with various IDs for different things on ...

**0**

votes

**1**answer

356 views

### Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...

**2**

votes

**1**answer

135 views

### Horizontal Index Match Excel 2007

i have a list of customers rows 1-500 column B, with their purchases showing in columns u-AB
and based on the maximum purchases done under a specific column (u-ab), the customer will be tagged as ...

**0**

votes

**1**answer

585 views

### How do I get Excel to pull data from multiple workbooks from exact dates based on an entered date

I am running windows-7 and using Excel 2007 Enterprise.
I am a truck driver and need to catalog my pay based on a changing day to day system. I am paid per mile, per stop, per hour, or per flat rate ...

**0**

votes

**0**answers

37 views

### Microsoft Office Excel 2007 conditional formatting

I have an excel sheet (2007). It is a tracking log of items. In one column I will input the date of the item received and in the next column will be the due date for that item (Example in I15 I have ...

**0**

votes

**1**answer

179 views

### VBA string search within files in directory not working in Excel 2007

I'm trying to look for a string within a folder containing several files. Once the string is found it should select and copy a value in an adjacent cell 5 columns to the right(Offset(0,5)), then paste ...

**-1**

votes

**1**answer

35 views

### Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...

**1**

vote

**0**answers

24 views

### Excel: cannot remove advanced filter

I added Data->Sort&Filter->Advanced filter to a cell that allows me to quickly choose a name from a range of names stored in another sheet some time ago.
Now I would like to remove the advanced ...

**0**

votes

**1**answer

171 views

### Excel - Script that search a sheet for a cell containing specific text, and replace the text with a specific value

I want to split a cell with data into other cells based on the data in the original cell. The data from the original cell looks like this (all content in a single cell):
...

**-1**

votes

**1**answer

117 views

### Invalid date value in csv file

I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...

**1**

vote

**0**answers

54 views

### Excel, sort through columns

I need to sort through a a few excel columns and can't seem to nail down an easier way besides manually going through line by line. Column A has names where names can repeat, column b has state ...

**1**

vote

**1**answer

77 views

### How to change cell format from [ss] to number without changing values

I am doing my Msc Ecology thesis and in the process of organizing my data set. When inputting my data for the amount of time a skink spent in a hole I inputted h:mm:ss for the time it went in and the ...

**0**

votes

**2**answers

44 views

### Indirect turns up with #ref error

I want to use INDIRECT in a formula like =INDIRECT(CONCATENATE(A1,"+",A2),0);
where A1 = 7 and A2 = 8.
It comes out with #REF error all the time, but if I use the INDIRECT formula like this: ...

**1**

vote

**1**answer

74 views

### IF statement with multiple answers

I want to make a table and c4 will be radius required and the minimum weight for that radius requirement will be in D4
The chart is;
radius quantity
0,040 - 0,06 : 33
0,061 - 0,10 : ...

**0**

votes

**1**answer

29 views

### Access table data by row index

I have a Table in Excel that is laid out as follows. What I require is a way of accessing a table row by index for a calculation.
To be precise, I have been asked to work out an overall coefficient ...

**0**

votes

**0**answers

92 views

### Getting data from closed files with concatenate formula

Each day a program is creating an excel file for me with some data for the current day.
Like what is the price for products, how many people are available today and things like that.
Based on all ...

**0**

votes

**0**answers

80 views

### I'm looking to create some VBA code to search for other instances of certain string, move original instance above found

Please excuse me if I'm posting incorrectly in any way- this is my first go round on superuser.
I'm looking to create a fairly basic VBA macro to automate a process in excel I'll otherwise have to ...

**0**

votes

**0**answers

109 views

### how to convert data in table format to pivot format

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have:
![Input File][1]
Product Currency Value US UK Japan Ind ...

**0**

votes

**1**answer

99 views

### Count from a cell with value to the end of row and dividing total by number of number of months regardless of blank

How do I write a formula that will auto start sum from the first cell with value though to the end which including blanks, and then divide the total by number of cells from the one with value through ...

**0**

votes

**2**answers

402 views

### Compare two columns in two sheets

I have another question, even though the last one i asked is still pending. I have a large data of over 100,000 records. I am using the code below to loop through the data so that any duplicate ...

**0**

votes

**1**answer

813 views

### Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form:
X | Y
----+-----
3 | 42
4 | 57
6 | 92
11 | 119
19 | 316
(NOTE: The above table is made-up data)
What I'd like to do with MS-Excel is to plot 2 ...

**1**

vote

**1**answer

47 views

### Formula works in excel and not in Google Spreadsheet

The following formula works in Excel but not in Google Spreadsheet:
=INDEX(Sheet1!B1:P1,MATCH(MAXA(Sheet1!B11:P11), Sheet1!B11:P11,0))
Would there be alternatives?
Thanks,
Bing

**0**

votes

**1**answer

68 views

### How can I exclude Spin Buttons from my Excel sheet protection?

I am using Excel 2007. I need to exclude Spin Buttons from my Excel sheet's protection.
Any help would be appreciated.

**0**

votes

**0**answers

78 views

### Excel file is locked by another user on sharepoint and he is not at work and none is able to edit it

as this user is not available now we cant wait until the person comes and need to release the lock immediately for others use.
This file is used by many and one user locking it for edit and leaving ...