Hi,
Open below link & click join this group.
http://www.discussexcel.com/
Regards,
Kuldeep Singh
On Thu, Aug 23, 2012 at 10:14 AM, अनिल नारायण गवली
wrote:
> To post to this group, send email to excel-macros@googlegroups.com.
>
> Regards,
> Gawli Anil
>
> On Wed, Aug 22, 2012 at 8:10 PM, Anil J
To post to this group, send email to excel-macros@googlegroups.com.
Regards,
Gawli Anil
On Wed, Aug 22, 2012 at 8:10 PM, Anil Jangra wrote:
> Hi,
>
> I want to joing this group and would like to recieve emails from this
> group.
>
> I am working with AonHewitt as Data Analyst. I am an beginner i
Gr8 work rajan .:)
Regards,
Gawli Anil
On Wed, Aug 22, 2012 at 9:34 PM, Hilary Lomotey wrote:
> i love the chart, nice work bro
>
>
> On Wed, Aug 22, 2012 at 3:35 PM, Kuldeep Singh wrote:
>
>>
>> Hi Sir,
>>
>> It's really good.
>>
>> Regards,
>> Kuldeep Singh
>>
>>
>> On Wed, Aug 22, 2012 a
Dear NOORAIN,
Thanks for reply,I used this formula but not work it show #VALUE! .I think
formula is correct but how to use in it offset.why formula not work?
On Wed, Aug 22, 2012 at 10:00 PM, NOORAIN ANSARI
wrote:
> Dear Amar,
>
> pls Try it..
>
>
> =SUMPRODUCT((List=OFFSET($A$2,$AI$3,0))*($B$3:$
I THINK the problem is that they're re-registering with a different gmail
account.
So, even though one account gets banned,
they simply open another and send it again.
Which means that it's POSSIBLY not a legitimate job posting, but simply
trying to get your personal info!
I guess we just have t
The babok guide that Amit has given is quite helpful!
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Mangesh Vimay
Sender: excel-macros@googlegroups.com
Date: Wed, 22 Aug 2012 19:28:20
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Business an
Dear Ayush Sir,
Please ban this user. This user again & again post jobs in this Group.
Regards,
Kuldeep Singh
On Wed, Aug 22, 2012 at 8:48 PM, karan bhatia
wrote:
>
>
> *Please respond to **ka...@hmgamerica.com*
>
> *Position: *Java Developer* *
>
>
>
> *Location:* Cleveland, Ohio
>
>
>
> *Dura
Dear Amar,
pls Try it..
=SUMPRODUCT((List=OFFSET($A$2,$AI$3,0))*($B$3:$B$50=AK$7)*($C$2:$N$2=$AJ8)*($C$3:$N$50))
On Wed, Aug 22, 2012 at 2:54 PM, amar takale wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alre
Dear Rakesh,
Please use it..
*=INDEX(column2,MATCH(A2,column1,0))*
On Wed, Aug 22, 2012 at 5:29 PM, Rakesh Kumar Sharma wrote:
> Hi Noorain,
>
> If i want to pick data of column2 then how it works?
>
> See attachment.
>
>
> On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI
> wrote:
>
>> Dear R
i love the chart, nice work bro
On Wed, Aug 22, 2012 at 3:35 PM, Kuldeep Singh wrote:
>
> Hi Sir,
>
> It's really good.
>
> Regards,
> Kuldeep Singh
>
>
> On Wed, Aug 22, 2012 at 9:02 PM, wrote:
>
>> Nice creativity Rajan
>>
>> Sent from BlackBerry® on Airtel
>> --
>>
Very Nice and Good work Rajan
Regards
prince
On Wednesday, August 22, 2012 7:32:24 PM UTC+5:30, Rajan_Verma wrote:
>
> * *
>
> *Hi Group,*
>
> * *
>
> *Just sharing hook chart , see the attached sheet*
>
> * *
>
> * *
>
> **
>
> * *
>
> *
> any comment and suggestion are welcome ,*
>
> *You can a
Hi Sir,
It's really good.
Regards,
Kuldeep Singh
On Wed, Aug 22, 2012 at 9:02 PM, wrote:
> Nice creativity Rajan
>
> Sent from BlackBerry® on Airtel
> --
> *From: * "Rajan_Verma"
> *Sender: * excel-macros@googlegroups.com
> *Date: *Wed, 22 Aug 2012 19:32:24 +0530
>
Nice creativity Rajan
Sent from BlackBerry® on Airtel
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Wed, 22 Aug 2012 19:32:24
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hook Chart
Hi Group,
Just sharing hook chart
Hi,
I want to joing this group and would like to recieve emails from this group.
I am working with AonHewitt as Data Analyst. I am an beginner in Excel VBA
and want to learn it deeply.
Please add my email ID.
Regards,
Anil Jangra
Data Analyst,
Aon Hewitt,
North America, RFM
--
Join official fa
Hi Friends,
Can you provide me same kind of Books on "Data Analysis by using Excel
2007/2010".
Thanks
On Sun, Aug 19, 2012 at 2:50 PM, Amit Desai (MERU)
wrote:
> Check the below link, the same covers latest book BABOK version 2
> (Business Analyst Body of Knowledge) by IIBA.
>
> ** **
>
> h
Ms. Exl Learner,
G8
Working absolutely Fine.
Thanks,
Santosh Singh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ms-Exl-Learner .
Sent: Wednesday, August 22, 2012 1:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a Sug
I no longer have it. Send your file direct to ME along with the solution I
proposed.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Wednesday, August 22, 2012 8:00 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Search &
Hi All Experts
Pls find solution Milk data sheet for formula.I think it is use sum product
formula.
Pls help me
Warm Regards
Amar
-- Forwarded message --
From: amar takale
Date: Wed, Aug 22, 2012 at 2:54 PM
Subject: Required Challenging formula
To: excel-macros@googlegroups.com
Don Guillett Sir,
Actually I cant understand this code,I put this code but not show result.
Can you explain me or put code in this sheet & send me.
Thanks
Amar
On Wed, Aug 22, 2012 at 5:59 PM, dguillett1 wrote:
> My guess is that you didn’t like my solution.
>
> Don Guillett
> Microsoft Excel
My guess is that you didn’t like my solution.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Wednesday, August 22, 2012 1:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)
=IFERROR(VLOOKUP(A2,'column1 data'!A:B,2,0),"")
Regards,
Kuldeep Singh
On Wed, Aug 22, 2012 at 5:29 PM, Rakesh Kumar Sharma wrote:
> Hi Noorain,
>
> If i want to pick data of column2 then how it works?
>
> See attachment.
>
>
> On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI
> wrote:
>
>> Dea
Hi Noorain,
If i want to pick data of column2 then how it works?
See attachment.
On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI wrote:
> Dear Rakesh,
>
> See attached sheet.
>
>
> On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
>> Hi Noorain,
>> As y
You're Welcome
---
Ms.Exl.Learner
---
On Wed, Aug 22, 2012 at 4:26 PM, Manoj Kumar wrote:
> Many many Thanks for solution...
>
>
> On Wed, Aug 22, 2012 at 4:23 PM, Ms-Exl-Learner . <
> ms.exl.lear...@gmail.com> wrote:
>
>> For Macro Solution Try the below
Many many Thanks for solution...
On Wed, Aug 22, 2012 at 4:23 PM, Ms-Exl-Learner .
wrote:
> For Macro Solution Try the below code
>
> Option Explicit
> Sub SplitNumber()
> Dim i As Long, j As Long, EndCol As Long
>
> EndCol = Range("A2").CurrentRegion.Rows(1).Cells.Count
>
> For i = 1 To EndCol
>
For Macro Solution Try the below code
Option Explicit
Sub SplitNumber()
Dim i As Long, j As Long, EndCol As Long
EndCol = Range("A2").CurrentRegion.Rows(1).Cells.Count
For i = 1 To EndCol
For j = 1 To Cells(2, i).Value
Cells(3 + j, i).Value = Cells(3, i).Value / Cells(2, i).Value
But in next coll my range is increasing
Regard
Manoj
On Wed, Aug 22, 2012 at 3:49 PM, Ms-Exl-Learner .
wrote:
> Type or copy and paste the below formula in A4 cell.
>
> A4 cell
> =A$3/5
>
> Drag the A4 cell formula upto A8 cell and drag it to the right if required.
>
> --
Dear Pankaj,
See below links. I hope it will help you.
http://www.cpearson.com/excel/debug.htm
http://www.ozgrid.com/VBA/debug.htm
http://www.excel-vba-easy.com/vba-basic-debug-macro.html
Regards,
Kuldeep Singh
On Wed, Aug 22, 2012 at 3:44 PM, pankaj gmail account
wrote:
> Dear All,
>
> Please
Type or copy and paste the below formula in A4 cell.
A4 cell
=A$3/5
Drag the A4 cell formula upto A8 cell and drag it to the right if required.
---
Ms.Exl.Learner
---
On Wed, Aug 22, 2012 at 3:41 PM, Manoj Kumar wrote:
> i need the formula witch divide
Dear All,
Please guide hw to Debug VBA Programs
Regards
--
Pankaj Kumar
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
i need the formula witch divide randomly A3, in cell A4 to A8
when i add A4 to A8 it show 200..
On Wed, Aug 22, 2012 at 3:01 PM, Pravin Gunjal wrote:
> *Dear Mr. Manoj*
> *
> *
> *Type the value first to get the total.*
> * *
>
> *With regards,
> **Pravin Gunjal**
> *
>
>
> On Wed, Aug
*Dear Mr. Manoj*
*
*
*Type the value first to get the total.*
* *
*With regards,
**Pravin Gunjal**
*
On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar wrote:
> Hi,
>
> Please help me to collect data in attached file..
>
>
> Regard
> Manoj
>
> --
> Join official facebook page of this forum @
Hi Manoj,
Please more explain.
Regards,
Kuldeep Singh
On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar wrote:
> Hi,
>
> Please help me to collect data in attached file..
>
>
> Regard
> Manoj
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n
Hi,
Please help me to collect data in attached file..
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urg
Try This...
=SUMPRODUCT(('Jan12'!F4:F60={"Corrective","Implementation","Training","Information"})*('Jan12'!H4:H60="DATA")*('Jan12'!G4:G60="Completed"))
Let us know in case of any further assistance.
---
Ms.Exl.Learner
---
On Fri, Aug 17, 2012 at 10:13 PM,
Dear Santosh,
Please share a workbook with formula
On Fri, Aug 17, 2012 at 10:13 PM, Santosh Kumar Singh wrote:
> Dear Group,
>
> Please suggest
>
> How we can reduce this formula (if Possible)
>
> ** **
>
>
> =COUNTIFS('Jan12'!F4:F60,"=Corrective",'Jan12'!H4:H60,"=DATA",'Jan12'!G4
36 matches
Mail list logo
