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
2answers
44 views

How to compare time in multiple rows using excel 2007

I need help to compare time in multiple rows in excel. I am creating a new rule in conditional formatting. I'm entering this formula in formula bar to compare time across multiple rows: =IF($E$4:$E$6 ...
1
vote
1answer
46 views

Copy Conditional Formatting 3-Color Scheme to another tab

I have one sheet, Tab 1, with a 38x12 grid of values ranging from -30 to +30. I applied the traditional 3-color scheme conditional formatting to the data, which shows all shades of the spectrum ...
1
vote
2answers
70 views

Extract string containing a word from an Excel cell with hundred of strings

I have an Excel workbook, in column A each cell contains all URLs of a site (this means hundreds of URLs in one cell). Among all the URLs within a single cell I want to extract only the URL that ...
0
votes
0answers
44 views

Realtime update of Powerpoint data from excel (no graph)

I am trying to create a PowerPoint to be used for a non-profit gala pledge drive. I want to show the names of folks pledging and the amount. Plus, the running total of amount pledged. I was planning ...
2
votes
1answer
60 views

On Excel I want to create a list from another sheet based on two values

I have 2 values in dropdown menus in cells B2(DATE) and B5(ITEM). from these values I want to create a list of items(based on B5) that were sold on that date(B2). The transactions are listed on a ...
0
votes
0answers
9 views

Excel is removing embedded images within by 2007 files. How to I prevent this?

I have embedded Jpg images into a column within an excel 2007 worksheet. However when I try to reopen the file, excel says it can not read the data in this Column and then strips it out. How do I ...
1
vote
2answers
87 views

How do I create randomized word lists that are dependent on a master list?

I am using excel for Mac 2011 For a linguistics project I want to do the following. I will have a word-list like this (in reality it will be much bigger): Master List: Bag Leg Magnet Apple Gum ...
0
votes
0answers
11 views

MS Excel 2007 report made using Excel is slowing down day by day

I have an Excel file on a shared folder in use daily, perhaps 5-10 times per day. Editing it less than 5 times a day. My assistant doing same. The size of that file (empty) is less than 600 KB. Also ...
0
votes
1answer
24 views

Taking data from an adjacent cell by name in cell

I am a basic Excel user. I do a monthly rota which has the staff name in one cell and in the following cell it has the hours worked. Is there a simple way to write an formula so that Excel takes any ...
0
votes
1answer
70 views

VBA Script loops in all sheets but doesn't produce output in all sheets

This VBA script I have loops through all sheets but I don't see the output in all sheets. What would be the reason be? Sub A() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets Dim ct As ...
0
votes
1answer
30 views

How can I apply this macro to all the pages in an excel file

I have a code to do a particular modification to some cells in a page. I'd like to apply this code at one click to all the pages in the excel file. I'm using VBA and am a newbie to it. Here's my code ...
2
votes
1answer
68 views

How can I execute this function using VBA in excel?

I'm trying to get this function in VBA but I'm new to it. I don't seem to know how I can get this done: What I'm trying to do is, for each cell in column B that's numeric, I want to take the next ...
0
votes
1answer
16 views

How to fill missing times with dummy values?

I have quite an urgent question. I have data (concentration) which was logged every minute. However, when I download my data there are some times (e.g. 1 or 2 minutes) in between missing. For 24h I ...
0
votes
1answer
90 views

How to copy a formula or value into another formula

I want to know how to copy a formula into another, while keeping the original values. For instance, I have in range A1:A5 five values (a mix of constants and/or formulas) and I need (in that same ...
-1
votes
1answer
49 views

How to expand a range of values to individual values separated by commas in MS Excel 2007 and 2010

How to expand a range of values to individual values separated by commas? Example 1: convert R1-R8 TO R1, R2, R3, R4, R5, R6, R7, R8 1-10 TO 1, 2, 4, 5, 6, 7, 8, 9, 10 I need these expanded range ...
0
votes
2answers
118 views

Reset Sequence Number With Change of Month

(Cell A1) Invoice Reference No. EPS-I-S151001 (Cell B1) Invoice Date 05/Oct/15 Once the Invoice Date is manually entered, Invoice Reference No will be automatically generated. The ...
0
votes
0answers
43 views

Can Excel auto generate squencial number?

I have a manual invoice registry log which I would like to overhaul. Currently I will manual assign an invoice number when I want to create a new invoice. Let's say Column A is the Invoice Number and ...
1
vote
0answers
27 views

Excel gives error while opening file recovered from a corrupted drive [duplicate]

I accidentally deleted my data on my drive which also got corrupted when I tried to recover the data. I got my Excel files back but they are not opening. Excel is giving errors that it is damaged or ...
0
votes
0answers
40 views

Populate information from on spreadsheet to another on same excel File

I am creating two sheets for one excel file for business conferences . One sheet will be an inventory list of items being sent to conferences, the other a sheet that contains details of the ...
1
vote
1answer
56 views

Performance Gain From Excel 2007 to 2010/2013 for modern PC

My work recently upgraded my department’s computers to shiny new spiffy i7 ssd 16GB RAM boxes. I spend most of my time in excel/access and the company still uses the 2007 versions of this software. ...
0
votes
1answer
42 views

How do I get the cells with no dates to have no color until the date is entered? All of the unused cells are red

=DATEDIF(F2,TODAY(),"m")<=47 THE CELL TURNS NO COLOR =DATEDIF(F2,TODAY(),"m")>57 THE CELL TURNS RED =DATEDIF(F2,TODAY(),"m")>54 THE CELL TURNS PINK WITH RED WRITING ...
2
votes
1answer
588 views

Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...
0
votes
1answer
16 views

Nested Ifs for personal accounting sheet

I have a personal accounting sheet with 5 columns. C is Debit, D is Credit and E is Balance. I want to do 3 things but I've been confusing myself for the past hour. If C5 and D5 are both blank, ...
0
votes
1answer
38 views

Special format of date in excel

A customer wants a special format of a date column in excel. What he wants is that the date (for example 02.06.2014 and formatted as short-date) changes to a number (41792) when the format changes to ...
1
vote
3answers
90 views

How to find average of first difference in one set of column excel/google docs?

I have one column with numbers eg. 130, 131, 135, 140, 120.., I would like to find the differences eg. 131-130, 135-131, 140-135.. and find their average without using another column to find the ...
2
votes
1answer
59 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
34 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
57 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
55 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
85 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
65 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
194 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
183 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
115 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
60 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 ...
2
votes
1answer
534 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
718 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
83 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
89 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
139 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
33 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
96 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
239 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
170 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
1answer
64 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
116 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
49 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
72 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
80 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 ...