Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

0
votes
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
9answers
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
1answer
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
0answers
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
0answers
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 ...