**0**

votes

**0**answers

8 views

### Auto copy formula in Excel 2007 to next sheet

I run an extremly Large Data qry every morning and dump it into a multi sheet excel file, in that file i have a Sheet set up for just formulas to copy from. Currently i manually copy these formulas ...

**4**

votes

**1**answer

147 views

### How to automatically fill range by interpolating between lower and upper bounds

I apologize I do not have any code or examples too show for this. I am not sure how to even approach or identify the function or result I would like to achieve.
What I have is spreadsheet with ...

**2**

votes

**1**answer

14 views

### Validate that a combination of cells are unique in a row in Excel

I have an Excel sheet where 3 columns (A, B, and C) form a unique identifier for each row, but the values in the columns are not unique. For example:
ABC REF 001
ABC REF 002
ABC ...

**0**

votes

**1**answer

31 views

### Multiple Formulas in one Cell for hotel

I am trying to create a housekeeping spreadsheet where when a room number is entered into a cell a 0 or 1 (0 is for studio and 1 is for a 1 bedroom) is automatically populated in another cell. I have ...

**0**

votes

**0**answers

19 views

### Query/Reports in Excel only

I'm trying to use Excel in a way probably more suited for Access. Unfortunately I have no access to Access or Visual Studio (outside the VB prompts in excel.)
I have an excel "database" with several ...

**0**

votes

**4**answers

34 views

### Excel 2007 How do I get rid of the 0 (zero) in this formula

I have dates in columns U,X,AA,AD,AG and AJ and Names in V,Y,AB,AE,AH and AK. I have the following formula to select the latest updates as they are updated. Columns U and V will be filled first and ...

**0**

votes

**0**answers

7 views

### When moving data in Excel, how do I get data validation from destination

I have a workbook with three sheets, Active, Finished, and Tables. Tables contains auxiliary Tables for data validation.
At some point a row in Active will be moved to the Finished sheet. Both those ...

**0**

votes

**1**answer

28 views

### How to put Tables inside a “Master Table”?

I've been getting a beating by Excel recently! :)
I want to make a "Master Table" that comprehends all of the other tables in my workbook. The problem I'm facing is that if I just refer to the cells, ...

**0**

votes

**2**answers

24 views

### How do I create an excel formula to pick out differences in 2 cell values?

I have a column of company names (column A), a column of the 2014 revenue (column B) and a row of the 2015 revenue (column C).
I want to somehow pick out which companies had zero revenue in 2014 and ...

**0**

votes

**1**answer

62 views

### How to use Index and Match formulas for multiple criteria

I have a spreadsheet that contains Olympic information, with the following fields in columns:
A) Athlete, B) Age, C) Country, D) Year, E) Closing Ceremony Date, F) Sport G) Gold Medals.
I want ...

**2**

votes

**1**answer

21 views

### Horizontal array constant definition issue

I can't understand where I fail (except following MS-original help :-D) in attempt to enter horizontal array constant (C+S+E seq) per MS guidance accessible either from Excel 2007 or 2010 help, or at ...

**0**

votes

**1**answer

32 views

### csv file formatting issue in excel

I have a csv file when opened in notepad looks like this:
sep=,
ProgramXX, PXXXXX, ....
IDXXXXX, XYZXXXXX, ....
This should open well formatted as csv file in excel program but what I see is this:
...

**2**

votes

**1**answer

27 views

### Excel: Clone a list for each unique value in a different list

I have two tables table1: list of unique Ids (list size is 3) and table2: list of items (list size is 3).
How could I create a third list where for each row in table 1 it adds all the rows from ...

**0**

votes

**0**answers

37 views

### Excel: Create a Collapsible Master-Detail View From Another Sheet?

I'm designing an excel template for importing data (into another DBMS).
The problem is, the data will be separated (normalized) into several tables in my DBMS (master-detail model).
Let's say I have ...

**-1**

votes

**1**answer

37 views

### Can I split a spreadsheet into multiple files based on a Row in Excel 2013?

I have a spreadsheet in excel 2013 which have multiple column and rows. I need to send some columns to different people separate files. Please anyone can help me in this. Please try to use macros, or ...

**-1**

votes

**2**answers

56 views

### If one number then a different number

I have two columns of numbers on a data page, over 500 pairs. And I need a formula for the working page that will insert the second number in “column B” if the first number is in “column A”. So if my ...

