|
LOOKUP two data sets for match - return 1 or 0 - Please help!
I have a data set (numbers) say B1 to B10. I have another data set
(numbers) E1 to E10. I want to compare a value in set E with Set B and
return 1 if there is a match. If not I want to return 0. I want to do
this for the entire set E.
Please help!
Thanks in advance,
Jay
...
|
2 |
26.09.2006 11:10:01 |
|
|
How to code it in excel?
Copy of message from Excel General Question - 9/26/2006 1:22 AM PST
Does anyone know on how to code on following condition in this group?
[row 1] a blank row
[row 2] 10, which should be equal to the last value in row 3
[row 3] 10
[row 4] a blank row
[row 1] a blank row
[row 2] 23, which should be equal to the last value in row 4
[row 3] 23, which should be equal to the last value in ...
|
1 |
26.09.2006 10:59:02 |
|
|
why doesn't this formula work?
I keep getting #VALUE! message. Why doesn't this formula work? What am I
missing? There is no text in any of the fields, only numbers. HELP!!
=B5-(D5:G5)...
|
5 |
26.09.2006 10:33:01 |
|
|
Creating Dialogue Box
This is what I want to accomplish but I do not know how. I am new at this.
In cells D-I, I want to be able to click on the cell and bring up a dialogue
box that consists of a list of checkboxes, which I can check off as
completed, tasks if you will. I would also like the option of a comments box
as a part of this dialogue box.
If you can understand at all what I am trying to get at, ...
|
2 |
26.09.2006 09:39:29 |
|
|
Query Problem
Dear all,
I've a pivot table created by getting data externally. The data were
actually from several worksheets in another workbook. The data were joined
together by using MS Query. The data in the first seven worksheets were
successfully displayed in the pivot table. However, the data in the eighth
worksheet were 3/4 displayed in the pivot table and the rest were missing.
The same si...
|
1 |
26.09.2006 08:57:01 |
|
|
If a Row is blank
I would like a formula that will indicate if a row is blank or not.
this function in cell K2 {if A2:J2 is null, then put "Remove", else "Keep".}
so if that range is blank then put "Remove" if C2 has a value then put
"Keep" in K2 cell
How would I do this?...
|
14 |
26.09.2006 08:54:48 |
|
|
How can I find the greatest possible sum within 12 months? A newbie...
hello,
was wondering whether anyone can give me any pointers as to how to
identify the greatest possible sum from a column, within a 12 month
period (in excel 2003, sp2).
basically, i have the following set up, in two columns (example):
amounts / date
13$ / 1 October 2004
5$ / 7 October 2004
13$ / 11 October 2004
29$ / 5 December 2004
23$ / 9 December 2004
5$ / 30 February 2005
5...
|
17 |
26.09.2006 08:46:34 |
|
|
Dependant Data Validation not sorted
Hi
I have a worksheet that contains legacy data that is being cleaned to
conform to specific formats and conventions. I have another worksheet that
uses this cleaned data to build a new database row. I want to put a drop
down list in my database row worksheet that lists only the cleaned data.
For Example
Column A is the data to be cleaned
Column B contains a formula that tells the en...
|
4 |
26.09.2006 08:25:09 |
|
|
Vlookup and few more questions :)
Hello
I have a problem with vlookup function. I have three columns with
numbers a one column with a date in my excel table. Smth like this:
A B C D
11 12 13 09.12.06.
21 22 23 09.13.06.
31 32 33 09.15.06.
41 42 43 09.18.06.
51 52 53 09.17.06.
I need a formula that will check columns A to C for a certain number
(example: 32) and return the date from the matching cell from column...
|
8 |
26.09.2006 04:35:01 |
|
|
Pivot Tables
1) I have 2 fields in the Row section of the Pivot Table. Is there a way to
set it up so you don't have a total at the end of each value change in the
first field of the row section? I dont want any subtotals totals; just the
grand total.
2) Is there a way to tell the pivot table that on the columns not show the
blank or empty columns?
Thank you for your help,
Steven...
|
2 |
26.09.2006 04:34:45 |
|
|
IS THERE A DAILY MEDICATION DOSAGE LOG TEMPLATE ?
I'M LOOKING FOR A DAILY MEDICATION DOSAGE TEMPLATE FOR ONE MONTH AT A TIME.
IT SHOULD HAVE AT LEAST FOUR TIMES DAILY TO LOG DOSAGES....
|
2 |
26.09.2006 03:25:47 |
|
|
Unlocking protected cells
How can I unlock protected cells in a worksheet. It is an old one and I
do not have the old password.
--
Vanilla Skies...
|
1 |
26.09.2006 03:04:25 |
|
|
Complicated SUMPRODUCT
I need a formula to do the following:
If I2:AV2 = "Sht In Form" and I3:AV3 = "YES"
If I2:AV2 = "Sheet Present" and I3:AV3 = "YES"
What I really need is to count when the first set intersects the second set
and I'm not sure how to write that equation.
Thanks!
...
|
9 |
26.09.2006 02:56:19 |
|
|
Add a line in different places?
I have the code to add a line and it works great. However, I have 3
seperate command buttons to add a line in three seperate places. When
I change the code for say command button 2, it changes what I had input
for command button 1. How do I avoid this? TIA
--
umuckatie...
|
1 |
26.09.2006 02:25:01 |
|
|
After sorting the formula has the incorrect cell
I am using the following
=SUMIF(Taken!A$1:A$1999,Accrual!C6,Taken!D$1:D$1999). When I do a sort on
the data the Accrual!C6 remains cell C6 but it should be C10 because I added
information and then sorted and the formula is now on line 10.
Can anybody help??...
|
2 |
26.09.2006 02:15:30 |
|
|
Changing cell colors to correspond to different dates
I am trying to create a spreadsheet to help with medication inventory. I want
to have the cell change colors at different intervals to correspond to
different dates to give me different warning levels. For example, if a
medication is to exipre within 30 days, I would like the cell to change to
yellow and when it becomes 7 days or less I would like it to change to red. I
have not been abl...
|
3 |
26.09.2006 01:40:02 |
|
|
Limit on array formula
Is there a limit on how many cells in a worksheet can contain an array
formula. My sheet seems to cap out and not allow me to copy the formula down
after a certain number of rows....
|
4 |
26.09.2006 01:27:12 |
|
|
Match with tilda characater
Hello all,
I was trying to use the Match function in a VBA module (I hate VBA).
Match was failing unexpectedly.
I evenetually tracked down one issue (using Match in a normal worksheet
not in a module).
If the tilda ('~') character is in the cell I am trying to match I will
not get a match.
I tested this by:
1) making a small column array from A1:A6
a
b
c
d
e
f
2) In ce...
|
7 |
26.09.2006 01:26:31 |
|
|
Can I position a PAGE NUMBER side of a sheet?
Is it possible to position a PAGE NUMBER on the side of a sheet? If so, can
I position it sideways. My sheet is landscape and I want the page # to be
position on the left side horizontally. Thanks...
|
2 |
26.09.2006 00:33:15 |
|
|
How do I use the IF formula to flag me 21 days after the date?
I need to set up a spreadsheet that will flag me when it is 21 days past the
date I input originally. ...
|
2 |
25.09.2006 23:50:02 |
|
|
look up with multiple criteria and within a range
I need to look up information using multiple variables, one of those
variables using a range. I want the associate number returned based on where
they fall in the sequence and batch number. The following is an example:
SHEET ONE:
Sequence Start Sequence End Batch Associate
07953 07988 322 201
07989 ...
|
4 |
25.09.2006 23:23:01 |
|
|
Run time error
I am using the Beta Office 2007 and when I'm working on my spreadsheet to
enter data which has macros, it will work fine for a few minutes, then I get
an error which says Method 'Activate' of object 'Range' failed. Then I have
to shut completely down and open Excel again. Can anyone help me on this?
Thanks....
|
3 |
25.09.2006 23:18:18 |
|
|
How do I copy a group of worksheets with named ranges in Excel 200
I have 2 worksheets that I want to group and copy. In Excel 2003 when I
select the 2 worksheets and create a copy I'm prompted to create a new name
for the reference cells so the formulas don't refer back to the wrong
worksheet, in addition the grouped worksheets have formulas and values that
refer to each other and are automatically updated to the new copies names
(again so they don't...
|
3 |
25.09.2006 23:16:26 |
|
|
Rows and columns in 2007 1,048,576 rows by 16,384 columns
Seems the BETA version still has the 64,000 row limitation (?) or am I not
seeing something?...
|
2 |
25.09.2006 23:13:30 |
|
|
an if( statement looking for a specific phrase anywhere in a cell
I want to have an if( statement evaluate a cell and see if it contains a
certain text word or phrase, anywhere in the cell, and if so perform x , if
not y....
|
4 |
25.09.2006 23:13:10 |