**0**

votes

**0**answers

10 views

### How do I split a worksheet into multiple files dependent on the column values, calculate sub-totals and plot graphs?

I have a large data set and would like to split these into separate files/worksheets and perform the same analysis over each data set.
I have found a macro to split the data into separate ...

**0**

votes

**1**answer

17 views

### Word got hidden in cells for long sentence?

When I write in cell of Excel 2007, and the sentence is long, it is hidden.
I want it to return to next line. Is it possible please ?
As you can see in this screenshot, the Hello world sentence is ...

**0**

votes

**1**answer

12 views

### Is it possible to sort a column by word in Excel 2007?

I would like to sort a colomn of my excel file following a "word".
I mean to sorting by word. Is it possible in Microsoft Office Excel 2007 ?
If I have :
AHG hELLO
BFF ...
FOO ...
AHG HI
DCE ...

**0**

votes

**1**answer

22 views

### VBA highlighting a cell if corresponding range in the same row is not blank

I am trying to enforce food name in column B of a file if column D to DX (Qty) has any value in it.
Rational is if any new request of food is received which doesnt appear in the file, the user can ...

**-1**

votes

**1**answer

24 views

### How do I isolate certain characters in cell content of an excel to new cell?

How do I isolate certain characters in cell content of an excel to new cell
Example: I have a big paragraph of information wrapped in a cell and I need to separate only few characters of that data ...

**0**

votes

**1**answer

14 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

**3**answers

35 views

### Compare two sheets in Excel and extract the differences to other third sheet

My situation:
I got a huge excel sheet from a manufacturer of products for my online shop. This format:
product ID | price | name | ...
Every week the manufacturer is sending me a updated list ...

**0**

votes

**1**answer

15 views

### MS Excel cell references shifting after using a macro?

Basically this is what happens:
On Sheet1 I have a column of cells that are linked to other cells on sheet2. Looks something like this.
Sheet1!A1=Sheet2!A1
Sheet1!A2=Sheet2!A2
Sheet1!A3=Sheet2!A3 ...

**0**

votes

**1**answer

40 views

### Why does excel tables break VLOOKUP formulas

I have a worksheet using raw data that Excel does not identify as Tables (ie. plainly putting values in adjacent cells), and on another part of my worksheet, formulas doing lookup in that data, like
...

**0**

votes

**0**answers

50 views

### Display the content of Column A when I put a 'X' in Column B

I have a workbook that contains the projects that I'm working, in many tabs.
Each tab has one column that contains the name of the project and another that is an 'on going' column which I mark with a ...

**0**

votes

**1**answer

22 views

### How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013
"Column A" "Column B"
"tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp"
"tjc0058088269r" ...

**0**

votes

**1**answer

23 views

### Excel 2007. I can't enable macro when I open document for second time

The document work perfectly on my computer with office 365, windows 7. But when I copy it to another computer with office 2007 and windows 7, it start normally ( I enable macro and it make everything ...

**0**

votes

**2**answers

24 views

### Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...

**0**

votes

**2**answers

30 views

### Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign.
If I have 3 columns DATE | ...

**0**

votes

**1**answer

42 views

### Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...

**0**

votes

**1**answer

24 views

### Microsoft Excel 2007

My gradebook spreadsheet has student assignment headings in columns B-H and their final grade average in column I. Student names are in Column A in descending order.
How can I print out Column ...

**0**

votes

**1**answer

56 views

### Sheet name dynamically assigned from a cell value

Sub CreateWorkSheetByRange()
Dim WorkRng As Range
Dim Ws As Worksheet
Dim arr As Variant
Dim template As Worksheet
Dim xTitleId As String
On Error Resume Next
xTitleId = "Select Range"
Set WorkRng = ...

**0**

votes

**1**answer

18 views

### SUMPRODUCT where the product is computed from the row

I have a range AG6:AS38. It looks like this:
AG AH AI AJ AK AL AM AN AO AP AQ AR AS
--------------------------------------------------------
6 | 1 A B C D ...
7 ...

**0**

votes

**0**answers

14 views

### Excel 2007 Automatic workbook calculation keeps going to manual

The excel 2007 that I have somehow not updating the formula cells, I go to Excel Option > Formulas > Workbook Calculation and the options keeps going to manual for some reason. I uninstalled Office ...

**0**

votes

**0**answers

14 views

### Outlines of merged cells not staying consistent when a filter is applied

I have a spreadsheet that uses merged cells for visual clarity. The merged cells are in the B column (dates), and in the A column there are various values. I use filters in column A, and in my other ...

**0**

votes

**0**answers

15 views

### Macro Hyperlink Error in Mac OS (Office for Mac 2011)

I am getting an error on a macro only when using a Mac. This macro was designed to solve a problem with a formula using the Hyperlink function to copy a link from another sheet for each row. (Excel ...

**0**

votes

**1**answer

28 views

### Excel Month() function does not detect some date format

I have a simple table like this in excel:
The formula i used was =IFERROR(IF(LEN(B3)>0,MONTH(B3),""),""). I check if a cell is blank by using LEN, if so ignore, else, convert it to month no.
I ...

**1**

vote

**1**answer

23 views

### How to use a variable once, across the equation, in Excel 2007?

okay, is there a way to declare a variable inside a cell, without calling the cell name 3 times, across the equation(?)?
I came up with this, to calculate the age from a DOB entered using the ...

**0**

votes

**1**answer

18 views

### How to delete creating automatic back up file for MS Excel?

Every time I use a file Excel it generate an automatic back up file.
How can I disable this feature?
I use MS Office 2007 with Windows 7

**1**

vote

**2**answers

35 views

### Average the numerical values where an identifier column meets a condition in Excel

In Excel 2007, I have a table with numbers in Columns F, G, H, I, and J. There is an identifier in Column B.
I need the average of all numbers in Columns F, G, H, I, and J where the identifier in ...

**1**

vote

**1**answer

30 views

### Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...

**3**

votes

**1**answer

53 views

### Excel to count number of concurrent sessions based on start/end times

I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time.
I am trying ...

**0**

votes

**2**answers

81 views

### How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)?
Let's say the choices ...

**0**

votes

**1**answer

9 views

### Hyperlinking or linking in another way to a cell without it being able to change

How do I hyperlink or link to a cell from another cell in a way that when rows are added, and the row numbers keeps changing due to new rows of information being added throughout the sheet, the link ...

**-2**

votes

**1**answer

23 views

### Add a cell content to another cell if a different cell has a specific content

How can I fill a cells value (e.g row 29 col A) with =sum(B1:Z1) but then only add the content of a cell in that row 29 if row 4 of that column says "UK IR". That way I can add all the cells together ...

**0**

votes

**0**answers

11 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

160 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

21 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

41 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

23 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

38 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

9 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

30 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

30 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

84 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

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

**1**

vote

**1**answer

37 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

31 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

98 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

60 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

21 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

48 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

65 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

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