**0**

votes

**1**answer

23 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

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

**-7**

votes

**0**answers

35 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

**1**answer

20 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

30 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

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

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

**0**answers

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

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

**1**

vote

**1**answer

33 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

85 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

27 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

77 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

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

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

32 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

66 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

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

**0**answers

32 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

**1**answer

31 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

81 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

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

**1**answer

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

**1**answer

26 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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

48 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

**0**answers

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

**0**answers

26 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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

35 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

**2**answers

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

**1**answer

30 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

**0**answers

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

**0**answers

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

**1**answer

39 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

**0**answers

37 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

**0**answers

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

**1**answer

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