**0**

votes

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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 ...