# Tagged Questions

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

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 ...
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 ...
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 ...
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 ).
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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 ...
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 -...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 (...
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?
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 ...
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 ...
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 ...
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 ...
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: ...
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 ...
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 ...
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 ...
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 ...
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) ...
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 ...
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)
28 views

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