**0**

votes

**0**answers

5 views

### Excel group files not opening

The OS is Windows XP 2003 server and the program is Microsoft Office Standard 2007 (Excel). This computer recently upgraded from Office 2003 to Office 2007.
Upon clicking any .xls or .xlsx book file ...

**0**

votes

**1**answer

14 views

### Excel - Counting unique values with multiple criterias

I have a large scale data set and I am looking for a way to count the number of unique values:
Day -ID, Location-ID, Truck-ID
1, 18, 1
1, 19, 1
...

**0**

votes

**1**answer

16 views

### Replace two numbers in a column with 99

I have Selling Price which is not in proper format as its converted from Dollar to our local currency.
So the amount in the column are ending with random number. I want to change last two numbers to ...

**2**

votes

**1**answer

22 views

### How to create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this:
30.5.2014 700,80 CZK
6.6.2014 1 000,30 CZK
20.6.2014 ...

**0**

votes

**2**answers

35 views

### How do I categorize a list?

I'm looking to categorize/sort a list by matching certain strings. I previously couldn't find a solution so hopefully this way is easier.
Example list:
[A]
The apple is the pomaceous fruit of the ...

**0**

votes

**0**answers

19 views

### Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...

**-1**

votes

**0**answers

18 views

### How to make restoration of corrupted excel 2007 file? [duplicate]

When I open an excel file the following error message is displayed: “The file may be corrupted, located on a server that is not responding, or read only”. Since this happened whenever I open any excel ...

**0**

votes

**1**answer

18 views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**0**

votes

**0**answers

33 views

### Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)

Actually I'm facing a problem now.
I am using Excel 2007.
And, I have two different sheet of excel file with me.
My 1st sheet is my report.
My 2nd sheet is my customer name.
I hope that when ever ...

**0**

votes

**0**answers

24 views

### I am running Excel 2007 and have been working on files and ONLY saving them to my USB memory stick [closed]

I am running Excel 2007 and have been working on files and ONLY saving them to my USB memory stick.
On connecting the device to my PC (using an extension USB cord) I noticed a very brief minute blue ...

**1**

vote

**0**answers

47 views

### vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...

**1**

vote

**1**answer

15 views

### How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...

**0**

votes

**2**answers

28 views

### Comparing two columns in excel to find non-duplicates

I have two columns of numbers, column A and column B. Column A is where a numbered tag is entered when it leaves and Column B is where the numbered tag is entered when it returns. There are spaces in ...

**0**

votes

**0**answers

19 views

### How to Group and Layout Pivot Table when Values is in the Row Labels Field?

I'm attempting to present large amounts of data in a report using a Pivot Table to allow for dynamic filtering/categorization. The data in the table is of the form:
Year Month Category Region ...

**-1**

votes

**0**answers

20 views

### Split apart and remove data

I receive orders for telephone service for between 15 and 30 stores in a single email in regular text format. The stores are separated in the email by one blank line. Each store begins with ...

**1**

vote

**2**answers

19 views

### Single formula to search column and return corresponding fields

Am having issues creating a single formula to search the billionaires list by name and autofill the rank, age, net worth, and citizenship field in the search spreadsheet.
This is the formula I have ...

**0**

votes

**0**answers

11 views

### Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010.
It's a excel 79 to 2003 xls file.
We checked trust centre on 8.1 but no joy, ...

**1**

vote

**0**answers

17 views

### Looking up the same value in a row and returning multipe corresponding values

I am trying to lookup value 1 in the example below and return corresponding column name. When I use index match, it only looks up the first column which corresponds to 1 in the below example, it looks ...

**-1**

votes

**0**answers

16 views

### Excel 2007 function keys not working

In Excel, the F function keys are not working. I am looking for "toggle" for this function.
For example, F4 will not cycle through absolute and relative cell references.
How can I troubleshoot/fix ...

**0**

votes

**1**answer

27 views

### Regional and Language Options >> Customize in windows 7

I can not the find the below path in Windows 7.
Control Panel > Regional and Language Options > select Customize on the Regional Options tab > change the List separator to a pipe "|"
I am trying to ...

**0**

votes

**0**answers

22 views

### EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example:
In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell.
In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...

**-1**

votes

**0**answers

13 views

### Excel 2007 huge data to be filtered and pasted at some other sheet

I have two (and sometime more than two) different files in excel 2007 from which i need to extract data based on some criteria and paste the filtered data to another excel sheet. I was looking for ...

**0**

votes

**2**answers

38 views

### Retrieve row number of clicked cell in Excel [closed]

How can I get row number as result of a clicked cell? For example, if I click on cell C9, then I need the function to return 9 as answer.

**-1**

votes

**1**answer

18 views

### Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing.
The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...

**0**

votes

**0**answers

8 views

### Linking Excel workbooks by headers in tables, using Excel 2007

I can export data via CSV from a large database.
I save this to the desktop as DBaseA then convert to an Excel file with macros and convert to a table. It can get up to BZ wide but no more than 200 ...

**-1**

votes

**0**answers

17 views

### Greying out and hiding a row in Excel based on the value in one cell [on hold]

I'm looking for a way to automatically turn a row background color grey and hide the row based on a date in one of the cells in that row, that is, if today's date is past the date in that cell. Can ...

**1**

vote

**0**answers

18 views

### Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone.
Form example:
09:00 EST 06:00 PST
Is there some sort of custom format ...

**0**

