**2**

votes

**1**answer

17 views

### Hint menu does not appear for Range variable in VBA editor

I have this code:
Dim interface As Worksheet
Dim slope, measure As Range
Set interface = Application.ActiveWorkbook.Worksheets("Main")
Set slope = interface.Range("G1")
Set measure = ...

**0**

votes

**1**answer

36 views

### How to assign a tooltip at a macro button added by customize ribbon in ms excel?

I want to assign a tooltip to a macro button added by me by customizing ribbon in options at file tab in MS Excel.
You can see this snapshot for understanding that where and how I want the tooltip.
...

**0**

votes

**2**answers

38 views

### Excel: check if two cells have specific content and show true/false in another

I have a large datasheet with multiple columns. Long story short, my columns A and B (of text type) are lists of codes. For simplicity's sake let's say column A is days of the week, while column B is ...

**0**

votes

**0**answers

10 views

### How to color code bubble graph by numeric value?

Column E contains my Z values, and I want to use those values to correspond to a color for each of the points on the graph.
How can I do that?
The link to the file is here: ...

**0**

votes

**1**answer

42 views

### VLOOKUP cells that contain a certain text in Excel

The challenge is as follows: I have a column with names extracted from a source. The names come in different ways each time it is extracted. For me to be able to use it, I need the names in a specific ...

**0**

votes

**1**answer

26 views

### COUNTIF and SUM in Excel with different ranges

Is there a more efficient way of making the following function?:
>=COUNTIF(A1,">0")+COUNTIF(C1,">0")+COUNTIF(E1,">0")+COUNTIF(G1,">0")
I want to count if the cell is bigger than 0 ...

**0**

votes

**1**answer

31 views

### Need unique count of text from multiple columns by category

My data looks something like (assume begins in A1):
Category,Label1,Label2
Dogs,blank,doe
Dogs,zoo,blank
Cats,zoo,yup
Cats,doe,hgg
Cats,blank,doe
What the result should look like:
...

**1**

vote

**1**answer

29 views

### How do I stack multiple columns into one?

