**0**

votes

**0**answers

8 views

### How to assign shortcut to save file as text Tab delimited in excel

I work a lot on excel and quite often need to convert an Excel file to text tab delimited file. I do not want to go through the routine procedure of Save As dialog box.
Can I assign a shortcut to ...

**0**

votes

**0**answers

5 views

### Excel group files not opening

The OS is Windows XP 2003 server and the program is Microsoft Office Standard 2007 (Excel). This computer recently upgraded from Office 2003 to Office 2007.
Upon clicking any .xls or .xlsx book file ...

**0**

votes

**0**answers

5 views

### Calculating frequency of only visible cells

I'm having trouble calculating the frequency (in order to plot a histogram) from filtered data.
As for now, on Sheet1 I have the data of ten temperatures with a filter, I assigned a name for each ...

**0**

votes

**1**answer

14 views

### Excel - Counting unique values with multiple criterias

I have a large scale data set and I am looking for a way to count the number of unique values:
Day -ID, Location-ID, Truck-ID
1, 18, 1
1, 19, 1
...

**0**

votes

**0**answers

8 views

### Exponential increase

I need to calculate the exponential growth, I think, of 0 to 60 with a distance of 340mm between them. the growth is not linear but starts small and then increases as it moves to the 60 mark. How do I ...

**0**

votes

**2**answers

25 views

### Create New Spreadsheet of data from many Excel workbooks

In retrospect, this is an issue of data-collection, but I want to see if there is an easy way to do it without doing each file.
I have about 350 separate Excel workbooks. Each workbook has a bit of ...

**0**

votes

**0**answers

20 views

### Matching a Date Conditional on its Distance to Another Date

I have a set of names and datetimes on two sheets. One sheet we'll call LargerSheet and the other we'll call Sheet1. On LargerSheet each name has multiple datetimes associated with it. On Sheet1 ...

**0**

votes

**1**answer

24 views

### Excel Formula Assist - Find missing numbers

I have a spreadsheet exported from my database that contains Roles and Account IDs. There are 4-5 role names per account ID. I need a formula to display any accounts that do not have a role of RBD. ...

**-1**

votes

**0**answers

13 views

### Execute an Excel 2010 Add-In

An excel add-in seems to be the easiest way to share a macro I created with my team. I saved the workbook as a .xlam file and installed the add-in so it shows up under the addins button with a ...

**0**

votes

**1**answer

17 views

### How can I use a formula or conditional formatting to format mutilple criteria?

I am trying to do an excel function, either an IF formula or use conditional formatting to do an AND formula.
I need it to produce all three results in one formula, it is:
if the date is before ...

**0**

votes

**1**answer

16 views

### Replace two numbers in a column with 99

I have Selling Price which is not in proper format as its converted from Dollar to our local currency.
So the amount in the column are ending with random number. I want to change last two numbers to ...

**-5**

votes

**0**answers

23 views

### Plot a graph in excel [on hold]

I am not able to plot the graph in MS Excel from following data.
nm Abs
450 0.001
449 0.001
448 0.001
447 0.001
446 0.001
445 0.001
.
.
194 0.010
193 0.010
192 ...

**-1**

votes

**0**answers

8 views

### Historical data in excel

After inputing data i have a number X that is calculated at a date Y.
I want to keep track of all all the generated X value at the dates y, in a list.
In case i drage down the formula, at every entry ...

**1**

vote

**1**answer

15 views

### move worksheet to another workbook, without the vba code but keeping the colour scheme

I current have some code that first copy a worksheet do some cleaning and then move it to another workbook.
My problem is that when i copy or move a sheet it also copies the vba code that is attached ...

**0**

votes

**1**answer

12 views

### Inserting a row in Excel yields a new row in different worksheet. How do I stop this?

I "inherited" a complex Excel workbook that I now need to update (without breaking).
I have 2 worksheets (tabs at the bottom) that reference each other in formulas, et al. Formulas make sense to me, ...

**1**

vote

**1**answer

12 views

### Sumproduct, Sumif, Indirect and named ranges issue

I have this formula that works:
=SUMPRODUCT(SUMIF(INDIRECT(Financials&"!$B3:$B10000"),'Information PG1'!$K$2,INDIRECT(Financials&"!d3:d10000")))
where Financials is a named range. If I ...

**2**

votes

**0**answers

13 views

