Hi all. Attached is a workbook that contains 2 sheets. The first is the list
that the 2nd sheet will refer to. I'd like a formula in col C on sheet 2 that
looks up each combination and determines if the combination is valid. Does
anyone have any ideas?
Thanks.
Nadine
--
I need a MaxIf type of formula that will work with Excel 97 and Excel 2003.
Thanks.
I have two worksheets that have similar data in them for Col A-C. Sheet 1 has
numbers in col D. What I need in Col D on Sheet 2 is a formula that will find
the max of this column if the first three columns
(VLOOKUP(H2,H$1:I1,2,FALSE))),VLOOKUP(H2,H$1:I1,2,FALSE),
IF(NOT(ISNA(VLOOKUP(G2+1,I$1:I1,1,FALSE))),MAX(I$1:I1)+1,G2+1))
and copied H and I down through the list.
give it a shot..
Paul
From: None n8dine4ma...@yahoo.com
To: excel-macros@googlegroups.com
Sent: Wed, October 6, 2010 5:27:43 PM
, the values would most likely not be what you were looking for.
Paul
From: None n8dine4ma...@yahoo.com
To: excel-macros@googlegroups.com
Sent: Tue, October 5, 2010 5:42:29 PM
Subject: Re: $$Excel-Macros$$ Re: Need next number with a twist
Let me try to explain a little better. Col H is where I
that will either give the same transaction number if a key
match is found otherwise give you the next available transaction
number.
On Sep 28, 10:16 pm, None n8dine4ma...@yahoo.com wrote:
Hi there. I need some help finding the next number but there's a twist.
Attached is a file that shows what I
Hi there. I need some help finding the next number but there's a twist.
Attached is a file that shows what I need.
There's a sheet titled Transactions where the data is continually added to
and
the order cannot be changed so sorting the data is out of the question. The
next sheet is called
I have a list of dates in one sheet.
Col A = Invoice Number
Col B = Payment Date
There will be multiple rows for the same invoice number as payments are made
against it until it is paid in full.
Some of these rows will contain dates and some won't.
The next sheet has the unique list of invoice
included them in your calculation.
this isn't the best way... I'd probably write it as VBA and loop through...
hope this helps,
Paul
From: None n8dine4ma...@yahoo.com
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 10:50:51 AM
Subject: $$Excel
Forgot to include the subject line. Sorry
I need a multiple SUMIF type formula.
In the attached book, there is a Log sheet that needs the formula in cells M2
and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for
the last 6 digits
Unfortunately a puvot table won't work here as I need the formula on each line
in the worksheet. Otherwise your suggestion would be a great one.
From: Soni.Rajender soni.rajen...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Wed,
Subject: Re: $$Excel-Macros$$ Unique id to name
This should help.
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey Company
http://www.facebook.com/Harmeeet
On Thu, Aug 19, 2010 at 7:18 PM, None n8dine4ma...@yahoo.com wrote:
Unfortunately a pivot table won't work here as I need the formula
I have a file that has 2 columns. The first contains an alpha numeric id and
the
second contains the name. Is there a way to find out if the id is associated
to
more than one name? Thank you.
--
--
12 matches
Mail list logo