Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

0
votes
1answer
39 views

Method to Consolidate Cell Contents from Two Excel Files into One Excel File

I translated an Excel file in Chinese into English with OmegaT, a CAT (Computer-Aided Translation) tool, and a pure English file was generate by OmegaT. However, the customer wants me to submit an ...
0
votes
1answer
105 views

Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100. On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...
0
votes
1answer
915 views

VBA Excel: Function to find a string in another workbook

I'm trying to create a function that searches a string (bom) in two different workbooks and returns a value next to that string. I know the ranges in those workbooks where I want to perform the ...
0
votes
2answers
227 views

Excel - column width differences in copied worksheet

I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open ...
0
votes
1answer
30 views

Separate cell content after “-” for multiple columns at once

-------------------------------------------- | Visible | Actual formula | I need | -------------------------------------------- | 0 | =500-500 | 500 | | 0 | ...
0
votes
1answer
179 views

VBA Excel: How to select only numeric values in a range?

I used Range.Find to locate a string called "Qty", now I want to select all the numbers in that column. I would use .End(xlDown) to get the last row, however the last used cell in that column is not ...
0
votes
0answers
47 views

How to compose one table out of many tables?

I have a couple of tables which contain various data and I'd like all of them to be composed into one table. In one of the tables I have a lot of entries with various IDs for different things on ...
0
votes
1answer
286 views

Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
2
votes
1answer
110 views

Horizontal Index Match Excel 2007

i have a list of customers rows 1-500 column B, with their purchases showing in columns u-AB and based on the maximum purchases done under a specific column (u-ab), the customer will be tagged as ...
0
votes
1answer
407 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 ...
0
votes
0answers
37 views

Microsoft Office Excel 2007 conditional formatting

