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
31 views

How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...
1
vote
1answer
34 views

Excel: Write a 1 or 0 value if condition is met

Sorry if this has already been posted, but I just started today playing with Excel macros and I need a hand. I have a data column with values and I would like that if the conditions were met, the ...
0
votes
0answers
10 views

Adding data table onto another table using matching identifiers

How do i add fields in one data table onto another data table using matching identifiers in excel. I have two data tables in separate sheets that I want to merge adding all of the fields from the ...
0
votes
0answers
10 views

open excel using .bat when excel error “file in use” is returned

I have created a .bat file to open Excel, then my Excel workbook which contains a macro which runs on open, all on a scheduled task timer. The problem is that occasionally the Excel files are not ...
0
votes
1answer
41 views

Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well. The ...
1
vote
1answer
20 views

fit a table in a middle of an excel sheet

I have a table in a sheet like this: I want to place the table in the middle of page. but the number of column is odd (5) and the number of column in the sheet is even (8). there is 2 cols after ...
0
votes
2answers
45 views

Excel help - extract info from middle of cell

Is it possible to take the words 'each', 'Any 2 for', 'kg', etc... out of these cells and put them into another cell... leaving only the $x.xx price so it can be sorted. Examples for above are: 1) ...
-2
votes
0answers
22 views

Multiple Function [closed]

I need a similarity function. But I need Column A, row 1 to be an assigned number (i.e. 11013) which is then spread among many worksheets where A2,A3, A4 usually show differing results dependent on ...
1
vote
0answers
17 views

Excel shortcut to set font size and bold

I have an Excel budget spreadsheet that as items (cells with numbers) are paid, I make the font bold and size 14. Is there a way to create a shortcut to do this with one keyboard move instead of ...
0
votes
1answer
40 views

How to select only the first max value in excel? [closed]

I need to make an operation on a cell and I choose the one with the maximum value. If it happens that there are more than one cell with the max value I need to do the operation only to the first one, ...
1
vote
0answers
23 views

Opening a file with a # in its path using the default application from Excel 2007

I have a pdf file which is located at "D:\some\#folder\filename.pdf". And want to open it from an Excel worksheet by clicking on a hyperlink (or something similar). Just creating a hyperlink does not ...
0
votes
1answer
40 views

How do I Reference all non-blank cells after row A6 for a Formula

I want to use the following formula: INDEX(A6:A94,MODE(MATCH(A6:A94,A6:A94,0))) Except the exact number of rows is ambiguous (imported using VBA). How can I reference all non-blank cells starting ...
0
votes
1answer
40 views

How do you format numbers in Excel for Indian Currency (Rupees)?

Currently the Excel default formatting is: 1,000,000 500,000 How do you format the number to use the comma separator (,) like this 10,00,00,00 50,00,00 This is is how Indian Currency (Rupees) ...
0
votes
1answer
34 views

How to prepend numbers to typed values in column [duplicate]

I need to manually enter a list of six-digit codes in a column. Each code starts with the same two-number prefix, 03. e.g.: 030144 030289 030283 Is there a way that I can type just the last four ...
0
votes
1answer
20 views

How to get a formula to extend to new cells depending on pivot table

I have a pivot table with some formulas using the data from the pivot table to the side of it. My problem is that if I add a filter, say city, so that the pivot table extends down, the formulas to the ...
1
vote
2answers
29 views

DATEVALUE() gives different values for similar data

