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)

-6
votes
0answers
33 views

Select higher / lower value by formula [on hold]

Which formula can I use to find out a value which is lower or higher, as per below example? APPLE MANGO ORANGE DESCRIPTION QTY UNIT PRICE AMOUNT UNIT PRICE AMOUNT ...
2
votes
1answer
18 views

Excel - split view of sheet horizontally but viewing two separated sets of columns instead of rows

I have a sheet in excel 2007 which is quite long horizontally. I'd like to see the 'first' columns of the sheet at the same time as the 'last' columns. If I split the sheet horizontally (with a top ...
0
votes
1answer
28 views

Autofill formula to return data from every tenth row

In Excel 2007, how do I autofill a function of =OFFSET(C2,10,0) to end up as: =OFFSET(C2,10,0) =OFFSET(C12,10,0) =OFFSET(C22,10,0) etc. as a pattern of referencing every 10th cell in the same row. ...
0
votes
0answers
23 views

Excel 2007 Conditional Formatting On Formula Not Updating When Cell Updates

I have set the following conditional formatting rules: =$B97=1 Set Format (Custom) ">" @ On cell =$D97 =$B97=2 Set Format (Custom) "> >" @ On cell =$D97 =$B97=3 ...
0
votes
0answers
25 views

Exteremly Slow Microsoft Excel operation in LENOVO G550 series Laptop; Shall I add more RAM?

I am doing complex Macro operations in Excel 2007/2013 which generates random numbers and does many multiplications/divisions in each cell value. It also copies data to multiple worksheets and text ...
0
votes
1answer
12 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
0
votes
1answer
37 views

Group values in Excel

I have 500 rows of items. I need to enter these in an application where I can enter a maximum of six items at once by creating a unique Group ID for these six items. The items in a group share the ...
0
votes
0answers
44 views

MS Office 2007 Windows 10

I have used excel to set up a rota for home hosting a regular Bridge night, mostly there are 9 members but occasionally 10. The spreadsheet is setup with the 9 names rotating downwards in column A, ...
0
votes
1answer
36 views

Excel - How to check if and in how many rows a certain value/string is present in range

I have a list A of strings and I want to see if and if yes in how many rows each string is represented in range B. My data looks something like this: List A: aaa bbb ccc Range B: 1 aaa --- --- ...
0
votes
0answers
11 views

Excel 2007 Microsoft Action Pane 3

How do I install Microsoft Action Pane 3 on Microsoft Excel 2007? When I go to XML plugins, there is none on the list... I can add some manifest xml file, but where do I download it?
0
votes
1answer
20 views

Dynamically change cell reference of a formula in another cell where there is a reference to original formula w/o copy pasting the formula

I have a formula in cell A1 as =A2+A3, now i need the same formula in cell B1 as well however i dont want to copy paste the formula, i just want to give reference of A1 in B1 and B1 should calculate ...
1
vote
1answer
31 views

Excel: Checksum-like function to check if table copied correctly

I have the following scenario: I have a spreadsheet A with a large table. I open spreadsheet B and copy the table from A into it. I want to check if I copied the table from A to B correctly. In ...
0
votes
1answer
65 views

Stacked column chart in Excel with the label of x-axis between the bars

I want to draw a stacked column chart in Excel and I want to put the label of the x-axis between the bars; for example:
0
votes
0answers
26 views

Macro, Formula or Code? Copy data to new sheet based on specific criteria?

I have tried pulling this together with various formulas but A. A lot of the didnt work and B. it was very messy. For the example of this question lets use a Music CD with 2 Disc. The information is ...
-1
votes
1answer
75 views

Finding a value base on an “ID”

How can I assign a "CityID" in "Customer Table" using customer's Address and a given "ProvinceID"? (Province Table) ID . ProvinceName 1 . . Ontario 2 . . Quebec 3 . . Nova Scotia 4 . . Quebec (City ...
1
vote
2answers
38 views

How to convert cells of a column to text in Excel 2007

