0
votes
1answer
29 views

Search from bottom with multiple criteria

I am trying to search a data table in excel and find the bottom most row that meets a specific criteria. I thought I could use this LOOKUP trick but it only returns a #DIV/0 error. This is what I ...
1
vote
1answer
165 views

Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...
0
votes
3answers
69 views

Excel Using Reference for Worksheet names [duplicate]

I've looked around to try and resolve this, however I am unfamiliar with the coding. Here's my line of code, ='[WorkBook]BOM'!G6 What I want to do is make the Workbook call to a cell so I can mass ...
0
votes
0answers
42 views

MIcrosoft excel 2003 auto populate cells

What I would like is input text into a cell say A1 and I want that text to then be duplicated in cell D1. But I can not type the formula into D1 itself i.e. no =a1. Is this possible? Thanks
2
votes
1answer
930 views

Is there an Excel formula that can conditionally sum rows based on column headers?

I need to be able to put a formula into the last cell of a row (shown by = in the image) that totals the values in that row that don't have a cell with the text 'Done' at the top of the relevant ...
2
votes
1answer
185 views

how to determine which values in a given set of cells will add up to a numerical range

In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers: 1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16 26 ...
1
vote
1answer
175 views

How do I create a list of phone numbers for people whose reference numbers appear in two columns?

I have two sets of data in columns A & B and also in columns C & D. Some of the content in column C & D does not appear in columns A & B: A = reference numbers 00001, 00002, 00003, ...
-2
votes
2answers
271 views

Nested IF formula

I have: in *Column F* in *Column S* F2 Monday S2 Orange F3 Tuesday S3 Mango F4 Wednesday S4 Grape F5 Thursday S5 Pawpaw F6 Friday ...
0
votes
1answer
8k views

If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?

I work with Excel 2003. If cell B1=1 then DELETE cell A1, and if cell B=0 then UNCHANGED. How can I do this? Example: http://oi33.tinypic.com/mwsm03.jpg Many thanks :)
0
votes
1answer
1k views

Excel Time Subtraction

I think there is a way around the time subtraction issue I have in Excel. The problem is that when the time in cell F (for example 11:29am) is less than the one in cell A (for example 11:30am), the ...
4
votes
2answers
4k views

Restrict and validate date format in Excel

I'm trying to put together a 'Data Validation' formula which restricts the user to entering a date in the following format: dd-mm-yy. From the research I've done, I've come across what I thought ...
0
votes
2answers
290 views

How to clear all value cells in an entire 2003 Excel workbook by one go?

How can I clear all value cells in an entire 2003 Excel workbook by one go? I could do one sheet by going to special functions, however, if a file is composed of many sheets, it would take a lot ...
0
votes
2answers
631 views

Excel 2010 formula conversion to Excel 2003

I am by no means overly proficient with Excel, I know enough to do the basics. After much forum and soul searching I had come up with the following formula, which I will discuss what it is supposed ...
0
votes
2answers
149 views

Compute the first digit of an integer in Excel

I have a spreadsheet with column B having integers. I want to get the first digit of each entry in column B in the corresponding row of column C.
0
votes
2answers
223 views

Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting Cell Value is equal to =G7, colour ...
0
votes
2answers
1k views

Remove duplicate rows in excel when not all the columns are the same

How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same? I believe the picture explains what I need, but I can probably supply a ...
2
votes
1answer
92 views

In Excel, how do I highlight all rows that do not contain “,2”?

I'm verifying the FormatCurrency function is written properly in ASP code and I put everything in Excel from "find results". I want to highlight only the ones that do not contain ",2" in them. ...
0
votes
2answers
51 views

copy worksheet to several workbook

I created a worksheet/spreadsheet with functions and references to cells in other worksheets/spreadsheets within same workbook to create a report of other worksheets within the same workbook. I have ...
0
votes
2answers
138 views

Excel Multiple Conditions Summing

I have Column A to A1600. In that column I have two project names "CP" and "GFI", in column B I have Project Phase 1-8, in column C I have the hours worked in each phase. The projects intertwine so ...
1
vote
1answer
316 views

How to calculate the total sum of hours with automatic filter

I have an Excel sheet where I sum hours to get the total amount of my work. It works without problems, but if I add an automatic filter I'd like the calculations to be done only on the portion of ...
2
votes
1answer
761 views

Random Excel bug when referencing a different sheet

I am getting a very strange error anytime I try to use a formula pointing to a cell in a different sheet from the active one (even as simple as "=Sheet2!A1"). This started happening all of a sudden, ...
2
votes
5answers
1k views

Excel not properly recalculating values

I have an Excel sheet with values in it (this sheet is generated by a custom perl script, but I don't think that's where the problem lies). In it, I have a formula: ...
1
vote
1answer
8k views

Excel: Calculating working hours between two dates

Summary: I know that the function NETWORKDAYS can be used to find the number of business days (=excluding weekends and holidays) between two dates. But what if I want to know the number of business ...
11
votes
1answer
28k views

How do I put logical operators in an Excel =IF Formula?

I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like... =IF(myval>=minval & myval <= maxval, "OK", "Not OK") But this ...
1
vote
2answers
88 views

I hyperlinked a cell in excel 2003, formula issues?

I have a budget spreadsheet using excel 2003. I have My deposit, then all of my bills, the total, then a cell that has the difference(between the amount of deposit and the total of the bills). The ...
9
votes
1answer
11k views

allow two possible values in a Excel cell

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell. How could I do this?
1
vote
3answers
802 views

Excel select column

In excel, if I want to perform a function with the column to the left, how do I go about this?
2
votes
4answers
10k views

Using two conditions with a SUMIF function in Excel 2003

For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2. That will basically summarize all the values on my ...
3
votes
4answers
5k views

Excel formula to display a string of text and numbers

I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx data1 is in column A and data2 is in column B. the format of data1 needs to be 5 numbers (sometimes ...
0
votes
3answers
1k views

Sum Column, but only Filtered Rows

I have a large flat file of a bunch of ungrouped primary key values. I want to filter on a key and populate cell A1 with the value selected from the dropdown list. In the end, I want to see a sum of ...