**0**

votes

**1**answer

18 views

### How to avoid apply to range in copying conditional formatting in excel 2007 [closed]

I want to change the selected cell(A1) colour if its value is greater than other cell(B1) in same row.When i copy this conditional formatting to other multiple cells(A2,A3,A4...) in below rows, it is ...

**0**

votes

**3**answers

42 views

### How do I import data from 6 Excel Workbooks into one on a daily basis?

I'm needing to be able to pull data from 6 individual Excel Workbooks that are all formatted the same, first line being the same header across all six and then the data starting row 2 going down being ...

**1**

vote

**2**answers

53 views

### Excel: Sum a column of text excluding duplicates in another column of numbers

I am trying to figure out a formula. I need to know how many times a certain issue happens based on case numbers. Meaning there are multiple entries under a specific case number for that subject, but ...

**0**

votes

**0**answers

21 views

### How do I copy/referrence last value of the column from another file and worksheet

I have two spreadsheets - one is the inventory sheet that gets updated with sales and purchases, and the other spreadsheet is where I want to reference or copy the ending inventory as soon as it gets ...

**1**

vote

**0**answers

35 views

### Excel 2007 =Hyperlink issue. Calling an EXE with a / switch. The “/” turns into a “\”

I'm trying to run a program from a spreadsheet using the =HYPERLINK function. The formula looks like this (I'm using DIR just as an example so people can recreate the issue if they want):
...

**0**

votes

**0**answers

16 views

### Excel 2007 document form button not working

I have a file which works fine on one user account, but not on other. Both users are logging into the same PC.
What happens is that when the file is open and we click on the form button, it should ...

**0**

votes

**0**answers

14 views

### Find a match of data in 4 columns within another array of 4 columns [duplicate]

Assume I have one row of data in 4 columns such as A1, B1, C1 and D1.
Assume I have an array of data going from E1 to I20.
I want to be able to find a row in the array such that the first 4 columns
E, ...

**0**

votes

**0**answers

42 views

### excel - how to count number of names in a column, name is specified in a cell

I have two worksheets, "Clients 2014" and "Receipts 2014".
The receipts have client names for each row (each row is a receipt).
The search key is in the "Clients 2014" worksheet.
I want to ...

**0**

votes

**1**answer

39 views

### Trying to highlight unique values across multiple sheets in Excel 2007

I am trying to compare the values from column A of Sheet1 (which I have renamed "AR") and column A of Sheet2 (which I have renamed "Paste Here") and highlight rows containing values that do not exist ...

**0**

votes

**1**answer

15 views

### Apply conditional formatting to one cell based on part of a text in a cell

I have a spreadsheet containing a bank statement. In C I have a description of what the transaction is for sometimes just a word and other a sentence. In D I have money coming into the account and E I ...

**1**

vote

**1**answer

41 views

### Excel 2007 how to put a text message in a cell if multiple cells are filled with data

I am trying to put a text message in a cell (say c1) if multiple cells in column A have data in. The cells in column A are A1-3, A5, A6 A8 and will have data from 1-5. I only want the text message ...

**0**

votes

**2**answers

31 views

### Excel 2007 - formula to display last updated cells

I have 6 cells, A1-A6 in Sheet1.
A1,A3,& A5 contain numbers 1-3
A2,A4,& A6 contain the date the numbers changed.
A1 & A2 will be filled first. I want to display both cells in Sheet2 in ...

**0**

votes

**1**answer

27 views

### Open a worksheet sheet in a different workbook by clicking on a cell

Is there an Excel feature to open a worksheet in a different workbook? For example, say I have a workbook called invoice.xlsx and another workbook called service.xlsx. In the invoice workbook, there's ...

**0**

votes

**2**answers

64 views

### Count values for a specified month

Column A has date values (dd/mm/yyyy) and column B contains OK for some dates and is blank for others:
A B
1 01/12/2015 Ok
2 01/12/2015 Ok
3 01/11/2015
4 01/12/2015 Ok
5 ...

**0**

votes

**1**answer

33 views

### Matching and returning values to populate column

I have a workbook (Excel 2007) with two sheets. Sheet1 has more than 8,000 employees and their associated unit numbers, which is a 6-digit ID. I am trying to populate Sheet1!C:C with a corresponding ...

**0**

votes

**0**answers

