**1**

vote

**1**answer

34 views

### open html document with excel save as xls with batch file

I would like to run a batch file that will open an html file with excel and subsequently save the opened html file as a xls or xlsx document. Ideally, the batch would then be scheduled to run ...

**0**

votes

**0**answers

2 views

### Excel formula for a “running %” of a column

im trying to figure a formula for a running percentage of entries in a column.
For example, in column A, i have "r" for returns, and "n" for non returns, and "c" for canceled, but "c" is classed as a ...

**0**

votes

**0**answers

2 views

### Excel file locks up while deleting rows in bulk, but only when Shared Workbook is checked

I have a client that has a worksheet that has a few formulas in it, across 4 workbooks. When the file is not shared, they can delete multiple rows, 100+, without issue. Once the Shared Workbook ...

**0**

votes

**1**answer

22 views

### Creating a Range of Time

I would like to group various ranges of time into the following groups
MOrning. (6:30am - 10:30am)
Mid (10:31am - 1:30pm)
Afternoon (1:31pm - 5:30pm)
I have my data set-up as follows
Time ...

**4**

votes

**2**answers

15k views

### Split Excel table over multiple PowerPoint slides

I have a table in Excel which is too long for one PowerPoint slide. So I would like to split it over 2 or 3 slides, but have the header on each of the slides. What is the easiest way to accomplish ...

**8**

votes

**9**answers

69k views

### Autonumbering a column in Excel

In my first column, I want to autonumber it from 1, 2, 3, 4, ..., x. How do I do that?

**0**

votes

**0**answers

7 views

### Excel Filter Messed up

I recently moved my excel workbooks to a new server. The excel sheets had external connection to my SQL Database from which Pivot tables were being created.
Everything was working until the ...

**0**

votes

**0**answers

16 views

### Excel formula needs help to create table

Trying to understand how to create a table that identifies what specific dates relate to the row and column it is in.
IE. if I have columns A, B, and C. and rows 1, 2, 3 with dates applied within ...

**0**

votes

**0**answers

4 views

### Create a hyperlink to a cell in a “Table of Contents” sheet quickly

I have an excel document with a vast amount of sheets (upwards of 100). To make navigation easier, I made the first sheet a "Table of Contents" where I listed all of the other sheet names in a column ...

**0**

votes

**0**answers

7 views

### The data(Job #) in one column is only put to another spread sheet, IF another column contains data

J/C # A. B. C. D. E. F. G. H. TOTAL Estimated Time
97647 45 45 90 30 120 330
97651 15 30 45
99999 60 120 75 360 615
11111 ...

**4**

votes

**3**answers

12k views

### How can I use multiple pivot tables on the same sheet without an overlap error?

I have multiple pivot tables on the same sheet. Since each and every one of them have a dependent size due to the data, it causes the error:
A pivot table can not overlap another pivot table.
Is ...

**1**

vote

**2**answers

30 views

### Count coloured cells without a macro?

Is it possible to count cells by their colour (not by their cell value as they are blank) in Excel 2010/2013 without using VBA, as my files needs to be saved as .XLSX?

**0**

votes

**2**answers

16 views

### Add dropdown list to cell and include it's intial value

I want to add a dropdown list to cell A1 (which has a value of 2)
The dropdown list has a number of items ("cats", "dogs", "cheese monkeys")
This is easy.
However, I want to included the initial ...

**-1**

votes

**0**answers

6 views

### Match the value with master & get adjacent value

I was searching through the threads for easy way out for vlookup VBA kind of.
I have multiple Excel files where they need to be updated with look up on master file.
Master file has codes on Column ...

**-1**

votes

**0**answers

8 views

### Match information to a range and add corresponding data?

I've got a range (A1:b600) that contains names (a) and emails (b), and I'd like to check if the contents of another cell (D1) matches one of the names in my range. If it does I want to look for the ...

**0**

votes

**0**answers

9 views

### How do I stop column formulas from automatically calculating in an Excel Table?

When using a column formula for a table in a workbook with calculation set to manual, when tinkering with formulas, Excel calculates them if the column formula changes.
The automatic propagation of ...