votes

**0**answers

18 views

### Certain file types (INDD and XLS) routinely corrupt on our Windows Server share

We have recently moved to a Windows Server 2012 R2 (I think) network share, which our office of ~30 people access via Windows machines on a domain.
Routinely, but sporadically, InDesign INDD and ...

**0**

votes

**1**answer

25 views

### EXCEL won't link to Internet

I have downloaded data from a website that contains links to other website. When I click on any of the URLs in EXCEL I get the message :
"This operartion has been canceled due to restriction in ...

**0**

votes

**1**answer

13 views

### Hide number until date is entered

Column G has an "In Date" and Column H has an "Out Date". Column J has the "Average Days Between" Column G & H. Column K has the "Total Average" of Column J.
In Column K the formula is ...

**-1**

votes

**0**answers

23 views

### comparing 2 columns in excel and return the same result in a group

hi m new in excel function,
i have a problem like this. i have 2 lists of data
DATA I
NAME SCORE
----- -----
ANA 10
BUDI 20
TINA 30
DATA II
NAME SCORE
----- ...

**0**

votes

**0**answers

20 views

### Replace multiple words in Excel sheet

Sub xLator2()
Dim s1 As Worksheet, s2 As Worksheet
Dim N As Long, i As Long
Dim from(), too()
Set s1 = Sheets("Sheet1") ' contains the data
Set s2 = Sheets("Sheet2") ' contains the translation ...

**1**

vote

**1**answer

67 views

### Find and replace multiple words in a column in Excel 2007

Sub xLator2()
Dim s1 As Worksheet, s2 As Worksheet
Dim N As Long, i As Long
Dim from(), too()
Set s1 = Sheets("Sheet1") ' contains the data
Set s2 = Sheets("Sheet2") ' contains the translation ...

**0**

votes

**0**answers

18 views

### Convert COUNTIFS formula to SUM(IF) to enable external workbook references?

I need to convert the following formula to one that uses SUM(IF), as I am given a #value error when the external data source is closed.
...

**3**

votes

**2**answers

39 views

### Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?

We have lots of spreadsheets that have lists of numbered sound files for an educational app. We use spreadsheet features such as "fill down" for the numbering, and we often use formulas to check ...

**2**

votes

**1**answer

48 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**0**

votes

**1**answer

32 views

### How to I use SUMIF or SUMIFS to automatically add the values of different cells when they meet they meet multiple criteria

Basically I have a spreadsheet with three criteria columns.
I would like to be able to recognize duplicate HTS codes that also have the same country of origin and add the sum of those values, which ...

**1**

vote

**0**answers

28 views

### Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right.
I have a Workbook.Open routine which will change to custom formatting (and back on ...

**2**

votes

**0**answers

53 views

### copy data from multiple word files to excel with vba

I know this question was already asked (Copying data from multiple word docs into one excel sheet) the thing is I can't use the answer.
I'm fresh to vba, but I thought I can handle it. I was wrong. I ...

**0**

votes

**0**answers

42 views

### VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...

**0**

votes

**1**answer

24 views

### Copy the content of one cell, and insert within 2 characters, in the middle of a text content from another cell (Excel)

I am trying to batch copy the content of the cells in column A, and insert it within the "><" of the text in the column B. The result should look like the output in column C. Here is an example:
I ...

**0**

votes

**0**answers

46 views

### Return value from table using Multi-dependent drop-down list

I am trying to obtain the value of a column header (or topmost row value for a specific column) based on the selection of properties from 2 drop-down lists.
...

**0**

votes

**1**answer

25 views

### Hide sheets in shared excel workbook.

I have a shared workbook on which I have hidden some of the worksheets prior to saving.
I have closed the workbook. If another user opens the workbook the worksheets I had hidden are visible. If I ...

**-1**

votes

**1**answer

19 views

### Excel searching column and copying the cell next to it

i need to find the value from column C in the row B, and copy the value from found result in column D. If it's possible with formula and to copy formula to all cells in column D ? without VB?
Thanks ...

**0**

votes

**1**answer

30 views

### Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application.
Below is the example of code that I'm ...

**0**

votes

**1**answer

20 views

### How to match cell to column & return value based on that?

+-------+---+--------------+----+
| A | B | C | D |
+-------+---+--------------+----+
| Mark | | Hasan Shahed | 50 |
+-------+---+--------------+----+
| Hasan | | Saif Alam | ...

**3**

votes

**1**answer

106 views

### Excel 2010: Formula for Sum and Return Date

I have a workbook with a Summary sheet and a Data Set sheet with a linked table containing 700k+ records of financial data on investments. (In my particular case, it is real estate properties; but ...

**0**

votes

**0**answers

17 views

### How do I copy datas with blank/tab into multiple excel cells?

I got a data like:
xx5 600 200
xx6 500 100
I want to copy them into multiple excel cells, like:
--------------------------------------------------
| xx5 | 600 | ...

**0**

votes

**1**answer

60 views

### Pie Radar Chart outline series not working

I have been trying to create a Pie Radar Chart as described in answer to this question.
Everything works until I get to the section that describes inserting a series to create the chart's outline:
...

**-3**

votes

**1**answer

24 views

### need vba code to delete all the code after executing all the code

I need a vba code in Excel 2007 which will remove all the vba code after executing all the function. I am drawing an example here:
Option Explicit
Private Sub Workbook_Open()
'Runs a macro 10 seconds ...