I have a column consisting of cells (from 1 hundred to over 100 thousands) with values like : 5 12 78.456 1235.78510 AFT780.963 ZFLQ 57180.004 ... I want a way to rapidly change the format of the ...
0
votes
0answers
22 views

Excel 2007. 2nd Formula wont accept result of 1st formula on a different work sheet

I have a rather frustrating problem that it seems others have had also but I have yet to find a solution that works. I have simplified things below as I tend to give too much information. Basicly I ...
-1
votes
1answer
84 views

Correct way to write or even better combine these two Excel 2007 formulas

I have two formulas. As an example for this question let's assume I have a workbook that is basically a CD Database. It contains all the usual information that you would expect. This workbook is ...
0
votes
0answers
28 views

How to transpose a named range in Excel 2013, using cell formulas (not VBA)

Similar to this question, I want to display the values of a named range (horizontal) in a vertical range. If I have data a b d f which is named Letters (as a named range). I want to display this ...
0
votes
0answers
17 views

altering values in cells

I use a spreadsheet which has been pre "set". I add values and it auto does the calculations. For some reason my current spreadsheet will allow me to go to the cell I want to edit BUT as soon as I ...
1
vote
1answer
62 views

Change excel formula references when dragging across columns

I have a row that I want to populate with formulas like =SUMPRODUCT(B93:B96,B46:B49)/SUM(B46:B49) =SUMPRODUCT(C92:C95,C45:C48)/SUM(C45:C48) =SUMPRODUCT(D91:D94,D44:D47)/SUM(D44:D47) but dragging ...
0
votes
0answers
15 views

Daily spend vs projection spend pacing (%) [migrated]

I have a google doc sheet which currently has all our accounts spends.There are two tabs.The first tab details our actual daily spend for each account for each day of the month.The other tab is a ...
-3
votes
0answers
31 views

VBA Delete duplicate rows in column B (date) if column C is blank

I have a list of dates in column B, I may have same dates mulitple times as I'm inserting data from another sheet so I'd like some VBA to delete the duplicate date from COL B if COL C is Blank. Hope ...
0
votes
1answer
30 views

Adding value of rows if column A and B cells are similar in Excel

I have a situation. I have three columns | A | B | C | |Category | Sub | Price | Column A is basically Category column, column B is Sub Category and "C" is price. I need to add the ...
0
votes
2answers
80 views

If Difference Higher or Lower than Display

I need a excel formula that will show: * "1" if B is less than A by more than 2 * "0" if B is within 2 of A * "-1" if B is higher than A by more than 2 Can someone please tell me whether this is ...
3
votes
2answers
41 views

Filtering Data Excel Data from Survey to Obtain E-mails

Over the summer we conducted a survey for a number of students to indicate their interest in a number of clubs. The way the responses were scanned in gave us a column for each club and a '1' in each ...
0
votes
1answer
21 views

How to open a particular form from another worksheet

I have two Excel files (A&B) which have more than two forms and I need to open a particular form from file B by clicking a button from file A. As of now I'm opening file B by clicking a button ...
1
vote
1answer
25 views

Lock color scale (convert to fixed)

I have used conditional formatting to apply a color scale to a range of values. Now I would like to permanently freeze those colors. I have poked around a bit, and can't find event the beginning of ...
0
votes
2answers
17 views