I am not experienced enough with VBA to accomplish this. How do I modify the below VBA to be able to do the following:
Put stacked columns in a new sheet.
Handle blanks (code below currently does ...

**0**

votes

**1**answer

19 views

### Error on connecting excel to a oracle database

I'm trying to connect to a Oracle Database from a Excel 2010 in a Windows 2010 machine.
I installed 64-bit Oracle Data Access Components but when I try to connect to the database on
Data > From ...

**0**

votes

**0**answers

24 views

### How can I split a spreadsheet into multiple files based on column values while keeping other worksheets and macros in the resulting files?

I've been using the macro below created by mtone for these kind of tasks (splitting spreadsheets) and it works well, but I need to adapt it so that the resulting split files "carry" other sheets of ...

**0**

votes

**0**answers

19 views

### Excel drop down list to change data table

I want to make a drop down list to select sets of data from another sheet, but I'm a bit lost on how to do it
Basically, I have matrices with data that change according to different scenarios, and ...

**0**

votes

**1**answer

30 views

### How to make Excel use relative paths in external workbook links

Within our company we use a number of Excel workbooks that link to other Excel workbooks.
With our service this is fine as everyone accesses a shared network drive and the file paths for all the ...

**-1**

votes

**1**answer

30 views

### Filter an Array into another page of an excel spreadheet

I have an excel table that includes one column that lists Y, N, N/A, or Blank. I need my filter to pull the rows that include the N, or Blank and paste them into another page of the spreadsheet.
I ...

**0**

votes

**1**answer

29 views

### Histogram over Time?

I am trying to track the progress of a similar variable on a number of (several thousand) objects over time. I have several snapshots of data in the following form, but I want to show the progress ...

**2**

votes

**2**answers

81 views

### Excel - return multiple values for each of a list of values

I've been trying to solve this for a good few hours now, but with no result...
My setup:
I've got excel sheets of cosmetics product recipes.
Each recipe contains dozens of ingredients, each given ...

**24**

votes

**3**answers

1k views

### How do I hide the #DIV/0! error while a referenced cell is blank?

In Column C I have Production. In column D I have Goal. In Column E I have variance %. My formula is =(D11-C11)/D11
However, how do you hide the cells down the sheet until you put something in D11 ...

**1**

vote

**1**answer

30 views

### Excel automatically shifts the decimal place to the left

Wow. this is a doozy: Any number I enter is automatically converted to a decimal percentage. For example:
If I enter '3', the number is converted to '.03' in the cell and in the formula bar. If I ...

**1**

vote

**1**answer

26 views

### excel- compare character responses from 2 columns and calculate in new cell

I have 2 columns that have drop down menus with 5 options (character).
orange
apple
banana
broccoli
spinach
I want to program when there are changes from one column to another in a shift
from ...

**0**

votes

**0**answers

13 views

### Pivot Table Calculated Field

I have 2 values in my pivot, RepCount and WonOpps. I want to insert a calculated field to get the average # of WonOpps per RepCount. When I insert a calcualted field it does not sum as expected.
...

**0**

votes

**1**answer

49 views

### Excel Convert Row into Multiple Columns

I have a very long list of data that looks like this:
User1 Item1 Item2 Item3
User2 Item1 Item2 #NUM! (This is a failed formula)
User3 Item1 #NUM! #NUM!
And I want to ...

**1**

vote

**2**answers

23 views

### Apply same formula to large column?

I have 928 numbers in one column in excel. I need to apply the same conversion formula to all these numbers. I've been looking around here and most of the answers to similar questions tell me to use ...

**0**

votes

**0**answers

17 views

### Excel chart referring to non-existant sheet

Apologies in advance if this question is very vague.But I'm hitting my head against the wall on this for the past 2 days and hoping someone can point out the obvious to me.
We have an Excel Report ...

**1**

vote

**0**answers

20 views

### Copy multiline formatted text into a single cell in Excel

My question is similar to Copying a multiline text into a single cell in Excel, except that the text I want to copy contains rich text formatting - bold text, colored text, bullet items, etc...
If I ...

**1**

vote

**0**answers

16 views

### How to add data from multiple rows based on a column with specific identifiers

I have student data and I need to calculate the total number of minutes each student is receiving but there are multiple rows for each student. The data looks like this:
Student Service ...

**3**

votes

**1**answer

30 views

### Sum hours and minutes from separate columns into one grand total

This is the result that a client of mine requires. My own sense is that this approach is not practical. How could we write formulas to achieve the following grand total?
The Hours column has 31 ...

**0**

votes

**1**answer

12 views

### How to stop Excel from reopening file after saving as PDF?

In Excel 2013 (and probably earlier versions) when you save a file as a pdf, Excel says
Acrobat PDFMaker needs to save the file before continuing. Do you want PDFMaker to save the file and ...

**1**

vote

**2**answers

40 views

### VBA Script copied from one Sheet to Another

I have a working VBA script for the worksheet Function Test Procedure(FTP) that will take the values stored in 32 individually named ranges and paste them to a separate worksheet, Results. When I ...

**0**

votes

**0**answers

11 views

### Exporting Tab Delimited Set Character Limits

I need to export a .txt file out of excel in the below format. Where do I find the function to set this format up?
Column Name Start Position Type Length
A 1 Number 8
B ...

**0**

votes

**1**answer

27 views

### What Excel Formula will count the number of responses which match a condition but only once for that person?

I am trying to count survey responses. I would like to be able to answer how many people have ever answered the question with the answer value "1". However, people have answered the survey multiple ...

**2**

votes

**4**answers

82 views

### Native formula to check if range of non-blank cells are equal

I have three cells, any combination of which can be blank. I want to check if all non-blank cells are equal. If cells 1 and 2 have a value and cell 3 is blank, I want the formula to return TRUE if ...

**1**

vote

**0**answers

13 views

### I am trying to turn named ranges into named tables while keeping Auto populating headers

I have a spreadsheet with 32 individual named ranges and the Section Title (B338 for example) is linked to the equivalent value in the Table of Contents (B70 for example). What I would like to do is ...

**0**

votes

**0**answers

12 views

### Excel: Extracting relative file hyperlinks from text?

I'm running on a Mac with Excel 2011. Tried the GetURL macro but apparently it doesn't work on my sheet. The reason I'm doing so is because I'm need to process these into InDesign's data merge, and it ...

**0**

votes

**0**answers

35 views

### Excel VBA code to remove duplicate row however copy past unique values in Column A seperated by commas [closed]

we have about 3k rows where if there is a duplicate in the address column (column C) we will need to:
1) If duplicate address in column C, copy paste all the uniques (ID) values in column A and ...

**0**