**0**

votes

**0**answers

10 views

### microsoft excel 2007 with locked format

I have a 2007 excel sheet with a column that I can't change from text to number. I can change color, font, size etc. but can't get out of text to number.

**0**

votes

**1**answer

16 views

### Excel chart showing wrong data

so I have an excel chart setup with 2 data series that shows the beginning of a bar and the end of the bar. The beginning of the bar is right. 0.348800885
but the end of the bar is completely wrong. ...

**0**

votes

**0**answers

7 views

### MS Excel Plotting frequency (not histogram)

I'm looking for a way to plot the occurrence of a PRJ # against a specific dept.
Data:
(PRJ A Dept 1)
(PRJ A Dept 2)
(PRJ B Dept 1)
(PRJ C Dept 1)
(PRJ C Dept 3)
To get plot like where ...

**-1**

votes

**0**answers

10 views

### How to search a string with color code in many workbooks and copy row if true

How to search a string in many workbooks and copy row if true
Under this link I found a great tool to copy a row if true from a searies of workbooks and copy them into a new workbook.
My problem ...

**0**

votes

**4**answers

432 views

### Multiple conditions in if statement on non-contiguous cells in Excel

I would like to perform an if statement with conditions on the values of multiple non-contiguous cells, something like
...

**0**

votes

**0**answers

17 views

### Vba Script to replace html tag with formatting

I am looking for a vba script, which replaces a html <strong>.
Example <strong>Any Text here shall be bold</strong>
The result shall be Any Text here shall be bold.
It shall macth ...

**0**

votes

**0**answers

11 views

### Count non-filled rows from same column in Excel 2010

So I've got a column with a Title (which I don't want to count) and hundreds of filled rows. In the second row I want Excel to calculate the sum of the filled rows. Example:
..A..
Title
Sum
...

**2**

votes

**2**answers

10k views

### How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...

**2**

votes

**1**answer

3k views

### How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...

**0**

votes

**1**answer

17 views

### If, Then do cell formula assitance

So I am trying to get a cell to check the % of another cell. If the cell is between a % range it will display a specific number. But I am getting the #REF! error. Any help from the gurus..maybe even ...

**0**

votes

**0**answers

21 views

### If 2 checkboxes true then add cell value - Excel Formula

I'm trying to add a list of prices depending on if 2 check boxes are ticked.
What I want to do is say if the paid checkbox is ticked and the just eat tickbox is ticked then add get the number in the ...

**0**

votes

**3**answers

53 views

### Parsing non-standard date/time data in an Excel spreadsheet cell

I'm looking for some advice on this one more than anything. I have a spreadsheet that contains store hours for each location at work. The formats range from this:
"Mon-Sat 9:30am-9:00pm
Sunday ...

**9**

votes

**5**answers

9k views

### Is there any way to properly display negative time spans in Excel?

Is there any way to make Excel show a negative time span? If I subtract two time values (say, when subtracting the actual amount of time spent on something from the amount of time planned for it) and ...

**1**

vote

**0**answers

19 views

### Change every character in a cell with another in Excel

I have a large list of phrases that I would like to make more disguised. I want to substitute each letter/character with another character and be able to decode this with another formula so I am able ...

**2**

votes

**3**answers

8k views

### Right Click on Column or Row does not show Context Menu

I have the following issue: When right clicking in a row or column in Excel 2010 no menu is appearing. In Excel 2003 right clicking in a row lets you insert/delete rows.
Do you know if this ...

**0**

votes

**1**answer

229 views

### Turn one row into multiple rows in Excel

I have multiple items that are available in multiple distribution centers (i.e., a many-to-many relationship). There is currently one row per item, with one column for each distribution center. A cell ...

**0**

votes

**1**answer

21 views

### Multiplying the remaining balance of an amount

I want to multiply the total of an array of cells, but only want to multiply the remaining number of the overage amount.
For example:
Goal amount: 10,000
Sum: 15,000
Multiply by: 5,000

**1**

vote

**1**answer

2k views

### Match unsorted Excel data from two columns (products) to assign value to a third column (prices)

