**0**

votes

**2**answers

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

**-4**

votes

**0**answers

12 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%

**7**

votes

**3**answers

2k views

### Microsoft Excel Mac, keyboard shortcut to edit in cell

In Microsoft Excel for Mac 2011 (14.0.0) how can I modify the enter/return key to edit in cell instead of moving the selection down? I know that in Preferences > Edit you can uncheck the box that says ...

**0**

votes

**2**answers

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

**0**

votes

**0**answers

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

**1**

vote

**2**answers

8k views

### How to disable Excel number autoformat

This problem is simple to correct but is very very annoying
what I'm doing is to type a hour range, eg. (0-1),(1-2),(2-3) so on
per cell row
DATE --- HOUR
1/1/2013 0-1 1/1/2013 1-2 ...

**1**

vote

**2**answers

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

**0**

votes

**3**answers

27 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

**1**answer

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

**0**

votes

**0**answers

18 views

### After ignoring DDE function, cannot open separate instances of Excel [duplicate]

I looked up a method of opening multiple files in separate instances of MS Excel, as I have both a landscape oriented and portrait oriented monitor and need to use both. The common method of doing so ...

**1**

vote

**3**answers

23 views

### Using OR condition in SUMPRODUCT

I have three columns of data - a sum column (A) and then the two columns that form the sum (B and C). Sometimes, just one of the B and C columns is filled in; occasionally the B and C columns are both ...

**-1**

votes

**0**answers

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

**0**

votes

**5**answers

27 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

**2**answers

25 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

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

**2**

votes

**1**answer

11 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

19 views

### Expand Excel ComboBox on click

How can I set up my combo boxes on the form i am building to open automatically when clicked on the field portion not just the arrow? I have been searching for a while and I can't seem to find any ...

**3**

votes

**1**answer

67 views

### How to get rid of macro leftovers in Excel?

Old macro workbook from Microsoft samples gallery left items on the ADD-INS ribbon tab, highlighted by yellow:
These cannot be deleted or at least I don't know where to find them – see Customize ...

**1**

vote

**1**answer

19 views

### How do compare similar contents AND return a cell's contents?

In Excel, how do I tell it to compare two tables with SIMILAR primary keys, find a relatively close match, and then return the info from one of the cells (more than just a yes/no, 1/0, true/false.
...

**3**

votes

**1**answer

61 views

### show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown.
Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...

**2**

votes

**3**answers

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

**0**

votes

**0**answers

17 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

**1**answer

2k views

### Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule

**0**

votes

**2**answers

26 views

### How to write the cells in rows one under the other in columns?

I have a list of name, company, phone number, address and e-mail. But each name who works at the same company is in the same cell. Of course, the other informations of those names like phone number, ...

**0**

votes

**1**answer

28 views

### Web scraping / crawling a particular website

I'm trying to scrape 1265 html files at once to get name and descriptions of items I have on a website.
I have permission from the wholesaler to copy there data but I don't want to spend days just ...

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

22 views

### With PowerPivots, find items that appear *only* in one category

With PowerPivot, how do I find items only in one category? Here's an example:
item category number
obera f6 7
artois f7 2
obera f7 3
ella f6 9
If ...

**0**

votes

**0**answers

14 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

**0**answers

30 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

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

**1**

vote

**1**answer

591 views

### “crosshair” in MS excel

Sometimes it is hard to see which cells are in the row/column of the selected cell in excel. Is there an option which would enable "crosshair", which would bold not only selected cells, but also cells ...

**2**

votes

**1**answer

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

**5**

votes

**6**answers

8k views

### Changing bounds of excel file embedded in powerpoint

When I embed an excel files into powerpoint, I'm having two issues.
On some of the spreadsheets, empty columns are displayed on the right hand side of the powerpoint slide
On other spreadsheets that ...

**0**

votes

**1**answer

3k views

### Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...

**23**

votes

**14**answers

57k views

### Format a number with optional decimal places in Excel

I have numbers in cells in Excel. I want the numbers formatted so that if they have decimal places they show to a maximum of two, and if they have no decimal places it doesn't show any.
For example.
...

**0**

votes

**1**answer

2k views

### Excel - Counta from a certain cell until a blank cell

I'm trying to create a dynamic formula which counts all the rows from cell D3 downwards until a blank cell is reached. I want to be able to add new data everyday and have the range automatically ...

**3**

votes

**2**answers

3k views

### Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values
The calculated values never change directly, but only as a result of ...

**1**

vote

**1**answer

50 views

### Avoiding Long Nested IFs in Excel Function

I have a formula that relies on two different inputs: the first is an integer value between 0 and 5, and the second is the rounded sum of values in an array. I would like to have users input values ...

**0**

votes

**2**answers

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

**0**

votes

**2**answers

2k views

### Comparing two columns in different Excel spreadsheets

I have two Excel spreadsheets. In the first spreadsheet I have two columns. Column A has 240 Accounts entries and Column B has Values for each account entry. Once again Spreadsheet 2 has its data in ...

**0**

votes

**0**answers

17 views

### Excel or Google Sheets - How to update smoe columns

I'm working with some back-end software that generates a work queue for our purchasing department. The work queue is a spreadsheet that looks like:
...

**0**

votes

**1**answer

17 views

### Excel help to lock formulas from adjust on cell insert

I have a excel workbook where there is a hidden sheet that basically pulls data from other sheets in the same workbook just using the = formula.
The problem I am having is if I add a column or cells ...

**0**

votes

**1**answer

32 views

### How to create a relational data table in Excel

If I have the following Table1 in Excel
Name Age Sex
Pablo 28 Male
Victor 32 Male
Juan 33 Male
Pedro 40 Male
Jacinta 24 Female
Laura 39 Female
And Table2
Sex Color
Male ...

**0**

votes

**2**answers

22 views

### Weird File Attributes in Excel Save Dialog

I vertically re-sized my excel Save As dialog today and found a bunch of strange file attributes that I've never seen in the dialog before. They only appear when the dialog is resized small enough ...

**0**

votes

**1**answer

14 views

### Autofill in Excel skipping rows

I am trying to accomplish something with excel but I cannot seem to make it work.
In a worksheet I have a simple table with rows and columns. Every row is a new entry.
I then have a template in ...

**-2**

votes

**0**answers

16 views

### How do I remove icons from ribbon and menus office 2013?

In (Windows 8.1 Office 2013) Excel 2013 the menu caps don't bug me, but how can I have text only and remove the icons? I want text and remove/hide the icons.
Is there a Text Only option?

**0**

votes

**2**answers

28 views

### Using IF to Place A Value in A Different Cell

Is it possible to do something like the following?
=IF(A1=0, Place "Yes" in B2, Do nothing)
I was considering using =OFFSET somehow, but I'm really not sure how I would implement it here.

**0**

votes

**0**answers

20 views

### Changing what browser Excel hyperlinks open in

Right now all of my hyperlinks in excel open with IE.
I'm hyper-linking Google sites though, and I would prefer that they open in Chrome.
How do I change what browser hyperlinks open in?
There's no ...

**2**

votes

**1**answer

18 views

### Navigating an excel document using excel links

I'd like to be able to click on some text in a cell that automatically moves the insertion point to a specified cell or row.
So ideally I could have a cell (or some text in a cell) say: ["see row ...

**-3**

votes

**3**answers

23 views

### Formula that references two cells [on hold]

I have a chart of nights and people and the rate varies as nights and people. I want a formula that picks up the rate based on te nights and people. See table below. So I want a formula that ...