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)

1
vote
0answers
13 views

How to add data vertically while xtracting tables from web page to excel

My code Public Sub Raju() Dim alertTime As Date alertTime = Now + TimeValue("0:05:00") ' ' mymacro Macro ' Dim ws As Worksheet Set ws = Worksheets("Sheet1") ...
0
votes
0answers
7 views

Copying Conditional Formatting rule to range of cells and automatically updating the cell references

I wanted to apply Conditional Formatting to range of cells A2:A30 using a formula =Countif(A2:A$30,A2)>1. It works and gave the desired result. However when I go to any cell other than A2 and click ...
0
votes
1answer
10 views

Excel scatter plot with two x series and one y series

My data consists of a y value and the two x values that can be used as inputs to a quadratic equation to give the y value. I'd like to plot them, ideally with separate colours for the positive and ...
-1
votes
1answer
17 views

How do you consolidate “date. Time1 and Time2”? [on hold]

How do you consolidate "date. Time1 and Time2" For example: A B C 1 Date Time1 Time2 2 09/04/2016 05:03:15 AM
0
votes
1answer
30 views

Mirroring formulas to multiple sheets in Excel

I have an Excel Workbook with multiple Sheets each using the identical layout, but with different sets of data. From time to time, I need to vary the way the values are calculated, but I don't want ...
0
votes
0answers
12 views

Excel Help - how to pass the in SQL Query from another cell [on hold]

I have SQL query in one Cell and Query data from the another cell Example. Below Query internal ID i need to pass the another cell.please some one help me, how to pass the values. { ...
0
votes
1answer
25 views

How Can I make an excel column of Hyperlinks open in NON default browser

I have a ms excel 2007 worksheet with a column (A) of hyperlinks using the excel function in this way =HYPERLINK(A2,"url". How Can I make (if this is possible) open all cels on that column in the NON ...
-2
votes
0answers
22 views

Why data is getting copied in the same row?

Found this coding online and tried to use it for one of my workbook. This is not the exact coding as I needed to tweak as per my data.When I click on the button(Macro) 1st time it's correctly moving ...
0
votes
0answers
12 views

I am looking to reverse lookup missing numbers from a VLOOKUP in Excel

Hi please let me know if this is a duplicate but I did a brief search and did not find anything that wasn't a ton of code that I couldn't relate back to my spreadsheet. I have excel 2003-2007. I ...
0
votes
1answer
39 views

MS Excel - I wish to count unique values based on a parent column

I am very new to Excel. I need some help in counting unique values in each of three columns (considering them only one at a time) with respect to a parent column (the first one (A) in the image). Can ...
3
votes
1answer
32 views

does Excel copy only visible cells when a filter is enabled

According to MS doc excel 2007 https://support.office.com/en-us/article/Copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e excel 2013 ...
0
votes
2answers
24 views

Apply Custom Number Formatting to Error values

I'm trying to apply a custom number format to cells in Excel 2007 that return an error value. I understand that I can apply custom number formatting to number/text values in the form ...
-2
votes
0answers
20 views

Excel VBA - Combining daily data into monthly data [closed]

I am very new to VBA. So, my problem is that each day I have a file containing a list of products (with their respective code) with their total volume sold and the value of each product sold ($). I ...
1
vote
1answer
82 views

Is there an English Office Language Interface Pack?

Located in France, I have only access to a French version of Excel and would like to change it to English for programming purposes. I want to use this model, based partly on Excel VBA code. Currently ...
1
vote
2answers
30 views

finding multiple values in one column and replace values in another column

I want to find values in one column and replace values in another column in sheet2. My data is in sheet1. How do I find and replace value? I tried the following formula but it is not working. ...
0
votes
1answer
33 views

Excel weight calculations

I'm really new to excel and was wondering how I could take the info below and if one of the items was not a full box, and contains say 5 eaches of that product instead of 40, how I could enter that ...
1
vote
2answers
27 views

Compare groups of cell values according to column headers, in 2 different tables.

I need to compare a group of values in Table A to another group of values in Table B. If the column headers (the name of the columns in each table) are the same in both tables, then the respective ...
-1
votes
1answer
37 views

How to extract only specific numeric values from a range of data in MS Excel?

I have a range of data say a1:a100 in which there exist mixed up numeric and alphabetic values. I want that only the numeric values which are greater than 1 and lesser then 10000000 (i.e. falling ...
-2
votes
1answer
32 views

Linking Data in Excel

What is the easiest way to do the following: I have a list with 4 columns (customer name, invoice number, invoice date, invoice amount) and in another spread sheet I want to enter the invoice number ...
0
votes
1answer
23 views

Reference formula 'Text' within another cell in Excel [duplicate]

I would like to insert text from a cell into a formula. For example, using the formula: =LOOKUP(A1,'Sheet2'!B2:B10, 'Sheet2'!D2:D10) I would like to change 'Sheet2' to some other reference (i.e. ...
0
votes
1answer
37 views

Remove words in a cell that are already in another cell

I have Business names in column A and descriptions in Column B. this descriptions included business names also. Example: Column A: McLain Homes Column B: McLain Homes Est in 1990 McLain ideally ...
0
votes
1answer
20 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
50 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
39 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
21 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 ...
-2
votes
0answers
14 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
20 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
26 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
74 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 2016-04-26------------6 ...
0
votes
3answers
31 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 ...
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
1answer
18 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
29 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
55 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
59 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?
0
votes
0answers
27 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
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
72 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
41 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
29 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
30 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
43 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
35 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
45 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
27 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 ...