### Where Does Office Read The Username Displayed on “File In Use” Warnings?

When another user has a Microsoft Office document open, and you try to open it you will receive the warning below. This is fine and dandy, but the username that is displayed on this is not always ...

**0**

votes

**2**answers

40 views

### Indexing a Date Range if Date is Greater Than and Within n Days of Another Date

In a previous post I asked a question about how to find the most recent date associated with a particular entity and have that value returned in Sheet2 so long as it was greater than the associated ...

**0**

votes

**0**answers

12 views

### Could not load an object as it is not available on this machine - Excel 2010

Got an issue that is driving me mad. Every time a user accesses this file, he always gets the error messages: "Could not load an object as it is not available on this machine" & "Compile error in ...

**0**

votes

**1**answer

19 views

### How to sum every second column depending on the first column value

Team,
This is driving me mad.
I know how to sum every second column in a row: ie {=SUM(A1:G1*(MOD(COLUMN(A1:G1),2)=0))}
What I need to know is how to sum all of the first columns unless there is a ...

**-1**

votes

**0**answers

14 views

### plot a 3d histogram in excel 2013

found some very helpful explanation how to plot a 3D histogram in excel and that worked for me. It looks like this
http://excelgraphs.blogspot.de/2013/04/3d-histogram-in-excel.html
But is there ...

**0**

votes

**2**answers

29 views

### How to repair corrupt MS Excel (XLS and XLSX) Files

I have important MS Excel file data and unfortunately got corrupt due to virus attacks, so my crucial Excel sheet got lost, How to repair corrupt MS Excel (XLS and XLSX) Files. If have any solution ...

**0**

votes

**0**answers

13 views

### Why are the formats of two data series in my Excel graph linked?

When I modify either the chart type or select primary / secondary axis for a series in Excel, the settings on another series in the same chart change to match that new setting. How do I stop this ...

**2**

votes

**1**answer

22 views

### How to create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this:
30.5.2014 700,80 CZK
6.6.2014 1 000,30 CZK
20.6.2014 ...

**1**

vote

**1**answer

16 views

### How do you copy the value from one cell in one worksheets to two cells in consecutive rows in another worksheet by dragging down?

How do you copy the value from one cell in one worksheets to two cells in consecutive rows in another worksheet by dragging down?
Example:
Worksheet 1:
1
2
3
Worksheet 2:
1
1
2
2
3
3

**1**

vote

**2**answers

43 views

### Why does Excel display my information like this in print preview?

Here's what it looks like in regular mode:
And here's what it looks like in print preview:
I'm very new to Excel, have been having many similar hiccups.

**0**

votes

**1**answer

15 views

### Calculated Fields in Pivot Table

I am looking to add a custom calculated field to my POWER PIVOT
Store 1
Product Category 1 - 10
Product Category 2 - 10
Store 2
Product Category 1 - 12
Product Category 2 - 13
Store 3
Product ...

**0**

votes

**1**answer

25 views

### Search from bottom with multiple criteria

I am trying to search a data table in excel and find the bottom most row that meets a specific criteria. I thought I could use this LOOKUP trick but it only returns a #DIV/0 error. This is what I ...

**3**

votes

**4**answers

183 views

### Showing whether a list in Excel has a 1 or a 0 in it

So I have a column in excel that I want to roll up into one row. Essentially the column has a 0 if a feature isn't present, and a 1 if it is.
What I want to do is get excel to check a column, lets ...

**-1**

votes

**1**answer

10 views

### VBA AutoFilter gives runtime error 1004

Could anybody help me find what's wrong in the autofilter line below?
It gives run time error '1004'.
Sub filter()
Dim rng_source As Range
Set rng_source = ...

**-1**

votes

**3**answers

38 views

### Excel Formula to match dates

This may sound really simple but I need a formula that checks if one column's date is the same as another, and if so put 'true' or '1' or something. I tried =IF(H2=G2, "True", "False") but it does not ...

**-5**

votes

**0**answers

21 views

### Deleting rows in MS Excel. Huge delay [on hold]

I am trying to delete 100K rows from 700K-row sheet. It has been more than 3 hours now. RAM 4GB, CPU 3.30GHz. Ram usage 68%, CPU 25%

**0**

votes

**0**answers

16 views

### Web queries have slowed down after updating Excel 2003 to 2010

