**0**

votes

**0**answers

8 views

### Find the product of a sum in excel?

I want to know how to calculate the product of the sum of a set of cells while being nested in a IF function. I have already tried =IF(=sum(B2:E2)>10000, =sum(B2:E2)*0.05, =sum(B2:E2)*0.02) but it ...

**0**

votes

**0**answers

5 views

### Excel, Worddoc and VBA guidance

Is it possible, using VBA and Excel, to have a button that retrieves a Worddoc Template and populate certain fields in the document with data from the excel document?
Long story, I am working on ...

**0**

votes

**0**answers

5 views

### Ledger Balance Sheet Assitance

Need your help again....I am building a ledger in Excel. Tab 1 has a Form to input data into cells in tab 2. Tab 3 is Reference Information that the form pulls data from for drop down menus. On tab ...

**0**

votes

**1**answer

10 views

### Excel 2013 normal curve area not lining up

I have a small excel sheet that I'm using to learn more about the value of normal random variables. I created a graph with a normal curve (-30 to 30) with the appropriate formulas.
Column A: General ...

**0**

votes

**1**answer

6 views

### How to find table_array referenced in Excel formula in cell

I was given an Excel spreadsheet that I have to convert into a SQL view.
In the cell formulas VLOOKUP is used and for almost all of the table_arrays I can find where the table_array is. But for one ...

**0**

votes

**0**answers

5 views

### How to change Microsoft Office default save location from OneDrive

I have Office 2016 for Mac, and when I go to Prefs for each app, I can't find any option to change the default location for Open/Save operations to local from OneDrive. I really don't want to use ...

**2**

votes

**1**answer

17 views

### INDEX and MATCH in Excel providing results 1 row lower than desired

In using INDEX and MATCH to perform a multiple-condition VLOOKUP, I'm currently getting results for the desired column using the below formula, but the result is consistently 1 row lower than desired.
...

**-1**

votes

**0**answers

16 views

### Macro to Copy/Paste rows into new worksheet depending on criteria

I have a list of names and data with the following headings:
Year Forename Surname DOB Gender UPN
The data variable is in that there are 7 years (Year 1-Year 7) in column 1 (A)
I would like ...

**1**

vote

**0**answers

9 views

### How to make groups/hidden rows behave like filtered lists so changes only affect visible cells, to prevent accidental data loss?

When rows/columns are hidden in a group or by manually hiding rows/columns, and cells are highlighted like so
If formatting is applied, or something is deleted, it applies to the hidden sections ...

**0**

votes

**1**answer

34 views

### Why is Excel (sometimes) changing casing of a text in an imported file?

So this is a bizarre problem some users of ours are seeing, that I've been able to confirm, and that makes absolutely no sense to me.
Basically, I work on an application that will export files in CSV ...

**0**

votes

**0**answers

8 views

### Excel's ActiveX controls' fonts explode when accessed via RDP - why?

Amongst other problems with using ActiveX controls in Excel, accessing the worksheet on a PC via RDP seems to cause the ActiveX fonts to explode :
This is on Excel 2010 Standard running on ...

**0**

votes

**0**answers

12 views

### Excel toggles - possible to activate from anywhere in a workbook?

I have a dashboard tab in my financial model that contains toggles for different scenarios (i.e. growth rates, COGS, ASP, etc.) The toggles are setup as drop-down lists for base, upside and downside ...

**0**

votes

**0**answers

12 views

### How can I automatically upload xlsx to google sheets?

I am looking to automate uploading an Excel document (xlsx) automatically both when computer starts up and when it shuts down, to Google Sheets, so that it's updated on there if something was done ...

**-1**

votes

**0**answers

22 views

### Microsoft Excel Query

Suppose there are five columns:
A,B,C,D and E
in which:
A and C contain a combination of letters and numbers to represent a specific item and
B and D contain numbers to indicate the equivalent ...

**1**

vote

**1**answer

19 views

### Determining whether each row has the highest value within the group specified in another column

We want to find the row with highest priority.
We have about 30,000 rows of data in a Table like this:
Item Group Priority Highest(formula wanted)
A TRUE
B P ...

**0**

votes

**2**answers

18 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

**0**answers

8 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

**1**answer

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

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

20 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

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

**0**

votes

**2**answers

24 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

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.

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

7 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

10 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

8 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

13 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

34 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

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

12 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

21 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

23 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

21 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

**1**answer

25 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

37 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

23 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

21 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

29 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

28 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

32 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

22 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

23 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

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

**2**

votes

**0**answers

23 views

### Is there any way to include a comment in a referenced cell in Excel?

I have two Excel spreadsheets:
The master sheet which has tables of data
A second sheet which references certain cells from the master sheet in order to collate certain data.
I wanted to know if ...

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

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