sorry previous was wrong attachment. consider this one.
Regards
Amresh
On Tue, Sep 4, 2012 at 11:47 AM, Amresh Maurya wrote:
> Hi,
>
> Find the attached solution.
>
> use below formula
> =+COUNTIFS($B$2:$B$10,B2,$D$2:$D$10,">0")
>
>
>
>
> On Tue, Sep 4, 2012 at 11:28 AM, Muralidhar E wrote:
>
>
Hi,
Find the attached solution.
use below formula
=+COUNTIFS($B$2:$B$10,B2,$D$2:$D$10,">0")
On Tue, Sep 4, 2012 at 11:28 AM, Muralidhar E wrote:
>
> Dear all,
>
> Find the attached file, I want i column E if column D is more than zero to
> be calculated with how many times column B is repea
Hi,
Try this one (Simple & Easy) & see attached file.
=A1+1
Regards,
Kuldeep Singh
On Tue, Sep 4, 2012 at 11:26 AM, NOORAIN ANSARI wrote:
> Dear Amit,
>
> If you are working in Excel 2007+ Version then you can use
> =Edate(Today()+Row(A1),0)
>
>
> On Mon, Sep 3, 2012 at 11:56 PM, Amit Desai (M
Dear all,
Find the attached file, I want i column E if column D is more than zero to
be calculated with how many times column B is repeated.
Ex. In column B Murali is repeated 3 times but in column D is more than
zero is only 2 times, the result is 2.
Thanks in advance.
On Mon, Sep 3, 2012 at 6:0
Dear Amit,
If you are working in Excel 2007+ Version then you can use
=Edate(Today()+Row(A1),0)
On Mon, Sep 3, 2012 at 11:56 PM, Amit Desai (MERU)
wrote:
> Dear all,
>
> ** **
>
> I have dates mentioned in a column & I want to keep adding it so that I
> can match to a perfect date.
>
>
Dear all,
I have dates mentioned in a column & I want to keep adding it so that I can
match to a perfect date.
Please help me if there are any short cuts for adding days to dates.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confiden
Congratulations Noorain
On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain wrote:
> Dear members,
>
> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
> the month of Aug'12. He has posted 111 posts in August 2012 and helped many
> forum members through his excel expert
Good job
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
--
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, l
If desired, send ME your file after you finish for comments.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Selva
Sent: Monday, September 03, 2012 9:29 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need update on the attached Macro
Than
congratulations my friend, well done and keep it up
On Mon, Sep 3, 2012 at 1:33 PM, Rajan_Verma wrote:
> *Congrats bhai*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On
Thanks Lalit for your support.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lalit Mohan Pandey
Sent: 01 September 2012 18:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need update on the attached Macro
Find the attached file fo
Thanks Don.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 01 September 2012 19:24
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need update on the attached Macro
I think you will need to use some if's or selectcase
Dear Prince,
Its working fantastic.
On Mon, Sep 3, 2012 at 3:18 PM, Prince Dubey wrote:
> Hi Rakesh,
>
> Plz Use this Hope this will Help You.
>
> SUMIF(Sheet1!$B$2:$B$18,Sheet2!A2,Sheet1!$D$2:$D$18)
>
> Regards
> Prince
>
> On Monday, September 3, 2012 1:01:07 PM UTC+5:30, rakesh sharma wrot
Hi Excel Experts,
I have attached excel sheet for different date format. In this i need to
convert date into excel date format or any other alternative way to
calculate difference between two dates in different formats.
i have welcome ur post / updates
thanks in advance.
M Solaiyappan
--
Join
try this idea for ONE line
ActiveCell = ActiveCell & Application.CountIf(Range("c3:c33"), "ccc")
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: mburkett
Sent: Friday, August 31, 2012 11:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Combi
Hi Noorain,
You have sent very good file for learning PT with all options in terms of VBA.
Can you send same kind of file for Chart as well.
Thanks in Advance.
On 9/3/12, Mangesh Vimay wrote:
> Hi Noorain,
>
> You have sent very good file for learning PT with all options in terms of
> VBA.
> Can
Thanks you Ashish
On 9/3/12, ashish koul wrote:
> http://www.connectionstrings.com/Forum/excel/how-to-export-excel-worksheet-to-mysql-db-with-vba
>
>
> http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm
>
>
>
>
> On Mon, Sep 3, 2012 at 6:03 PM, Mangesh Vimay
> wrote:
>
>
Hi,
Use this..
=INDEX(Sheet1!$D$2:$D$18,MATCH(Sheet2!A2,Sheet1!$B$2:$B$18))
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 7:02 PM, Rajan_Verma wrote:
> *=SUMPRODUCT(N(Sheet1!$B$2:$B$18=Sheet2!A2),Sheet1!D2:D18)*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
HI manoj
Can u explain what column would you like to use to decide rank
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manoj Kumar
Sent: 03 September 2012 4:00
To: excel-macros@googlegroups.com
Subjec
Try after zip that
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of L.K. Modi
Sent: 03 September 2012 3:59
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ size of mail
sir thats a
Congrats bhai
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Indrajit $nai
Sent: 03 September 2012 3:05
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful
=SUMPRODUCT(N(Sheet1!$B$2:$B$18=Sheet2!A2),Sheet1!D2:D18)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 03 September 2012 1:01
To: excel-macros@googlegroups.com
Subject: $$
http://www.connectionstrings.com/Forum/excel/how-to-export-excel-worksheet-to-mysql-db-with-vba
http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm
On Mon, Sep 3, 2012 at 6:03 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> I would like to import the data/query result of
Hi Noorain,
You have sent very good file for learning PT with all options in terms of VBA.
Can you send same kind of file for Chart as well.
Thanks in Advance.
On 8/31/12, NOORAIN ANSARI wrote:
> Dear Kaushik,
>
> Please find attached VBA Pivot Table Template, Hope it will help to you.
>
> --
Hi Friends,
I would like to import the data/query result of Oracle SQL to Excel.
Can you please help me by providing suitable solution over my problem.
You can also suggest VBA code/guidelines to solve the issue.
Thanks lot !!!
--
With regards,
*MaNgEsH*
--
Join official facebook page of this
Provide a file and a complete explanation and examples.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Muralidhar E
Sent: Monday, September 03, 2012 3:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count when po is greater than zero
H
Congratulations Noorain for your great support.
On 9/3/12, rameshwari shyam wrote:
> Hi Noorain sir,
>
> Congratulation to help people
>
> thanks & regards,
> Rameshwari
>
> On Sun, Sep 2, 2012 at 9:02 AM, Ayush Jain wrote:
>
>> Dear members,
>>
>> Once again, Noorain Ansari has been selected as
Hi Noorain sir,
Congratulation to help people
thanks & regards,
Rameshwari
On Sun, Sep 2, 2012 at 9:02 AM, Ayush Jain wrote:
> Dear members,
>
> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
> the month of Aug'12. He has posted 111 posts in August 2012 and helped ma
Congrats Noorain you are hero of Group ...!
Regards
Amresh
On Mon, Sep 3, 2012 at 5:25 PM, Venkat CV wrote:
> Congrats Noorian...
>
>
>
> --
> *Best Regards,*
> *Venkat *
> *Chennai*
>
>
> On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain wrote:
>
>> Dear members,
>>
>> Once again, Noorain Ansa
Congrats Noorian...
--
*Best Regards,*
*Venkat *
*Chennai*
On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain wrote:
> Dear members,
>
> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
> the month of Aug'12. He has posted 111 posts in August 2012 and helped many
> forum m
Hi Rambabu,
Find the attached file.
use this formula.
=SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15)
Regards
Amresh
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote:
> Please try
>
> =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
>
>
> On Mon, Sep 3, 2012 at 5:17 PM, Rambabu
Dear Ram,
If you working in prior version of Excel 2007
You can use
=SUMPRODUCT(($J$15:$J$24=N15)*($K$15:$K$24<=O15)*($I$15:$I$24))
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote:
> Please try
>
> =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
>
>
> On Mon, Sep 3, 2012 at 5:17
Please try
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
On Mon, Sep 3, 2012 at 5:17 PM, Rambabu Mudiraj wrote:
> Dear all,
>
>
> --
> Regards
> Rambabu. G
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alre
Dear all,
--
Regards
Rambabu. G
--
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, Co
Hi Manoj,
my previous formulas is the basis of vertical (column rows) range .and for
Horizontal (rows column) , you can use below formula.
=RANK(I2,I2:L2,0)
And in-case of CELL M2 result you have mention in attached file rank 4 but
if you check it Manually You'll Find it on Rank 2
Regards
A
Hi Manoj,
I work only your required output Only. It's Okay.
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 4:47 PM, Manoj Kumar wrote:
> Dear Kuldeep,
>
> Amresh put formule in value but i change range in percentage it's working..
>
> Regard
> Manoj
>
>
> On Mon, Sep 3, 2012 at 4:45 PM, Manoj Ku
ok kuldeep it's my mistake...cell N4 value is wrong...
Regard
Manoj
On Mon, Sep 3, 2012 at 4:47 PM, Manoj Kumar wrote:
> Dear Kuldeep,
>
> Amresh put formule in value but i change range in percentage it's working..
>
> Regard
> Manoj
>
>
> On Mon, Sep 3, 2012 at 4:45 PM, Manoj Kumar wrote:
>
>>
Dear Kuldeep,
Amresh put formule in value but i change range in percentage it's working..
Regard
Manoj
On Mon, Sep 3, 2012 at 4:45 PM, Manoj Kumar wrote:
> Thanks for all
>
> Amresh's formula is ok for me..
>
> Regard
> manoj
>
> On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya wrote:
>
>> Hi
Thanks for all
Amresh's formula is ok for me..
Regard
manoj
On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya wrote:
> Hi Manoj,
>
> Find the attached file.
>
> use this formula hope it will help you.
>
> =RANK(B2,$B$1:$B$6,0)
>
> if you need anything else Pls explain properly.
>
> Regards
> Am
Hi Amresh,
Required output is not match.
*Your Ans*
*Required Ans*
*1*
4
4
1
1
2
2
4
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya wrote:
> Hi Manoj,
>
> Find the attached file.
>
> use this formula hope it will help you.
>
> =RANK(B2,$B$1:$B$6,0)
>
> if you ne
Hi Manoj,
Find the attached file.
use this formula hope it will help you.
=RANK(B2,$B$1:$B$6,0)
if you need anything else Pls explain properly.
Regards
Amresh
On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar wrote:
> Dear Pravin,
>
> Please provide ans..
>
> Regard
> Manoj
>
>
> On Mon, Sep 3, 2
Dear Manoj,
Please try it in Range("M2"), Hope it will help to you.
otherwise
Please explain more
On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar wrote:
> Dear Pravin,
>
> Please provide ans..
>
> Regard
> Manoj
>
>
> On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal wrote:
>
>> Pl use a meaningful su
Dear Pravin,
Please provide ans..
Regard
Manoj
On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal wrote:
> Pl use a meaningful subject for immediate response on your issues
>
>
> On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar wrote:
>
>> Dear Expert,
>>
>> Please help me to find rank in attached f
Congratulation Noorain Sir.
Regards
Amar
On Mon, Sep 3, 2012 at 3:38 PM, Deba Ranjan wrote:
>
> Heartiest Congratulations brother.
>
>
> Thanks & Regards,
> *Deba Ranjan *
>
>
>
>
>
> On Mon, Sep 3, 2012 at 3:04 PM, Indrajit $nai wrote:
>
>> *Congrats Noorain. :)*
>> *
>> *
>> *
Pl use a meaningful subject for immediate response on your issues
On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar wrote:
> Dear Expert,
>
> Please help me to find rank in attached file..
>
>
> Regard
> Manoj
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discuss
Dear Mr. Modi,
You can upload such files at online storage and may download from anywhere.
For Example : Google Drive
Regards
Pravin Gunjal.
On Mon, Sep 3, 2012 at 3:58 PM, L.K. Modi wrote:
> sir thats a song file..
>
>
> On Mon, Sep 3, 2012 at 3:44 PM, अनिल नारायण गवली
> wrote:
>
>> how can
Dear Expert,
Please help me to find rank 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
sir thats a song file..
On Mon, Sep 3, 2012 at 3:44 PM, अनिल नारायण गवली wrote:
> how can we understand what file u r attaching dude...
> just elaborate and explain...
>
> On Mon, Sep 3, 2012 at 3:40 PM, L.K. Modi wrote:
>
>> sir
>>
>> thats a long song dedicated to someone. is this possible wit
how can we understand what file u r attaching dude...
just elaborate and explain...
On Mon, Sep 3, 2012 at 3:40 PM, L.K. Modi wrote:
> sir
>
> thats a long song dedicated to someone. is this possible with yahoo mail.
>
>
> On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh wrote:
>
>>
>> Hi,
>>
>> G
sir
thats a long song dedicated to someone. is this possible with yahoo mail.
On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh wrote:
>
> Hi,
>
> Gmail is not supported file size 25 MB. This facility only yahoo mail
> only. Option is attach large file. but this file only One month valid only.
>
>
go to this site and see
http://support.google.com/mail/bin/answer.py?hl=en&answer=8770
U must be using .exe file for attaching . just confirm.
On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh
wrote:
>
>
> Hi,
>
> Gmail is not supported file size 25 MB. This facility only yahoo mail
> only. Option i
Heartiest Congratulations brother.
Thanks & Regards,
*Deba Ranjan *
On Mon, Sep 3, 2012 at 3:04 PM, Indrajit $nai wrote:
> *Congrats Noorain. :)*
> *
> *
> *
> *
> On Mon, Sep 3, 2012 at 11:59 AM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
>> Hi Noorain,
>>
>> Grea
Hi,
Gmail is not supported file size 25 MB. This facility only yahoo mail only.
Option is attach large file. but this file only One month valid only.
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi wrote:
> Dear all
>
> as i m uploading file containing size of 25 mb at gmail t
the max size for attachind a file is 25 mb.
your are getting a error message but what message is showing over there how
we know.
mention error description .
On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi wrote:
> Dear all
>
> as i m uploading file containing size of 25 mb at gmail to send but its
Dear all
as i m uploading file containing size of 25 mb at gmail to send but its
shows error so suggest how can we short the size of a folder.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
Hi Rakesh,
Plz Use this Hope this will Help You.
SUMIF(Sheet1!$B$2:$B$18,Sheet2!A2,Sheet1!$D$2:$D$18)
Regards
Prince
On Monday, September 3, 2012 1:01:07 PM UTC+5:30, rakesh sharma wrote:
> Hi Experts,
>
> I need the actual remit amt agnst tracking on sheet2 when data was found
> repeated
Hi Pravin,
Please use this hope this help you
TEXT(A1 ,"-")
regards,
Prince
On Saturday, September 1, 2012 12:58:23 PM UTC+5:30, Pravin Gunjal wrote:
> Dear Friends,
>
> I have attached an excel file for the subject mentioned above.
>
> In which there is column having full date in th
*Congrats Noorain. :)*
*
*
*
*
On Mon, Sep 3, 2012 at 11:59 AM, Rakesh Kumar Sharma wrote:
> Hi Noorain,
>
> Great job Dear,
> Congratulations !!!
>
>
>
> On Mon, Sep 3, 2012 at 10:40 AM, Seraj Alam wrote:
>
>> congrats noorain bhai.
>>
>>
>> On Mon, Sep 3, 2012 at 10:35 AM, अनिल नारायण ग
Thanks Kuldeep.
On Sat, Sep 1, 2012 at 10:08 PM, Kuldeep Singh wrote:
>
> Hi,
>
> I am sorry, Please try this one.
>
> =RIGHT(TEXT(A2,"-"),15)
>
> Regards,
> Kuldeep Singh
>
>
> On Sat, Sep 1, 2012 at 9:47 PM, Kuldeep Singh wrote:
>
>>
>> Hi Pravin,
>>
>> See Attached file.
>>
>> =RIGHT(T
Hi Rakesh,
Please try this.
=INDEX($D$5:$D$21,MATCH(K4,$B$5:$B$21))
Ctrl + Shift + Enter
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 1:24 PM, Rakesh Kumar Sharma
wrote:
> Dear Manoj,
>
> I have to pick actual remit amt with vlookup or any other formula. Amt is
> remitted for same tracking i
Hi,
Thanks for quickly reply, but it is not working, in result columncount of
name is not coming, name is appears,
Plz, ignore the column E it is remarks for the status of PO under process.
Actually i want the vendor name how many times it is repeat when it has PO,
if PO is not confirmed it will
Dear Manoj,
I have to pick actual remit amt with vlookup or any other formula. Amt is
remitted for same tracking in month of apr is 100, may -250, june 150 then
when i use vlookup for this tracking should give remitted amt=0
becoz amt will be (+100-250+150)=0
On Mon, Sep 3, 2012 at 1:07 PM, Ma
Dear Rakesh,
Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)*
Regd
Manoj
On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma
wrote:
> Hi Experts,
>
> I need the actual remit amt agnst tracking on sheet2 when data was found
> repeated on sheet1 with positive or nigative amt.
> See the att
Hi Experts,
I need the actual remit amt agnst tracking on sheet2 when data was found
repeated on sheet1 with positive or nigative amt.
See the attachment...
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
Join official facebook page of this forum @
https://www.facebook.com/discu
Hi Murli,
Try this one.
=IFERROR(INDEX($B$2:$B$10,SMALL(IF($D$2:$D$10>=E2,ROW($E$2:$E$10),""),COUNTIF($B$2:B10,B2))-1),"0")
Ctrl + Shift + Enter
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E wrote:
> Hi,
>
> thanks, But the result is coming wrong, for blank "p o" vendor
Additionally, although it is quite possible to detect when one of the
data-val. cells has been selected, perform a task, then when another cell's
been selected, reverse the original task (mburkett -- you'll need to track
some data between events to do that), your code then has to figure out how
wid
Hi,
thanks, But the result is coming wrong, for blank "p o" vendor name is
taking in calculation.
On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh wrote:
>
> Hi Muralidhar,
>
> Try this.
>
> =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0"))
>
> Regards,
> Kuldeep Singh
>
>
> On Mon,
67 matches
Mail list logo