I have an excel sheet (2007). It is a tracking log of items. In one column I will input the date of the item received and in the next column will be the due date for that item (Example in I15 I have ...
0
votes
1answer
146 views

VBA string search within files in directory not working in Excel 2007

I'm trying to look for a string within a folder containing several files. Once the string is found it should select and copy a value in an adjacent cell 5 columns to the right(Offset(0,5)), then paste ...
-1
votes
1answer
34 views

Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
1
vote
0answers
23 views

Excel: cannot remove advanced filter

I added Data->Sort&Filter->Advanced filter to a cell that allows me to quickly choose a name from a range of names stored in another sheet some time ago. Now I would like to remove the advanced ...
0
votes
1answer
150 views

Excel - Script that search a sheet for a cell containing specific text, and replace the text with a specific value

I want to split a cell with data into other cells based on the data in the original cell. The data from the original cell looks like this (all content in a single cell): ...
-1
votes
1answer
112 views

Invalid date value in csv file

I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...
1
vote
0answers
51 views

Excel, sort through columns

I need to sort through a a few excel columns and can't seem to nail down an easier way besides manually going through line by line. Column A has names where names can repeat, column b has state ...
1
vote
1answer
67 views

How to change cell format from [ss] to number without changing values

I am doing my Msc Ecology thesis and in the process of organizing my data set. When inputting my data for the amount of time a skink spent in a hole I inputted h:mm:ss for the time it went in and the ...
0
votes
2answers
43 views

Indirect turns up with #ref error

I want to use INDIRECT in a formula like =INDIRECT(CONCATENATE(A1,"+",A2),0); where A1 = 7 and A2 = 8. It comes out with #REF error all the time, but if I use the INDIRECT formula like this: ...
1
vote
1answer
70 views

IF statement with multiple answers

I want to make a table and c4 will be radius required and the minimum weight for that radius requirement will be in D4 The chart is; radius quantity 0,040 - 0,06 : 33 0,061 - 0,10 : ...
0
votes
1answer
28 views

Access table data by row index

I have a Table in Excel that is laid out as follows. What I require is a way of accessing a table row by index for a calculation. To be precise, I have been asked to work out an overall coefficient ...
0
votes
0answers
85 views

Getting data from closed files with concatenate formula

Each day a program is creating an excel file for me with some data for the current day. Like what is the price for products, how many people are available today and things like that. Based on all ...
0
votes
0answers
77 views

I'm looking to create some VBA code to search for other instances of certain string, move original instance above found

Please excuse me if I'm posting incorrectly in any way- this is my first go round on superuser. I'm looking to create a fairly basic VBA macro to automate a process in excel I'll otherwise have to ...
0
votes
0answers
105 views

how to convert data in table format to pivot format

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have: ![Input File][1] Product Currency Value US UK Japan Ind ...
0
votes
1answer
84 views

Count from a cell with value to the end of row and dividing total by number of number of months regardless of blank

How do I write a formula that will auto start sum from the first cell with value though to the end which including blanks, and then divide the total by number of cells from the one with value through ...
0
votes
2answers
282 views

Compare two columns in two sheets

I have another question, even though the last one i asked is still pending. I have a large data of over 100,000 records. I am using the code below to loop through the data so that any duplicate ...
0
votes
1answer
725 views

Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form: X | Y ----+----- 3 | 42 4 | 57 6 | 92 11 | 119 19 | 316 (NOTE: The above table is made-up data) What I'd like to do with MS-Excel is to plot 2 ...
1
vote
1answer
44 views

Formula works in excel and not in Google Spreadsheet

The following formula works in Excel but not in Google Spreadsheet: =INDEX(Sheet1!B1:P1,MATCH(MAXA(Sheet1!B11:P11), Sheet1!B11:P11,0)) Would there be alternatives? Thanks, Bing
0
votes
1answer
58 views

How can I exclude Spin Buttons from my Excel sheet protection?

I am using Excel 2007. I need to exclude Spin Buttons from my Excel sheet's protection. Any help would be appreciated.
0
votes
0answers
72 views

Excel file is locked by another user on sharepoint and he is not at work and none is able to edit it

as this user is not available now we cant wait until the person comes and need to release the lock immediately for others use. This file is used by many and one user locking it for edit and leaving ...
0
votes
3answers
70 views

Combine rows in Excel

I have data in column 1 and data in column 2 as follows: 1234 eggs 1234 bacon 1234 toast 4321 Orange Juice I want it to appear as follows: 1234 eggs-bacon-toast 4321 ...
1
vote
1answer
29 views

How to print cell value as many times as its neighboring cell value (unpivoting)

I have some data that is pivoted or summarized that I would need to "unpivot". The data looks like this: 1000000 6 1245142 4 1245246 6 I would need it to look like this (each value in first column ...
1
vote
1answer
31 views

Return Earliest Date from a range

I have an excel spreadsheet where I want to pull the earliest date in the column based on the criteria in a different column (for a given tech) into a different sheet. Rows on sheet1 contain store ...
1
vote
2answers
3k views

In an Excel chart, how do you craft X-axis labels with whole number intervals?

I have a sorted list of values that I'd like to see graphed in an Excel chart just to see the shape of the curve. Here is the initial chart: Looks ok, but the X-axis is ugly, so lets clean that ...
1
vote
0answers
60 views

Microsoft Excel 2007: When trying to save - “File in use. Try again later”

When I open an Excel document from server, edit and then try to save the changed document, I get the message that "path\filename is in use. Try again later". I can use "save as" and save a new ...
0
votes
2answers
49 views

Formatting columns in microsoft excel?

I have a list (.txt document) of telephonenumbers with first and surname and number. Like this : 123123 john doe 123132 michael jordan etc. I want to put the list in microsoft excel that after a ...
0
votes
0answers
26 views

Excel 2007 : find the rows depending two date columns

I am having an unorganised table where the leave data of employees is entered through a form. The data is A B C empname leave from leave upto john ...
1
vote
1answer
231 views

Conditional Formatting in excel based on another column

I have an excel worksheet and two columns. I highlight the first column if the value of the cells are less than 0. Now how can I highlight the second column cells based on the first columns that are ...
1
vote
1answer
102 views

Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc. We are basically trying to ...
0
votes
0answers
46 views

Displaying some cells data depending on selected text from other sheet

I have an excel sheet which looks similar to below and with some more columns. Area Branch Empolyees Products Shelfs Area1 Area1 Branch1 10 Product 1 10 Area1 Area1 ...
0
votes
2answers
29 views

Excel Number Formatting - not to be carried into copied cell

Open a new sheet and type in any cell (28.33943576) Change the format to 4 decimal places to show (28.3394) Copy the cell into a new cell as value only (copies 28.3394) Now if you click on the copied ...
0
votes
1answer
45 views

Highlight duplicate value cells dynamically

I have stored numbers in nine rows and nine columns. When I select a particular cell I want to highlight all cells with same value e.g. if I select cell having value 8 all cells having value 8 ...
0
votes
1answer
284 views

Populate empty table with data from oter table based on dropdown list selection

I have 3 tables, Tab1, Tab2 and Tab3 containing data and an empty table Tab The user can select in a drop-down list, option1, option2 and option3. On the selection from user the empty table Tab will ...
0
votes
3answers
63 views

Need help on using a few excel formulas together

I have some particular data in sheet1 and some other data in sheet2. I need to compare a specific value(Var1) from sheet1 and return a specific value from the sheet2, and return an output for the ...
0
votes
0answers
273 views

Fill a web form with data from excel (macro)

I am new to VBA and I am struggling to find a solution for my problem. I have an excel database with UNs and PWs for a number of profiles. I also have an administrator UN and PW and each time I want ...
0
votes
0answers
32 views

Conditional filter in excel

In my stock, I have a column for showing location of items: I want to show specific floor instead of all during print out including blank/a b c d row with single click. Whenever I select All in ...
0
votes
1answer
221 views

Excel 2007 - Using combination of Countif and Indirect

I have numeric data in column P in 50 different sheets ( each sheet has different person name). I have one summary Sheet which has names of all the worksheets in column A. In summary sheet column B ...
0
votes
2answers
46 views

Excel 2007 - refering value from other worksheet in another function in excel

I have two worksheets. I have data in Sheet2 in column A for which i want to use average function. In sheet1 i have values in only two cells. B1 cell has value 5 and B2 cell has value 15. Using these ...
0
votes
1answer
140 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 ...
0
votes
2answers
40 views

“#REF!” appears in cell after referred-to cells are pasted in

On Office 2007's Excel on Win7, I have a file with a formula like AVERAGE(A29:A33) in cell A34. I then copy four vertically-adjacent number-containing cells and paste them into cells A29:A33. At ...