Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

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