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)

-4
votes
0answers
20 views

How do I filter dates? [on hold]

Can I see date only by month or maybe even weeks to see not the whole table, I know how to do that with filter is there any other way? DEZINFECTION DATE PLACE 11.11.2015 BETI 15.11.2015 ...
0
votes
1answer
16 views

Count specific assets (one column) which belongs to unique users (depending on another column)

To get the total of In Stock. I used this formula and it works. but this formula works for specific text. =SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop")) I need simpler formula to count rest ...
-1
votes
0answers
22 views

Java Installer crashing when accessing VBA code

I work usually with DDE Excel. I have two computers, one with Windows XP and another with Windows 10 64 Bit. The problem happens with the latter computer. I connect the computer with provider DDE ...
0
votes
1answer
33 views

Spreadsheet formula for adding all values adjecent to multiple instances of text cells

Given a table with unique and duplicate text values in a column with number values adjacent in the following format: A|12 B|23 C|98 A|66 D|86 E|3 B|25 A|65 . . . The values are simplified for the ...
0
votes
0answers
16 views

How to insert online pictures into excel with VBA

I want to add images from my web image repository so I have all the hyperlinks in row 3 (C3:L3) and in row 2 (C2:L2), I would like to automatically insert the image whenever I press the Display image ...
-1
votes
0answers
13 views

excel formula - suming multiple columns of one row in an index

i want to sum 10 columns of data. I do not want to just sum based on the cell reference. I want to sell based on name ranges. However, I don't want to type all 10 named ranges into the sum box. I ...
0
votes
0answers
15 views

Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data: 1st column is the name of the Route 2nd column is Time1 in decimal hours 3rd column is Time2 in decimal hours 4th column is TimeDifference in decimal hours (or decimal ...
1
vote
1answer
21 views

Pie Chart in Excel, is it possible to have a slice for a remaining balance?

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd ...
0
votes
1answer
35 views

Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this: Actual End Date ----CP 2016-04-22------------4 2016-04-26------------3 2016-04-26------------9 2016-04-22------------7 ...
0
votes
3answers
29 views

Leaving a cell blank in excel, or display a different cell

I've tried to read the other posts and follow but I just can't wrap my head around this formula. I would like F9 to: be blank if no data is entered in D9 if data is entered in E9, then D9*E9 if ...
0
votes
0answers
31 views

Excel converts comma delimited to tab delimited when saving [duplicate]

I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...
-2
votes
0answers
16 views

About spreadsheets Microsoft excel 2007 [closed]

What if I want t calculate exams attempted when the other Rawls are blank and others have marks for the attended ones
0
votes
1answer
19 views

Values need to copy from Col A to Col B in Excel without data loss

In my Excel, I have 2 columns For Ex: Col A & Col B. In Col A I have 100 Records but in Col B having only 50 records that is scattered not in sequence. I have to copy and paste the same ...
0
votes
0answers
6 views

Sort data on repeat sequence

I want to order the data of my spread sheet on a repeat sequence Actual a a a b b b c c c Desired a b c a b c a b c Any suggestions are much appreciated
0
votes
0answers
14 views

Excel 2010, “Runtime Error '32809': Application-defined or object defined error”

I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the ...
1
vote
1answer
40 views

Excel IF formula using before or after date and amount

I need help writing a formula for the following. superuser sample I hope you can see my image, and I explain myself well enough. I want column L (my new column) to display column I(dollar amount) ...
0
votes
2answers
11 views

Looping through two column to check for condition

I want to loop through column P and see if there is a cell that has the number "1" in it then at the same time loop through column N to see if there is also a number "1" at same row/column, if there ...
0
votes
1answer
44 views

Check excel cell if font is a certain color?

I want to use vba to check if the text in a cell in excel is of a certain color, lets say red. Any ideas?
-1
votes
0answers
19 views

How do I make this kind of line graph with MS excel or if not possible what is the next possible solution?

1I wanted to make this graph. The first figure is a single figure line graph with 4 vertically connected line graph . x axis is weeks and y axis is %. The other figure is an 8 line graphs connected ...
0
votes
0answers
25 views

Excel 2007: Why #REF!+#REF!=number in evaluating formulas?

Total A.xlsx contains formulas adding cells (without the help of functions, just the "+" sign) from several files named 01 A.xlsx, 02 A.xlsx and so on. All files (including the total) are in the same ...
0
votes
1answer
23 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
24 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
58 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
32 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
21 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
25 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
20 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
35 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 ...
-3
votes
0answers
63 views

Vba formula that colors a certain data in a column when the corresponding data of the other column were found having more than 1 value

I have serial numbers of different products in column D. Each serial is duplicated several times through out the column. I want the serials that have more than one price corresponding to them in ...
-1
votes
0answers
10 views

Excel 2007 - Sorting data

I have a spreadsheet set up with products down the left and months & values in columns next to each other across the top, this spread sheets is complete but I am unable to sort the data as I need ...
0
votes
2answers
50 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
29 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) ...
0
votes
1answer
39 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
23 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
20 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
1k 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
22 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
48 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
22 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 ...
1
vote
1answer
37 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
30 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
29 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 ...
0
votes
0answers
19 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
33 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
8 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
50 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
31 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 ...