$$Excel-Macros$$ Excel Question

2014-11-19 Thread Mandeep Baluja
Hi all! Here I got a question on the another community. He wants to achieve maximum in other column for example first 7 in between 3,2,6,7 and then next range max 8 in between 8,2,3 . I have prepared the formula for this but want to know some more suggestions. :) Que : - I have some numbers ze

Re: $$Excel-Macros$$ excel question

2013-12-10 Thread Pravin Gunjal
This also can be used: =COUNTA(D2:D15) Regards Pravin Gunjal. On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes wrote: > You are a GENIUS!!! > > > On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote: > >> Are you looking for this? >> >> =COUNTIF($D$2:$D$15,"S") >> >> Regards, >> Sam Mathai Cha

Re: $$Excel-Macros$$ excel question

2013-11-02 Thread Robert Barnes
You are a GENIUS!!! On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote: > Are you looking for this? > > =COUNTIF($D$2:$D$15,"S") > > Regards, > Sam Mathai Chacko > > > On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes wrote: > >> >> >> First of all thank you. I am, at best, a novice user of exc

Re: $$Excel-Macros$$ excel question

2013-11-01 Thread Sam Mathai Chacko
Are you looking for this? =COUNTIF($D$2:$D$15,"S") Regards, Sam Mathai Chacko On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes wrote: > > > First of all thank you. I am, at best, a novice user of excel. Even though > we use it for its most basic functions daily. I am attempting to go to the > ne

$$Excel-Macros$$ excel question

2013-11-01 Thread Robert Barnes
First of all thank you. I am, at best, a novice user of excel. Even though we use it for its most basic functions daily. I am attempting to go to the next level with an inspection form that we use by allowing employees to use tablets to complete. On the inspection we enter an s for satisfactor

Re: $$Excel-Macros$$ Excel question

2011-07-07 Thread AK
t; >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *AK >> *Sent:* Thursday, July 07, 2011 10:06 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Excel question >> >> ** ** >&g

Re: $$Excel-Macros$$ Excel question

2011-07-07 Thread ashish koul
tion* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *AK > *Sent:* Thursday, July 07, 2011 10:06 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Excel question > > ** ** > > Hi Experts,*

RE: $$Excel-Macros$$ Excel question

2011-07-07 Thread Rajan_Verma
End Function From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of AK Sent: Thursday, July 07, 2011 10:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel question Hi Experts, Could you please look into my excel query. I have the multi

Re: $$Excel-Macros$$ Excel question

2011-07-07 Thread Haseeb Avarakkan
Hi, C2 copy down. =IFERROR(INDEX(D$1:SF$1,MATCH(TRUE,INDEX(ISNUMBER(1/D2:SF2),),0)),"Not Started") HTH Haseeb -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : ht

Re: $$Excel-Macros$$ Excel question

2011-07-07 Thread Vasant
Pls find a UDF Public Function GetFirstRevenueDate(Rng As Range) For Each cls In Rng.Cells If cls.Value > 0 Then Dt = Cells(1, cls.Column) GetFirstRevenueDate = Format(Dt, "dd-mmm-") Exit Function End If Next End Function File attached. On Thu, Jul 7, 2011 at 10:05 PM, AK wrote: > Hi Exper

$$Excel-Macros$$ Excel question

2011-07-07 Thread AK
Hi Experts, Could you please look into my excel query. I have the multiple columns filled with some Revenue values. I need the first month when the revenue started flowing in (anything which is greater than 0). For example – for the Account Name: Mohan, We started recognizing the revenue from ‘