**0**

votes

**0**answers

1 view

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

3 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

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

**0**

votes

**2**answers

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

**0**

votes

**0**answers

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

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

**-1**

votes

**0**answers

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

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

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

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

**1**

vote

**2**answers

29 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

**1**answer

13 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

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

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

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

**1**answer

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

**1**

vote

**0**answers

15 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

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

20 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

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

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

**0**

votes

**2**answers

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

**0**

votes

**2**answers

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

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

**0**

votes

**0**answers

21 views

### Install older version of MS Office without removing newer version first

I'm currently running Microsoft Office 2010, but I temporarily need Excel 2007. I know I can use the Custom setup at the 2007 install process to select just Excel, and based on the Setup Help page:
...

**0**

votes

**0**answers

21 views

### Excel 2007 - Address text verification of student details

I need to verify and collect the users/students whose correct addresses have been provided and saved in DB.
To separate invalid entries from valid ones how should I approach? Simple filtering does ...

**1**

vote

**1**answer

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

**1**

vote

**0**answers

15 views

### Excel/Googlesheet: Anyway to include a comment in a referenced cell?

I have two sheets, the master sheet which has tables of data and a second sheet which references certain cells from the master sheet in order to collate certain data. I wanted to know if theres a way ...

**0**

votes

**1**answer

27 views

### I just cant figure out the formula for this excel sheet

i hope someone can help me with a formula for excel.
On my sheet i have on column A - D's for Dog, and C's for Cat, and O, for other.
I'm trying to figure out the formula for: If 8 or more of the ...

**0**

votes

**0**answers

14 views

### Export file names from print spooler to a text or Excel file

I have to print (make a PDF file) of 15000 jobs and some of these PDF files have the same name. I wanted to create a macro which would remember mouse movements and save these PDF files over the night.
...

**0**

votes

**3**answers

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

**0**

votes

**0**answers

28 views

### Exporting HTML Tables to Excel Sheet not working in IE Browser but works in Firefox and Chrome

I have an HTML page which has multiple tabs and each tab has one table which contain data and I want to download all that data as an Excel spreadsheet with multiple sheets
// call cyntax of this ...

**2**

votes

**1**answer

27 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

34 views

### In Excel, how would I calculate the number of Mondays between dates that excludes a list of holidays?

I'm currently using this formula:
=INT((WEEKDAY(E2-2)-E2+E3)/7).
I know how to use the NETWORKDAYS function, which allows you to a specify a list of holiday dates, but I can't figure out how to ...

**1**

vote

**1**answer

19 views

### Inserting spaces into custom number format has no effect

I've got several phone numbers that Excel displays as (for instance) :
0147200001
I want to display them as :
01 47 20 00 01
Using the Custom Format Number, I've entered ## ## ## ## ##, but the ...

**1**

vote

**1**answer

24 views

### Retrive row number of MIN IF formula

I would like to know the row being used in a MIN(IF()) formula so I can use it to grab a another value in the same row..
I have this formula:
Between the two sheets
A is an Id
B is a Date
C is ...

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

**0**

votes

**1**answer

12 views

### transposing and collating text from different sheets into separate sheet

I am using the following formula to collate text from 3 sheets into a 4th.
=$'sheet 1'.A1&CHAR(10)&$'sheet 2'.A1&CHAR(10)&$'sheet 3'.A1&CHAR(10)
this collates the text with a ...

**3**

votes

**1**answer

27 views

### How to remove a macro button added by customized ribbon in home tab?

I have added a macro button in an excel sheet by customize ribbon and have assigned some VBA code to it to do some particular task. The problem is that when I open any new workbook, Excel shows that ...

**1**

vote

**1**answer

30 views

### Applying text formula only if text is in the cell in Excel

I am using 4 Excel sheets for collating text.
The formula I currently have in sheet 4 is:
=$Sheet1!A1&CHAR(10)&$Sheet2!A1&CHAR(10)&$Sheet3!A1&CHAR(10)
This allows me to write ...

**0**

votes

**1**answer

13 views

### Power Query Connect to Essbase Server

Is there a way to connect to an Oracle Essbase Server using Power Query for Excel to extract data?

**-1**

votes

**1**answer

23 views

### Auto-populate calendar with an “X” in Excel

I have have a set of due dates for preventative maintenance on equipment and I want a calendar to auto-populate with an "X" under the correct month it is due.
For example I have machine 1 due 1/1. ...

**2**

votes

**0**answers

23 views

### remove embedded xlsx files from docx

I have a very big docx document(300mb). It is full of pictures, tables, spreadsheets, etc.
Then I look at the document structure I see that under document.docx/word/embeddings/* are all excel sheets ...

**0**

votes

**1**answer

18 views

### How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted.
I am using conditional formatting's "use a formula ...

**0**

votes

**2**answers

22 views

### If multiple cells are with the same text, return this text(value) to another cell

I need your help with this:
If A1:E1 is "Red", return "Red" to C3;
If A1:E1 is "Blue", return "Blue" to C3;
BUT
If A1:E1 are not the same, return False or "X" to C3
What function to use ...

**0**

votes

**1**answer

26 views

### Prefix/Suffix Data Validation List

I'm finding it really difficult to understand how to prefix or suffix a set of words based on a what I have chosen in a 'Data Validation List'.
CLICK HERE TO SEE/DOWNLOAD AN EXAMPLE SPREADSHEET
I ...

**3**

votes

**0**answers

21 views

### How to get Daylight Saving into a Date Arithmetic Formula?

I am using Excel to calculate the times of a series of events that occur a certain number of hours offset from a starting time. I want the results to show in my local time.
My time zone will go off ...

**3**

votes

**1**answer

82 views

### excel ISTEXT returns True where a formula contains the answer “”

I have a formula that returns the value "" blank.(correctly) However when testing for ISTEXT, I get the result "True" I understand "" is seen as text, however Im looking to test for actual words that ...

**2**

votes

**1**answer

25 views

### Highlight rows that don't match other sheet

I'm not sure if this is possible, but I have two spreadsheets that I need to compare in a few different ways.
Here is the scenario:
**Sheet 1**
Column O=Claim Number;
Column P=Reserve Indemnity; ...

**3**

votes

**1**answer

27 views

### Excel Large Function with Duplicates

I'm trying to apply a LARGE function to get the 5 largest values from a column ignoring duplicates. I did some searching around and found some proposed solutions but they don't seem to work for me. In ...