**0**

votes

**1**answer

34 views

### Excel, one cell takes a value from another but want to subtract from another cell

Currently F18 is =L27
I want it to equal that cells total (that cell adds tons of stuff up I'm working from something that have at work but it's old and thou I could just manually edit it with actual ...

**3**

votes

**1**answer

52 views

### How to calculate an average value based on duplicate groups?

I have a table which contains data recorded at various times. The data should have been recorded at 5-minute intervals but this wasn't always the case.
Therefore, to try and clean this up:
I set ...

**0**

votes

**1**answer

44 views

### matching columns with nearly similar values in Excel

I have 2 columns A and B with persons names (more than 100 values per column):
Column A Column B Column C
1 John Brett Rise Matthew ...

**-1**

votes

**1**answer

32 views

### Add timestamp excel with formula

In an Excel spreadsheet, I want to add a formula that when I type a text in a cell , it adds the current time after the text I type ( in the same cell ).

**0**

votes

**0**answers

13 views

### hiding rows in a closed workbook

I have a couple of thousand of files in which I need to hide specific rows without opening them. (I have got 2400 files).
Is that possible?
I've been looking for a solution on internet for a couple ...

**0**

votes

**1**answer

59 views

### How to format entire row when any cell of the row contains any value?

I want when there is any value (whether any alphabetic or numeric value) in any of the cell into the row from a1 to p1 then the entire row (from a1 to p1) should be formatted.
For example there is ...

**0**

votes

**1**answer

51 views

### Change a cell number in formula from another cell [duplicate]

Basically I have this formula:
=(MIKE!$B8)
and I have a bunch of cells withs Numbers like so:
Cell | Cell Number Change
C1 | 10
C2 | 16
C3 | 29
C4 | 40
C5 | 61
What I want to do is to be able ...

**1**

vote

**1**answer

26 views

### Excel: Find rows that are duplicates except for two columns

I am using a dataset that has 6 columns. I would like to find any rows that have an exact match in any other row, aside from two columns. So If my data were like the following:
WT 40 SH ...

**0**

votes

**2**answers

37 views

### How to add alphanumerics in excel

I am maintaining stock of flavors in a row:
Cell B1 : 5vanilla,5cola,5mango
Similarly
Cell C1 : 3vanilla,3cola,3mango
Is there a sum formula with which I can get
auto sum in Cell F1 as 8vanilla,...

**2**

votes

**2**answers

153 views

### Linking a chart series' name to a range through VBA

I would like to link the chart series' name to a range on my worksheet, but not the whole string in that range. For example, instead of linking the name to a cell that contains "201601", I want the ...

**1**

vote

**1**answer

176 views

### Create Bat File With Excel Data with VBA

I took some research from google
Sub ExportRangetoFile()
Dim wb As Workbook
Dim saveFile As String
Dim WorkRng As Range
Set WorkRng = Sheets("Match").Range("K:K")
Application....

**0**

votes

**0**answers

39 views

### Excel: value between two times [duplicate]

I have an Excel sheet which gives me the number of workers working on a given hour. However I cannot seem to get it to work for overnight shifts.
I know it will work if I add a date to the time but ...

**0**

votes

**1**answer

140 views

### How to drag multiple instances of a range at the same time in excel

Edit: This question is completely revised to incorporate screenshots as suggested by the commenters.
I track student grades in Excel using a spreadsheet something like this
I often find myself ...

**1**

vote

**0**answers

8 views

### Excel work tabs sharing data

I'm working with Excel; in tab 1 (Data Sheet) I have lines of data, each line represents a part with all its history and associated cost. the 2nd tab pulls data from tab 1 based on particular columns ...

**0**

votes

**0**answers

57 views

### EXCEL table linked to WORD overwrites WORD table properties

I have 30 EXCEL tables - Linked with Formatting - into 8 WORD documents.
I would like the Table Properties ROW in the WORD document to Repeat Header and Not allow row to break across pages.
This is ...

**0**

votes

**2**answers

237 views

### What is largest value (number) that I can store in an Excel VBA variable?

I am using Microsoft Office Excel 2007.
Suppose I have the number 12500000000000.
Dim value1 as long
value1 = CLng(copyrng2.value)
'where copyrng2 is a range (cell) variable containing ...

**0**

votes

**1**answer

62 views

### Excel, How to get last value in second column for a name selected in first column?

I have an excel sheet in below state:
Column1 Column2
A 10
X 20
C 30
D -45
A 50
B 61
C -08
D -...

**-1**

votes

**1**answer

52 views

### In Microsoft Excel, need to pull information from on sheet to populate cells in other sheets, based of a id number search

I have one sheet in excel that I would like to enter an ID number "707442" and have excel go to another sheet and search the column that has the ID numbers. When it finds the ID number I would like ...

**0**

votes

**1**answer

151 views

### Loop down column until blank cell

The following formula works well if I define each cell (over and over), but I need a loop that will run down column A & B for hundreds of rows.
I have tried and just cannot seem to be able to ...

**3**

votes

**1**answer

37 views

### Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget.
Cells look like this
A B C D
DATE WEEKLY BILLS TOTAL
2015 $50 $1,956.73
Jan ...

**2**

votes

**1**answer

85 views

### VBA EXcel - I am getting an error (400) if using error trap getting no object/application defined error

My excel sheet has these data, 7 columns
sl.no | bed | 2| 4| 3|4|3|
some times column no 7 is empty, and then only I'm getting error
And my code
Sub sup_cal_area_sft()
Dim lru, plru As Long
Dim ...

**0**

votes

**1**answer

225 views

### Checkout/in Excel Workbooks from SharePoint with VBA

I have found several articles and past questions in SO that help with this, but I have added a twist. I found a way to map a network drive on my PC to the SharePoint folders. If I open a workbook that ...

**0**

votes

**2**answers

38 views

### How to test Excel workbook compatibility?

I have prepared an excel workbook in Excel 2013 (32-bit) Windows.
It is a kind of report template, where others input the data, selects from in-cell dropdowns etc. The workbook does not contain any ...

**0**

votes

**1**answer

67 views

### How to synchronize text in Excel in multiple sheets

I have Excel file with four sheets.
How to make duplication using Excel built-in function using specific parameters?
Example:
Sheet 1 - Total:
A B C
1 Iveco ...

**0**

votes

**2**answers

36 views

### Is it possible to have an =if equation involving text and math?

This is what I'm shooting for:
=IF(LEFT(Q3,2)="By","see authorizing lab"&"-"&SUM(Q3-L3))
I'm trying to say IF Q3 says "By" the return "see authorizing lab" if not then subtract L3 from Q3 (...

**3**

votes

**1**answer

449 views

### Omit weekends and/or holidays in days to complete formula

Is there a way to not include weekends and or holidays in an Excel formula involving dates? Example:
=Q2-Q1
(a date in q2 minus a date in q1 = so many days) Excluding weekends & holidays?

**2**

votes

**2**answers

65 views

### Creating an Invoice in Excel

I have only dabbled with Excel and not much in quite some time now.
I have an Excel Invoice laid out so Column A is a name of a job and each row in column A can be a different job.
Now column B ...

**2**

votes

**0**answers

87 views

### How to interpolate a graph with multiple series in Excel?

I have a X-Y scatter plot in Excel 2007 with multiple lines on same plot like a series for 2%, and other series for 3% and 5%.
How can I interpolate such data? For example, if I want to know a value ...

**0**

votes

**1**answer

13 views

### Microsoft Excel 2007 function required to find specific information in a worksheet

I have an Excel worksheet in which I have 15 columns. In column 13 I have 3 names and blank spaces spasmodically placed, in the 3rd column i have dates running from latest to earliest down the page. I ...

**0**

votes

**1**answer

15 views

### Display empty cell if referencing empty cell (formula)

I'm working on an excel spreadsheet, and im aiming for a clean interface with almost all cells filled with specific formula.
Ex formula on column V : =IF(G1=" LNN ","PENDING", "N/A")
What's ...

**3**

votes

**2**answers

33 views

### Drop Down List and one formula

I am trying to get an average depending on two drop down lists.
But i would like to get an average even when the second drop down has no input in it.
The formula I use is a simple: AVERAGEIFS with: ...

**0**

votes

**1**answer

42 views

### Is there a formula to look for partial text in a cell?

This is what I'm using right now in the formula:
=IF(E6="Mix Design Gr S","By Mix Design","")&IF(E6="R-Value","By Soils","")&IF(E6="PS Package","By Soils","")
Is there a way to only look for ...

**0**

votes

**1**answer

68 views

### How to default Macros to run from This Workbook, NOT All Open Workbooks?

We have a macro enabled workbook (ver. 2010) that many people use. A few of these people have macros in their Personal.xlsb workbook. We have a situation where the macro in the shared workbook is ...

**1**

vote

**1**answer

57 views

### Finding unused names in Excel [duplicate]

I was curious if anyone would be able to help me or give me some direction. I have a worksheet with the following sort of data.
+---+----------------+--------+-----+----------------+
| | A ...

**0**

votes

**1**answer

52 views

### Trying to create sequential hyperlink to worksheets in the same book

I have a summary page, and 50+ other pages, numbered 1-50. what I'm trying to do is create a hyperlink that will go to the correct sheet when clicked. I've got it working for one, but when I drag it ...

**0**

votes

**2**answers

93 views

### EXCEL VBA works with F5 - but will not run automatically when cell values are changed

The VBA formula works perfect with F5
Column E cells E3:E5 have Functions that calculate to a dollar amount or $0.00.
This is the formula pulling from =SUM('MEDENT Proposal - Creator'!B15*15)
...

**0**

votes

**1**answer

87 views

### EXCEL automatic Tab Color change not updating

I have a formula for Automatic Tab color change that works when I manually change the cell, but it does not work when the cell is changed by a function updating it from another sheet: =SUM('MEDENT ...

**0**

votes

**1**answer

20 views

### Using Excel 2007, how to autofill cells from one sheet to another

I want to put the Employee's Number in this sheet.
...so the Employee's information can show based on this sheet.
(Click image to enlarge)

**0**

votes

**1**answer

28 views

### Excel use mouse to jump to beginning of range (opposite of double-clicking cell border to jump to end)

In Excel when you double-click the border between cells you jump to the end of the range (equivalent to Ctrl+DownArrow or Ctrl+RightArrow). Is there a way to click somehow to jump to the beginning of ...

**0**

votes

**0**answers

38 views

### How can I speed up functions in Excel? How I can make my sheet/worksheet faster? How do I know how long took create something in Excel?

I have long functions in Excel that use other sheets in my worksheet for example :
{=INDEX(
Sheet1,
MATCH(
$A2 &
MAX(
IF(
( 1 * ( $A2 =
...

**0**

votes

**1**answer

86 views

### Filter list with condition and return results as delimited list in a single cell

I need to return all values in column A that match a set criterion in Column B.
The returned values need to be in a single cell in a single formula.
In the attached Sample image, I need a single ...

**0**

votes

**0**answers

18 views

### Need Excel sorting formula matching 2 sets of data

I can't figure this out. I need to sort and match 1 data set of 3 or more columns (sample on the left) with another data set of 2 columns on the right. I need to match the right JVA column rows (...

**1**

vote

**1**answer

144 views

### Adding value to cell based on ending of string in another cell in Excel

I've got a seemingly involved request that I can't seem to wrap my head around. I will try and simplify as best I can...
I have a column (A) that contains number values, and a column (B) that ...

**0**

votes

**0**answers

52 views

### How do I program a excel chart to auto find or tell me the % likely for the next line?

Basically, I'm trying to find a way to get my excel file to tell me what is the % likely the next line is going to be a given set of numbers.
https://www.dropbox.com/s/bd4hgyt886p86kk/Data.xlsx?dl=0
...

**0**

votes

**1**answer

60 views

### How to make line graph, or bar graph with different categories on excel

I don't know anything about Excel and I've been trying this for over an hour. I had to do an experiment for class that asks if hair color relates to height.
I have the hair color and height of 20 ...

**1**

vote

**1**answer

22 views

### Referencing a range using hyperlink

I'm looking for a solution of hyperlinking a cell.
For example:
On Sheet one I have details
for XYZ from B1 to D5
for ABC B7 to D11.
On sheet two I have XYZ and ABC. If I click in sheet two ...

**30**

votes

**9**answers

4k views

### Limit Excel CPU Usage

Is there a way to limit how much CPU usage excel has access to when running? I have a VBA script that calculates a bunch of giant array formulas. The entire calculation takes maybe 20 minutes using ...

**0**

votes

**1**answer

18 views

### How do I change the blank template in Excel 2007?

I have created a new template for Excel 2007 and placed in it the C:\Users\[username]\AppData\Roaming\Microsoft\Excel\XLSTART Book.
This has worked successfully in that when you open Excel it uses ...

**1**

vote

**0**answers

86 views

### How can I view the properties of a ComboBox on an Excel 2007 Worksheet?

A similar question has been asked and solved on this forum, but the solution offered there does not work for me. I have enabled the Developer tab, and clicked Design Mode, but still, right-clicking ...

**0**

votes

**0**answers

39 views

### Change line style for missing values in EXCEL

I'm plotting a chart where some of my lines contain missing values. I managed to interpolate using Select Data -> Hidden and Empty Cells -> Connect data points with line. However, there's no way to ...