I have four columns:
Column A has a part number, column B has a new price
Column C has a part number, column D has an old price.
Column A and C are not identical nor do they have the same number of ...

**15**

votes

**2**answers

36k views

### How can I prevent the privacy warning in Excel?

I have Excel 2007. When I want to save a spreadsheet, I often see this message:
I've seen this with macro spreadsheets (using the .xlsm extension) and with non-macro sheets (using the .xlsx ...

**2**

votes

**1**answer

36 views

### Excel 2013 Search for substring in column using lookup column and return accompanying value

I have 2 sheets:
sheet1 contains 2 columns as follows:
columnA columnB
AB Texas
BC California
DE Virginia
sheet2 contains 1 columns as follows:
columnA
AB_documentOne.pdf ...

**0**

votes

**1**answer

27 views

### How can I show table on next sheet based on current date?

Lets suppose I have multiple tables on a sheet. Every table represents a month of a year. I want to show one of the tables, the table for current month, on the next sheet.
How can I achieve this?

**6**

votes

**5**answers

3k views

### How to combine data from two rows, when certain criterion is met

click to enlarge
I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column ...

**1**

vote

**1**answer

20 views

### Excel Chart with data points not in chronological order

Say you have total monthly spend for 36 months and you want to display it in a bar graph to show all the spend for the 3 Januarys, then all the spend for the 3 Februarys, etc. When I sort my data ...

**0**

votes

**2**answers

26 views

### How can I select and output the first and last row of a worksheet or a filtered list?

I am new to VBA and I have no clue where to start with this.
I have two columns of data:
Team Member Time
A 1
A 2
A 3
A 4
I am only interested in ...

**12**

votes

**1**answer

25k views

### Limit an Excel cell to one of two possible values

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell.
How could I do this?

**1**

vote

**1**answer

23 views

### Look up a name from row in a timetable and output the column header in Excel

I'm making a timetable for interviews which comprise of 6 stations plus a rest.
(FYI in the timetable time is progressing downwards)
Sample of timetable with names omitted:
I'd like to create ...

**0**

votes

**2**answers

30 views

### Check if any names are present in two columns [duplicate]

I have two lists on names, first list of names just under 140k (Column A), second under just over 7k (Column B).
I want to see if there any matches from column A & B.
My Excel skills are basic ...

**2**

votes

**1**answer

28 views

### Increase a cell's value based on other cell's value

What I am looking for is an "IF" formula that can solve my problem:
I have a single sheet with 2 columns and an unlimited number of rows.
On the first column (Column#1), I have a drop-down with ...

**3**

votes

**1**answer

590 views

**2**

votes

**9**answers

34k views

### Can't insert cells in Excel 2010 - “operation not allowed” error message

I was working on a spreadsheet in Excel 2010, and all of a sudden when I attempted to insert a new row of cells, I saw that the insert and delete options were grayed out.
I attempted to copy a ...

**1**

vote

**1**answer

8k views

### Count the quantity of unique combinations of multiple columns in Excel

I have two columns in a spreadsheet, and I need to write a formula to determine how many times each combination shows up. Example:
A 1
A 1
A 2
A 2
A 2
B 1
B 1
B 2
Should result in:
A 1 2
...

**0**

votes

**2**answers

31 views

### How to display only data that meets certain criteria in Excel

I have a list of names, with one column further on with numerical data within, for argument's sake like shown below:
Dave 1
Bob 2
Frank 1
Dennis 3
I would like to have another table on a ...

**1**

vote

**2**answers

7k views

### How to compare data in 2 columns in Excel and then in one cell, determine if there are similar data in both columns

I have 2 columns in Excel: the first contains a list of employee names who perform function A, and the second contains a list of employee names who perform function B.
What I want is to identify, in ...

**0**

votes

**1**answer

26 views

### Need VBA Code to Combine Rows if rows A-F are the same

I need a VBA code that will combine rows if, for instance, Rows 4 & 5 have the same values in columns A:F. However, then I need for Column G to be split. G4 stays as G4 but then G5 becomes H5. ...