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

Excel: How to check values in mutiple rows which mark values per day and highlight row with the earliest entry

I have a database wich shows value assigned to each customer in each week of the year. What I want is to have highlighted (i.e. marked with X, at the very end of my report) the earliest week on which ...
1
vote
1answer
28 views

Why can Excel 2007 not calculate sub formulas right? [closed]

I have the simplest possible scenario: open a new Excel 2007 document In the first row put 6.99 In the second row put 4.99 In the third row put =A1*0.4 And in the fourth row =SUM((A2-A3)/A2) This ...
1
vote
1answer
80 views

What is the Excel Formula to calculate based on consumption and rate

I need help to come out with a solution for this: Actually I want to calculate my electricity consumption. as the attached pic. the first consumption 0-200kwh, rate $0.218, for 201-300 consumption ...
0
votes
1answer
47 views

Change name box of a image inserted into excel worksheet

When you insert a picture into a excel worksheet, you get automatically Picture 1, Picture 2, and so forth...... I have a function when a picture is selected to put black border around it. Problem is, ...
0
votes
0answers
36 views

Excel 2007 Unprotect Sheet prompt in password protected sheets on Windows 7 machines

Windows 7 users of software I created in Excel get an "Unprotect Sheet" prompt when clicking on any sheet or cell in a sheet that is password protected. They hit cancel, sometimes several times and ...
1
vote
1answer
31 views

How to plot a complex table relation on excel?

How can I generate a table as displayed in the image attached using Microsoft excel. The x and y axis in yellow are simply perfect squares while The table content is composed of axis sums. I cannot ...
-1
votes
1answer
21 views

Excel - Check if there is a match to a cell in the rest of the workbook

I've got a workbook that has spread a list across 10 different worksheets, but the list has become out of date. I'm trying to find out which of those in the new list aren't already included in one of ...
0
votes
3answers
50 views

Vlookup to check all values before returning value?

i have this Project, I have to check values from a different sheet and copy the value of the Cell beside it. Sheet 1 Billy Paul Mike Jesse Sheet 2 Billy | Paul | X Jesse | Billy | X Mike | X I ...
0
votes
2answers
53 views

Removing Space in a number

I have gone through many solutions for removing of space in a number but my data is as below:- ( 76,120.04 ) Here space in staring of number, after comma, & ending of number also. So in this ...
0
votes
2answers
40 views

Excel VBA Run-time error 9 subscrit out of range

While closing the workbook I am getting: Run-time error 9 subscript out of range This is the VBA code: Set wbk = Workbooks.Open(path & filename) wbk.Sheets(sheetname).Range("b6").Resize(...
0
votes
1answer
55 views

Excel highlight row if 2 cell values match

if I have cell D2 (input value 100) and M2 equals the value from another sheet and that value matches the value of D2 how do I highlight the whole row not just the cells?
0
votes
1answer
28 views

How do I copy elements from one sheet to another?

This is a slightly complicated question because it has two dimensions. I have a row of formulas in one sheet in a workbook in Excel. I want to copy the numbers in that row as a column to another ...
0
votes
1answer
34 views

Conditional Formatting help in excel (highlight certain row if a cell in a column displays #N/A)

I am trying to use conditional formatting to highlight a specific row of cells if a certain cell displays #N/A. I tried to use the function = isna() but it did not work as it only highlighted the ...
0
votes
2answers
2k views

Looking to return certain value based on how many times a value matches across two columns

I've got ID numbers associated with up to two values (SYS-A AND SYS-B) in another column, but each ID could appear could appear multiple times under SYS-A and/or SYS-B. I need Excel to look at each ID ...
0
votes
1answer
25 views

MS Excel is automatically protecting worksheet

I have a MS Excel sheet that is, periodically, being automatically protected. How do I stop this from happening? I can manually unprotect it, but since I am frequently modifying and saving this ...
1
vote
1answer
61 views

why am I getting compile error when trying to copy data from master sheet to multiple worksheets

I am very new to VBA and macros so I apologise if this is simple. I have found similar posts but nothing that I am able to adjust to my problem. I found code to create a new worksheet for every new ...
0
votes
1answer
26 views

Transfer only certain columns in excel 2007 to another sheet

I have an excel 2007 sheet I am using as my product database. It has various columns and rows with data as below: Code Company Image Code Picture Page UV001 UV Gear uv001.jpg http://www....
1
vote
1answer
47 views

VLOOKUP for latest non-empty cell

Basically, I've got the following spreadsheet. There are dates along the top. I do a certain amount of past papers each week, and record the highest score I get in a week in cell (paper, week). The ...
0
votes
1answer
38 views

Name in output column should be present only active member is “A” Else should check next row also now cell should be empty or Zero

I Have two workbook one have data as shown in image Sheet 1 and second workbook is output sheet2 The problem is I want data in output sheet from sheet 1 only if active column in sheet 1 Have " A" ...
0
votes
0answers
30 views

How to transfer word paragraph to excel row

I have a word document with question and answers. I need to convert this data to an Excel spreadsheet. I need question number, questions, answers, explanation in separate rows. Example In my word 1....
0
votes
0answers
25 views

Excel not showing special character in my system

I had issues with special character encoding in csv generated from my website. Now encoding changed from UTF-8 to UTF-8 with BOM. But MS Excel 2007 in my PC is still not showing that properly. But in ...
0
votes
1answer
36 views

Lookup formula isn't always accurate

Column A & B are examples from a worksheet that is automatically updated from a a historian data base (the data upload changes every time it is refreshed). Column F & G are examples from a ...
0
votes
0answers
11 views

Possible to Rank by greatest difference in a pivot table?

I have a pivot table that gives me the difference between two time periods. I would like to rank the difference column by greatest delta. Any idea on how to go about this?
0
votes
1answer
49 views

Values not available when using INDEX/MATCH functions

Following on from my previous question: How to calculate an average value based on duplicate groups? I am trying to create a column "Data for Standard Time" which will contain values matching a ...
0
votes
1answer
22 views

Microsoft Excel 2010 Workbook Comparison Code

So I have these two workbooks, the data will not be in the same format, but will have a unique identifying number (like a ID Key in Access). The goal of my code would be to identify rows with the ...
1
vote
1answer
64 views

Force row numbers to remain the same in formula

How do you force the focus of an Excel Cell to remain the same? I have a question in the same reference above link. I am trying to match the data I have in Column A and Column B. If data matches it ...
1
vote
1answer
8 views

Unable to fix right to left sheet direction in excel 2007

Whenever i am opening a new sheet in excel 2007 it is opening from right side like F | E | D | C | B | A how can i fix it like before, A | B | C | D | E | F. Is there anyone suggest me i have done ...
2
votes
2answers
36 views

Labeling a shape in Excel 2007 VBA

I've created a macro to make shapes using AddShape.  I name it with .name but I can't put a label on the shape icon with the macro. If you manually click on a shape you can enter a formula to place a ...
0
votes
1answer
31 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
48 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
43 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
30 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
53 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
41 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
25 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
35 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
121 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
125 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
38 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
84 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
51 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
148 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
56 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
44 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
113 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
35 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
71 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
177 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 ...