I built an excel workbook in windows XP. Using excel 2003. I have moved the file to excel 2010 on Windows 7 enterprise. The workbook has about 20 web queries. I had no problems in the earlier ...

**0**

votes

**2**answers

42 views

### Check two conditions in two different columns, to pull amount in third column

Example:
**TYPE** | **New** | **Amount**
MM | YES | $25.00
DDA | YES | $0.00
MM | NO | $0.00
MM | YES | $25.00
Basically, I want to get the total amount ...

**0**

votes

**2**answers

35 views

### How do I categorize a list?

I'm looking to categorize/sort a list by matching certain strings. I previously couldn't find a solution so hopefully this way is easier.
Example list:
[A]
The apple is the pomaceous fruit of the ...

**-1**

votes

**0**answers

19 views

### Using two Private Sub Worksheet_Change(ByVal Target As Range)

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B10").Value = "0" Then
Rows("9:12").EntireRow.Hidden = True
ElseIf Range("B10").Value > 0 Then
...

**1**

vote

**3**answers

37 views

### In Excel, How can I count duplicate names in one cell once, if they are attributed to another name

How can I count duplicate names in one cell once, if they are attributed to another name in another cell.
One column A contains teachers names and column B contains student names. I need to know how ...

**1**

vote

**0**answers

28 views

### Excel 2011 conditional formatting, problems w/ adding deleting rows

I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...

**0**

votes

**2**answers

25 views

### Getting current value and passing it to another function

A B
1 Date Data
2 1/1/2014 1
3 1/2/2014 2
4 3/5/2014 3
I wanted to sum up rows for certain months. With month I can get the month and sumif ...

**2**

votes

**1**answer

20 views

### How to export data from Excel to SQL Azure?

I know how to import data from SQL Azure into Excel
From Excel go to:
- Data
- From Other Sources
- From SQL Server
I want to manually edit data and post it back to SQL Azure. What is the ...

**0**

votes

**2**answers

46 views

### Searching and Inserting Data Based on Date Range

In another post, a formula was given that was meant to help search and insert an entry if the date associated with the entry was less than the date on another sheet. The formula was as follows:
=IF(
...

**0**

votes

**0**answers

19 views

### Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...

**0**

votes

**5**answers

37 views

### Pivot table - Summarising multiple independent data columns

I have a large table containing daily inputs into a system, which has the columns as shown:
Day Itemname1 Itemquant1 Itemname2 Itemquant2 .....
The item names and quantities are independent of each ...

**0**

votes

**0**answers

15 views

### How to exclude my titles and name an entire row so it can be updated

I have an assessment where I have exported data from Access to Excel and need to do a mail merge but am having trouble understanding. I need the first name column to be able to update if and when ...

**2**

votes

**1**answer

59 views

### notepad and notepad++ don't show same thing?

I have exported text from Excel in Unicode, like this:
then I edit with Notepad++ and change it to my desired form and save it as UTF-8 like this:
but when open it it in Notepad it is in ...

**0**

votes

**0**answers

16 views

### Reference last cell not only in a row or column, but in a range

all users, especially Jerry Beaucaire.
I was reading this link when I stumbled upon his answer
Here is the link
How to refer to the last cell in a row in Excel?
And Jerry Beaucaire answered it like ...

**0**

votes

**1**answer

28 views

### Can I separate a list by keywords?

Say I have a list:
Something something apple
Something something orange
Something something banana
Something apple something
Something banana something
Something orange something
Something something ...

**2**

votes

**1**answer

36 views

### Excel Help: How to scan a row and return the value of the first cell in that column

I have a matrix of numbers and the matrix has column header -- say like this:
a b c d e f
0 0 0 1 0 0
0 0 1 0 0 0
What I want to do is to search for each row for the element 1 and return its ...

**0**

votes

**2**answers

29 views

### Excel - Is there a function to return a number based on which string is in a cell, like CHOOSE but not?

I need a function =Func(A1, "Alex, "Betty", "Charlie") that returns the index of the matched entry. If this function is put into B1:B13, it would show
"Charlie" 3
"Alex" 1
"Alex" 1
"Alex" ...

**2**

votes

**3**answers

27 views

### Custom Sort using Excel without Custom List

I want to be able to sort excel rows where data looks like
Column - 1 Other Columns
701-GBL-1843-MLMK blah
566-JJB-2785-MYJW
254-WYD-3220-NAND
884-GLE-2843-FRYA
And I want ...