**-6**

votes

**0**answers

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

**1**

vote

**1**answer

12k views

### Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...

**2**

votes

**1**answer

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

**1**answer

4k views

### How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...

**5**

votes

**7**answers

24k views

### Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...

**0**

votes

**1**answer

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

**1**

vote

**2**answers

2k views

### Excel: How to plot a stacked scatter set

I have two datasets that share the same x values, but each have different y values.
I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...

**1**

vote

**1**answer

4k views

### How do I add values in column B if column A contains the same employee surname more than once?

State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once?
I have been using what I ...

**0**

votes

**2**answers

2k views

### Hyperlink to doc file slow opening

I've two excel file with inside some link to .doc and .pdf file. Both excel files and linked files are on a network shared folder. The first excel file is an .xls, the second an .xlsm.
While opening ...

**3**

votes

**3**answers

8k views

### Convert Text Value to Time Value in excel

I am trying to convert text to time. Basically I copy and pasted the total time of employees but it pastes as text value and then in order to add the time I have to convert it to time and I have to ...

**0**

votes

**2**answers

118 views

### Concatenate a range with values in between

I work with ranged data and want to populate a cell that includes values at set increments between the min and maximum. For example, the minimum outer diameter is 1 1/16" and the maximum outer ...

**0**

votes

**5**answers

1k views

### When opening any file in excel, a 1 is added to ther name, and the default is to save a new copy…

Ok... I've searched a lot for this, but it's not an easy question to search for!
When I open any files (xls, or xlsx) in Excel 2007, excel acts like it's a read only file, essentially creating a new ...

**0**

votes

**2**answers

635 views

### Disable custom view in Excel

I am using a shared excel workbook that everytime a user accesses it and saves it, it
saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...

**1**

vote

**3**answers

12k views

### How can I stop Excel (2007) from copying hidden cells?

Let's say I have some rows or columns that are hidden, and drag a selection across where those hidden values would normally be. Is there a way to prevent Microsoft Excel from copying those hidden ...

**0**

votes

**0**answers

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

**10**

votes

**1**answer

13k views

### How can you make Excel 2007 stop formatting large numbers as scientific notation?

Kind of the inverse of this question.
I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal ...

**0**

votes

**1**answer

8k views

### Reference entire excel 2007 sheet to another sheet

I have one sheet with 100 rows of data.
I have a second sheet that will use the same data but with filters applied. In fact, I will have a dozen sheets, each with different filters.
My goal is to ...

**0**

votes

**1**answer

1k views

### When importing data from web page using Excel, hyperlinks are lost. How to solve this?

When using the Data menu item in Excel to import data from web to spreadsheet, the hyperlinked items lose the link and appear just as text (for example try this: Test - How to overcome this?
Note:
I ...

**0**

votes

**1**answer

3k views

### Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)

I have made a spreadsheet to specify decoration selections from a range of standard options.
There are five separate ranges so this is the first selection then within each range there are additional ...

**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

615 views

### Insert Sheet Columns is greyed out in excel 2007

I want to insert a column in excel 2007, yet the insert column is greyed out
the sheet it not protected, and there is not restrictions whatsoever
another sheet on the same file work correctly.
how ...

**0**

votes

**1**answer

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

**1**answer

4k views

### How do I get Excel to pull data from multiple workbooks from exact dates based on an entered date

I am running windows-7 and using Excel 2007 Enterprise.
I am a truck driver and need to catalog my pay based on a changing day to day system. I am paid per mile, per stop, per hour, or per flat rate ...

**4**

votes

**12**answers

20k views

### Mouse wheel does not work in Excel 2007

I am running Office 2007 on Windows XP-SP3. My mouse wheel works fine in other applications, meaning that it scrolls information up and down when the mouse is positioned over a given panel. It's even ...

**0**

votes

**2**answers

3k views

### In Excel I need to find data matches between two arrays - one horizontal and one vertical

In Excel 2010 (or 2007 - I have both, although my OS is only Win7 32 bit as a limitation for some legacy applications we run), I need to find how I can find and return the matching value from two data ...

**0**

votes

**2**answers

3k views

### d/m/yyyy to dd/mm/yyyy

I want to change the data such as 9/4/2012(some cells with, green arrow in the right corner. ) into dd/mm/yyyy.
I want to standardize all the data of such column into dd/mm/yyyy , I format the ...

**0**

votes

**0**answers

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

**1**answer

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

**20**

votes

**6**answers

9k views

### How can I use custom colours in the Microsoft VBA editor?

I'm working on a few projects for work using Excel and VBA, so I have no choice but to use the Microsoft Visual Basic editor. I normally wouldn't mind, but I can't figure out how to set a custom ...

**0**

votes

**2**answers

88 views

### Force external link in Excel to break if the file can't be found

I have an Excel spreadsheet that has an external link to another spreadsheet. What I want to happen is if
Main_Spreadsheet.xlsx
Secret_Data.xlsx
When someone opens Main_Spreadsheet.xlsx and they ...

**0**

votes

**0**answers

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

**1**answer

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

**0**

votes

**4**answers

386 views

### Multiple conditions in if statement on non-contiguous cells in Excel

I would like to perform an if statement with conditions on the values of multiple non-contiguous cells, something like
...

**2**

votes

**2**answers

16k views

### Stop “Excel formula or sheet contains the name” dialog

When I want to copy a sheet (within the same file, so simply using left mouse button and Ctrl) in Excel 2007, I get this pop up dialog:
where Author is a specific field somewhere in the sheet I'm ...

**2**

votes

**2**answers

5k views

### How can I refresh a document I have open in Excel in read-only mode?

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it.
Every so often, in order to get the latest ...

**1**

vote

**1**answer

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

**-1**

votes

**1**answer

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

votes

**1**answer

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

**0**answers

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

vote

**2**answers

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

**0**answers

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

**9**

votes

**2**answers

26k views

### Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).
How can you configure Excel to use the same ...

**3**

votes

**1**answer

2k views

### How to draw a 'sane' scatter plot in Excel?

I've been at it for over 2 hours now and am just a bit flustered :)
I have the following data (for example):
Label | Criterion 1 | Criterion 2 |
A1 | 7 | 3 |
A2 | 1 ...

**0**

votes

**0**answers

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

**2**answers

2k views

### Lookup Multiple Results for Multiple Criteria

I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...

**3**

votes

**2**answers

67k views

### Plotting multiple series in a line graph in excel with different time values?

I have the following data:
Time v
0 5.4
5 4.5
10 5.3
15 6
20 5.1
25 7.4
30 6.7
40 6.1
50 6.9
60 5.9
70 6.1
80 6.2
Time v
0 4.7
5 4.8
10 5.5
15 6.1
20 6.8
25 7.5
30 7.9
...

**1**

vote

**1**answer

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

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