15 views

### Tex-style keyboard shortcuts for inserting symbols to MS Excel and Word documents

I've used Latex before in Linux and I loved it. My favourite thing about it was the reliance on the keyboard. For example, if I wanted to insert a 'sigma' symbol, I would simply type '\sigma' and when ...

**1**

vote

**2**answers

19 views

### Run-time error '1004';

I was trying to copy the formula from N39 up to the last row but I'm always getting a Run-time error '1004' refer to this line:
n.formula = ...

**1**

vote

**0**answers

37 views

### Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...

**0**

votes

**1**answer

36 views

### How to increase the excel value 1 after to leave the few cells

I enter the following data on a sheet:
Roll-No:- 801
Maximum Marks
20
20
20
20
20
20
Sig. of Class
...

**0**

votes

**0**answers

23 views

### Excel formulae to select cell and cell header

I have a spreadsheet of student data. I want to be able to look up a student and return the grades for the students with the subject header. Students do not take all the subjects.
Name Maths ...

**1**

vote

**1**answer

55 views

### In Excel, populate array based on table with value (and coordinates for desired array cell). All array cells are populated (default to be zero)

I am reasonably good with Excel but a near novice at VBA. I have a three column table. Column A & B have coordinates for an array, with column C having the value to be placed as defined by the ...

**1**

vote

**1**answer

36 views

### 'IF" Formula in Excel with additional conditions

I am working on a template which calculates the cost/price of a cabinet and I'm stuck at a certain point. There are 3 types of cabinets and there is a condition where a particular cost is applied to ...

**0**

votes

**0**answers

29 views

### Error when running a VBA in Excel

I am trying to merge 150.000 different .xls files into one only one master sheet. I have done this many times before but I am suddenly receiving a error in the middle of the process.
Here is the VBA ...

**1**

vote

**2**answers

39 views

### How do I Calculate Variance with Missing Values coded as -99?

I am trying to calculate individuals' variances on multiple measures, however, if they skip a question it is coded as -99. I would like my formula to calculate the variance for these measures while ...

**0**

votes

**1**answer

29 views

### Formula for COUNTIFS excluding another column

I'm trying but failing to work out a formula in Excel 2007. I have an large area of data that isn't in a table format. The main columns I care about are: chapter title (text), number of tasks ...

**1**

vote

**2**answers

158 views

### Need an Excel Macro to sum a variable length range

I am trying to create a Macro that is able to recognize how many rows have values above it and only sum that range. If you look at the attached image, I need to be able to click in cells B4, B10, and ...

**0**

votes

**0**answers

79 views

### Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version.
They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content.
...

**0**

votes

**1**answer

20 views

### How to trigger a letter in a cell when something is put in another cell

Example: when I enter 24 in A1, I would like the letter "x" to appear in B1. I hope this makes sense. I don't know a lot about macros or would a simple formula work?

**0**

votes

**2**answers

33 views

### In Excel, how do I get a list of cells to display based on an if function?

I have a list of quantities with a description column. It's counting doors based on size. I'd like to output a list (preferably separated by commas) of the description numbers with applicable numbers. ...

**0**

votes

**1**answer

71 views

### How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...

**0**

votes

**1**answer

32 views

### excel 2007 updating new adjacent cell value when reference cell i s updated

I have to copy or update cell value to new adjacent cell every time when reference cell value is updated.
I have Cell A1 with some formula, which updates it value frequently. what i need to do is, ...

**1**

vote

**1**answer

163 views

### VBA - Populate cell if adjacent cell is not empty

I have created a macro that opens and edits excel workbooks for me.
Firstly, it adds a new column A and then changes the title for A1, B1, C1, D1.
After this, I want to create some sort of formula ...

**4**

votes

**1**answer

38 views

### Formula bar view changes when document is saved and reopened

I have an Excel 2007 document with a lot of formulas of the format:
SUMIFS(view1[COLUMN1],view1[COLUMN2],$C13,view1[COLUMN3],I$10)
but when I save the sheet and reopen it each formula is changed to ...

**0**

votes

**1**answer

23 views

### How do I replace one argument in each formula in a column of formulas?

I have a column of formulas like this:
=VLOOKUP($C3,Sheet4!$A$1:$H$50,7,0)
picking up the details in column 7, as you can see. But I have now removed two columns from sheet 4 and the pertinent ...