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 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.
--
--
Some
Dave,
This worked beautifully. Thanks so much!
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, August 16, 2010 2:56:11 AM
Subject: RE: $$Excel-Macros$$ Need to remove Alt + Enter
Hi Nadine,
Your original sample data had no spaces in it, s
Dave,
Can I trouble you for an example? I'm not sure how the COUNTIF would work
here. Thanks.
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Wed, August 18, 2010 7:34:17 PM
Subject: RE: $$Excel-Macros$$ Unique id to name
Hi,
You can use CO
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
To: MS EXCEL AND VBA MACROS
Sent: Wed, August 18, 2010 8:13:21 PM
Subject: Re: $$Excel-Macros
-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 wrote:
Unfortunately a pivot table won't work here as I need the formula on each line
in the worksheet.
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 in
of 567891,
yet you 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
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 10:50:51 AM
Subject: $
Can this work having about 21 SUMIF formulas in one cell?
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 10:26:55 AM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Paul: Thank you! Your "a" solution works and I'm s
BA function to handle the calculations!
Paul
____
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 1:45:31 PM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Can this work having about 21 SUMIF formulas in one cell?
__
I have a sheet that has 2 columns of data. The second sheet has those same
columns and another column. I need the max of sheet 2 col C if:
Sheet 2 col A contains sheet 1 cell A2 AND
Sheet 2 col B contains sheet 1 cell B2.
Sheet 1:
Col A Col B Col C
AB1
Sort the data (column A ascending & Column C Descending)
for example you are having data from A2 to C100
In sheet 2, column C use Vlookup function (in C2)
=vlookup(a2, $A$2:$C$100, 3, false)
Regards,
Kishan Redyd, K
On Sep 3, 10:48 pm, None wrote:
> I have a sheet that has 2 column
sheet 2, column C use Vlookup function (in C2)
=vlookup(a2, $A$2:$C$100, 3, false)
Regards,
Kishan Redyd, K
On Sep 3, 10:48 pm, None wrote:
> I have a sheet that has 2 columns of data. The second sheet has those same
> columns and another column. I need the max of sheet 2 col C if:
>
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 n
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 calle
a working
formula 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 wrote:
> Hi there. I need some help finding the next number but there's a twist.
> Attached is a file tha
most likely not be what you were looking for.
Paul
>
>From: None
>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 need a
mp;F2
then, in column "I":
=IF(NOT(ISNA(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
>To: excel-macros@googlegroups.c
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 ma
x27;t really understand what you ask for
On Fri, Nov 19, 2010 at 11:45 PM, None wrote:
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 ne
Sent: Fri, November 19, 2010 9:25:31 AM
Subject: Re: $$Excel-Macros$$ Need a MAXIF type formula
Check the attachment see if it works for you
On Fri, Nov 19, 2010 at 10:27 PM, ratu elissa wrote:
i don't really understand what you ask for
>
>
>
>On Fri, Nov 19, 2010 at 11:45
21 matches
Mail list logo