If/Then (# to Text) With Multiple Number Ranges

I am using Excel and trying to create a formula. Part of the formula works, the next doesn't. I'll explain. Column P is "BPM" (Beats Per Minute) and will have a numeric value, which will be entered ...
0
votes
1answer
12 views

Changing current mail merge to use new source data

I have a mail merge file that I created last year, I would like to use a new source data file to create new post cards. Can this be done and how do I go about doing it? I really don't want to create ...
3
votes
1answer
32 views

Extract content from the formula in a referenced cell in Excel 2007

I have a cell A3 that says Name. Cell F16 contains =A3, which displays Name, just like I want it to. I need cell F26 to take the information from cell F16 and display the referenced location. In ...
2
votes
1answer
39 views

Looping through master sheet and filter out rows that are needed

I have created a script which I want to allow a user to select a file (Master File) and if a condition is a met I want to Copy the data to the excel workbook (which the script is run on) The code ...
0
votes
1answer
34 views

Excel Formula with conditions

This feels like it should be simple but my head is hurting now and I'm struggling. I need to add a condition to an existing sheet which already contains formulas and references to other sheets. ...
1
vote
1answer
45 views

How do I recover a previous version of an Excel file which was overwritten? [duplicate]

Does anyone know of a way to recover a previous version of an MS Excel (2007) file in Windows Vista Home Premium version, which I've accidentally wrote over?
0
votes
0answers
29 views

Having trouble graphing big data in Excel (3500+ rows, 2 columns)

I really need with help this issue. I'm trying to show a relationship between two categories but the only problem is there's too much data! Problem: Is there a relationship between X and Y? X and Y ...
0
votes
0answers
25 views

Is this possible to generate excel combo box based on cell value?

As you can see, Cell C2 got 1,2,3,4. I assume this is a student id. So, I would like to generate a combo box in Cell B8, using Cell C2's data, separated by ,. So, in this case, the combo box should ...
4
votes
1answer
53 views

Add multiple series to a dynamic chart

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...
0
votes
1answer
30 views

In excel how could I generate a row of data from another sheet?

In excel I have a sheet named "sales", and another one named "factor". In factor I have some fields for factor ID, customer name, product code, quantities and price. I want when I add this data to ...
1
vote
1answer
21 views

Excel - pivot date values with max function

I am trying to pivot date values in a pivot table in MS Excel. I am getting incorrect date values. I do not want "Grand Total" as they do not apply for dates. Is it possible to do such pivots in ...
1
vote
0answers
32 views

Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row. See the picture or xls example https://dropmefiles.com/BDlHe 1st table lookup ...
1
vote
2answers
36 views

Bypass Excel file selection confirmation for data connection with non-.txt text file

I have an Excel workbook that processes model output from another program. That program produces space-delimited plain-text output files with a ".plt" extension. I have a data connection in Excel to ...
1
vote
1answer
29 views

2010 Excel formula dilema [closed]

I am trying to set up an inventory spreadsheet using 3 worksheets. the first one has the items in inventory and their counts. the second sheet consists of the number of items used at an event which ...
1
vote
0answers
25 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...
1
vote
0answers
36 views

Why am I getting an error in this Excel module that runs access queries and copies results to the workbook?

I have written a module in excel to run 6 access queries and copy them into the excel workbook. My code works perfectly until I get to the 5th and 6th query then I get the error; Run-time error ...
1
vote
1answer
38 views

Conditional formatting based on specific cells

Is it possible to set conditional formatting based on a value written in a specific cell? I would like to colour the rows of saturday and sunday and not colour the working days. The condition is ...
0
votes
0answers
36 views

Excel formula works on one sheet but not the other. Non-blank max number

I'm trying to calculate the max number between 2 non blank cells in column A, using the values in column B when B>C. There are no blanks in B:B. C is always blank unless C>B. ...
0
votes
0answers
11 views

Excel match number in differ worksheets

I have a excel spreadsheet with 2 worksheets. Both contains a column with serial numbers. Is there a way to create a 3rd worksheet where all serial numbers in worksheet 1 which match worksheet 2 ...
0
votes
1answer
45 views

Excel, pair 2 columns, then find all rows where column J is in two different Column D

SO I would like to have a formula or macro, to look at a table in Excel, pair two columns say J and M. Then find rows where M is connected to more then one value of Column J, Column J is Super Group, ...
-1
votes
4answers
195 views

How to capitalize the first letter in a cell in Excel

Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel? For E.g Consider the below image : After conversion it ...
0
votes
0answers
42 views

How can i sort data with macro in different worksheet?

I use the following code for sorting a sheet in a workbook with a macro but when I open another workbook, it doesn't work. How I can I change the code so it can run in another workbook as well using ...