votes

**0**answers

38 views

### Excel 2003 - Matching and summarising data across multiple worksheets

I am looking for help regarding my roster calculations.
I have built a roster over 13 worksheets plus a calculation worksheet.
On each sheet column D has a list of names populated from an offset ...

**1**

vote

**2**answers

62 views

### Excel: using 2 cells to collect data from a list

My Example is this:
(workbook name"Rev)
letter weekly bi-weekly monthly
a 100 200 400
b 110 250 500
c 111 300 600
d 112 350 700
e ...

**0**

votes

**1**answer

32 views

### Connecting separated excel 2013 workbook to one

I have Office 2013 installed on Windows 7 x86. I have 4 Excel workbooks that have the same columns, and I'm thinking to connect those 4 Excel files to one "Master", so everyday these 4 Excel files ...

**0**

votes

**0**answers

22 views

### Matching words from two title and calculate %

I was trying to automate an Excel file which has title in both A and B columns and I have to search each word from A within B and calculate the % by using the "no of words matched/total no of words ...

**0**

votes

**2**answers

45 views

### Calculate Total Number Of Days Per Specific Month

Cell A1 shows the Start Date, e.g. 17/09/15
Cell B1 will need to reflect the End Date.End Date need to be based on 3 months of Start Date.
I can't just use 90 days as standard days to add to the ...

**-3**

votes

**0**answers

49 views

### Excel Spreadsheet

I am not sure how to keep a formula going when at the end of my column so that it doesn't keep pasting the same number until data is entered.
My formula is: F9=D10-E10
It is repeated for the 11 rows ...

**0**

votes

**1**answer

34 views

### How do you find the total numbers of times a word has been used?

For example, say I'm trying to total yes/no questions. I want to be able to go down a column and see how many times the answer was yes and how many times the answer was no. I'm also using a drop-down ...

**58**

votes

**2**answers

3k views

### Excel - can I set a cell to equal a certain value, no matter what is typed in it?

This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell ...

**1**

vote

**0**answers

36 views

### How can I ensure that a formula that I have written to calculate the difference between time values applies only to the filtered values?

I have two columns of data:
Member Time
A 09/24/2015 09:48:36
A 09/24/2015 09:47:40
A 09/24/2015 10:11:06
A 09/24/2015 10:08:47
B 09/24/2015 10:28:45
B ...

**0**

votes

**1**answer

33 views

### Excel - Count matching Items, comparing a row with a column

I am trying to compare the similarity of a series of sets of data...
I have a series of columns of 20 values (numbered 1-20), and corresponding rows of 20 values (also numbered 1-20).
The columns ...

**0**

votes

**1**answer

18 views

### Highlight row if ID is found on other sheet

I have one Excel file that contains 2 worksheets.
Worksheet 1 columns:
computernames Username E-Mail
comp1 username mail@mail.de
comp2 username2 mail2@mail.de
Worksheet 2 columns:
...

**1**

vote

**1**answer

26 views

### How can the placement of data points in a graph be adjusted?

As part of an important presentation, I've created the following diagram showing statistical data over 5 periods of time.
The data for each period consists a pair of a bar charts with a ...

**0**

votes

**1**answer

23 views

### Filtering Out data as part of a VBA macro

I'm trying to create a macro that will automate a report. Issue is, the source data brings through data we don't need, and the report itself does lots of calculations based on the table as a whole. ...

**0**

votes

**1**answer

17 views

### Reference a cell with input from another cell

The final objective is to reference the last populated (higher row number) cell from a column (its value).
I found a function that returns the row number of the last populated (higher row number) ...

**-1**

votes

**2**answers

29 views

### extracting a line of data from an excel spreadsheet

I need to extract a line of data from a excel spreadsheet and transfer it to another sheet. I need to search for a series of dashes (- - - - -) and then extract the line of data that is 2 lines below ...

**0**

votes

**1**answer

26 views

### Changing the “file opened by another user” warning timeout

This is an almost opposite to this problem - My workmate keeps an Excel spreadsheet open for a whole day (she has good reasons to do so) without editing. Now if someone else would like to access this ...

**1**

vote

**1**answer

33 views

### Excel 07: Sum Cells of Column B By Date in Column A And Report To Cell C

So basically I have a worksheet like so,
The data is manually entered in, column A is the date, the values are column E. Everything else is arbitrary and filled with x's. Basically what I want to ...