In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM So, to get the date from that column, I created another column and used the formula =DATEVALUE(CONCATENATE(MID(D2,5,2)," ...
2
votes
1answer
35 views

Not getting desired output with VLOOKUP - Need assistance

I have Table 1, which looks like this - A1 B1 C1 1 X Date11 2 Y Date12 3 Z Date13 I have another table, Table 2, that looks like this - A2 B2 C2 1 M Date21 2 N Date22 3 X ...
0
votes
1answer
27 views

How to keep pivot table from expanding into occupied rows and columns

I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations ...
-1
votes
1answer
38 views

Excel Vlookup range or if function

I have been struggling to find a formula that works for the example below (see question mark!). What i am trying to do is merge 2 datasets. The problem is that the common identifiers are not always ...
0
votes
1answer
36 views

What formula would you use to add up a column based on results from two drop down menus? [duplicate]

I would like to calculate a column based on selections from two other columns with drop down menus. For example : In one column, "C" you have 3 options (A team,B team,C team), In column "F" you ...
1
vote
1answer
35 views

Excel SUMIFS based on two criteria

I would like to total a list of minutes based on two criteria to make a graph after the data is calculated. The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus. I ...
2
votes
1answer
43 views

How can I use Excel to monitor my payable?

Here's what I wanted to happen, I have five columns Supplier Amount Payment Supplier1 Supplier2 When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...
1
vote
1answer
34 views

Need to add newline(s) and space(s) inside a cell in Excel

I have data in an Excel cell which is delimited by ,. For example: abc,bde,fgh. I used the formula =SUBSTITUTE(A2, ",", CHAR(10) & CHAR(13)) to change the commas to line breaks. Therefore, the ...
0
votes
1answer
48 views

Excel countif formula that will subtract from another number if cell contains certain values

I am dealing with job applications for 8 different sites. People can apply for any combination of sites i.e 1 of them, 2 of them, all of them. Some applicants have specifically said they don't want ...
1
vote
1answer
21 views

Summing up values from a user-defined range

I have a spreadsheet from January 1 to present. and I needed to sum up the value parallel corresponding from the range which the user defines. For example: in Column A are the dates January 1 - ...
7
votes
2answers
92 views

Conditional concatenate cell content across rows

I have a worksheet with thousands of rows which contain a unique ID A, and one 3 different error codes M. Each individual ID may have 1, 2 or 3 errors. They will always be in the same order. I have ...
0
votes
1answer
31 views

Copy multiple Rows and paste using formula [closed]

In Excel, columnA I have values which need to be tripled in columnB So I currently have A 1 val1 2 val2 3 val3 I'd like each value to be tripled in column B, such as A B ...
2
votes
1answer
26 views

How to prevent office 2007 from opening an *.xls file?

I recently installed Office 2007, parallel to Office 2003, so they coexist :) The thing I didn't anticipate is, that Office 2007 will bruteforce its way around. I don't want it to open old (*.xls - ...
0
votes
1answer
47 views

Microsoft Excel 2010 if(or(and I am confused

I am trying to query two cells by using If function but unfortunately have no luck. I will give you an example below. Please let me know how I can solve this issue. If C2="Car" and D2="Toyota_Mazda" ...
0
votes
0answers
11 views

Finding all entries if one is less than 10

I have two columns. One contains names the other contains times in hours and minutes. There are about five times as many hours and minutes as there are names. So each name has about five entries. ...
0
votes
0answers
47 views

Excel: Find duplicates among 2 colums

Giving an excel file with 2 columns: A: 5000 numbers (some repeated) B: 525 unique numbers I want to know if for each number in A there is a instance of that number in B. Meaning: for A1, is ...
0
votes
2answers
58 views

Excel - Manipulating data in awkward format

I have a dataset that I want to analyse, but it is in quite a strange format. See below: > Account_Details Account_Name > account # 1 client name > product 1 name ...
1
vote
1answer
20 views

Cell references in formulas keep moving with old data in Excel

When I update Excel to the latest figures my formulas keep moving with the old data. I have already tried using absolute and or relative references like $A$1, $A1, A$1, and A1. I've also tried using ...
0
votes
0answers
14 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
1answer
20 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
1answer
13 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
1answer
50 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
1answer
37 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
1answer
26 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
3answers
67 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
1answer
20 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
1answer
50 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
0answers
52 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
1answer
31 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
1answer
25 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
2answers
29 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
2answers
36 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
1answer
82 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
1answer
25 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
1answer
114 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 = ...