Dear Sir,
Small Question...
then Sir what is exact meaning and use of declare variable in below case?
Thanks in Advance .
Reg,
Prafull Jadhav.
On Thu, Jun 6, 2013 at 5:41 PM, Paul Schreiner schreiner_p...@att.netwrote:
IF you do not utilized Option Explicit at the beginning of each module
the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Prafull Jadhav prafulltjad...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thu, June 6, 2013 8:26:37 AM
*Subject
Thanks a lot.It really good one.
On Tue, Jun 4, 2013 at 12:27 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Thanks..
Nikhil
On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Frndz,
Use full link to learn Excel. please find attached link!!!
Dear Vikas,
if the cell value length is less then 11 then find the solution with
Vlookup and Mid function.
if length if more then 10 then you have to edit the formula and add the
condition.
On Mon, Jun 3, 2013 at 11:35 AM, Vikas Bhosale vikin...@gmail.com wrote:
Hi Frnd here I attached
and what about value of alphabet ..only till J ...or further also .K
=10.L=11.something.
On Mon, Jun 3, 2013 at 11:17 AM, Vikas Bhosale vikin...@gmail.com wrote:
In single cell some time two some time three ,four,five,six,some time
seven,eight,nine, not fix.
Sent from my BlackBerry®
Dear XLS,
It is very useful formula and nice formula I was trying the same with
sumproduct ...but it not happen...
first time i have seen sumifs formula with index and match formula.
Regards,
Prafull Jadhav
MIS executive.
On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote
Dear Priti Madam,
Can you tell me ,
What N stand in below formula ?
On Thu, May 30, 2013 at 2:22 PM, priti verma pritiverma1...@gmail.comwrote:
use this as an array formula
=SUM(N(FREQUENCY(IF($C$1:$C$85=F9,$A$1:$A$85,),IF($C$1:$C$85=F9,$A$1:$A$85,))0))
On Thu, May 30, 2013 at 1:34 PM,
Dear Yogesh,
use below formula
=WEEKNUM()
On Tue, May 28, 2013 at 8:27 AM, David Grugeon da...@grugeon.com.au wrote:
I think you would do better to use a pivot table. Dates can be based on
weeksfor the summarisation.
Regards
David Grugeon
On 28 May 2013 12:17, Yogesh Vyas
Dear Preeti Madam,
Got the same ans ..thanks a lot..
Regards,
Prafull Jadhav
On Wed, May 15, 2013 at 9:32 AM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear Preeti Madam,
it is very perfect formula ...Madam I go through the formula
.. earlier also i asked you that what is result
Dear Abhishk Sir ,
I have also me the same without VBA ...just for example.
I know VBA is better way .
On Tue, May 14, 2013 at 5:43 PM, Chaya chayamon...@gmail.com wrote:
Hi Priti,
Thank you. your formula contains logic a lot, perfectly working. thanks
once again.
Regards,
Chaya
(INDIRECT(1:LEN(A7)))-1*)*LEN(A7))+1),LEN(A7
Regards and Thanks in Advance.
Prafull Jadhav.
MIS Executive...
On Wed, May 15, 2013 at 9:16 AM, Prabhu Pinky prabhupin...@gmail.comwrote:
wow.. really u have big sound in formula... ur formula is confusing to
understanding.. but u done it...really
Dear Priti Madam,
Can you explain the same formula in details ...
It is perfect .but i want to go into deep...
Please explain ..
why used Rept and indirect formula.
Regards,
Prafull
On Fri, May 10, 2013 at 11:00 AM, Chaya chayamon...@gmail.com wrote:
Awesome, its perfectly working.
Thanks
Dear Abhishekji,
Can you provide the code with comments ...
On Wed, May 8, 2013 at 6:57 PM, Abhishek Jain abhishek@gmail.comwrote:
Here.
On Wed, May 8, 2013 at 6:23 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts
I have a query where the sheets have a huge number of
Find the same ..with useing sumproduct formula.
On Mon, May 6, 2013 at 1:59 PM, priti verma pritiverma1...@gmail.comwrote:
HI Bhanu ,
please see the attachment.
On Mon, May 6, 2013 at 1:35 PM, bhanu prakash bhanu...@gmail.com wrote:
Dear All,
In Vlookup, when we have more than 3 to 4
Dear Sir,
Very good and Creative ..
Regards,
Prafull Jadhav.
On Sat, May 4, 2013 at 12:48 PM, Abhishek Jain abhishek@gmail.comwrote:
Very Good.
On Sat, May 4, 2013 at 12:42 PM, ashish koul.ash...@gmail.com wrote:
https://lh4.googleusercontent.com/-KfbiDBtwVAE/UYSzzdO-c8I/CWA
Dear Pankaj,abhishek Sir,
I have one query ..the infomration which we feed ..is it stored any
where...?
(I am new for Macro and VBA)
Regards,
prafull Jadhav.
On Thu, May 2, 2013 at 2:49 PM, pankaj gmail account
pankaji...@gmail.comwrote:
Thank You Abhishek Great!
I was just looking
Dear Sir,
Can i get example file so i can practice on it i want to learn macro
,form.which is related to excel VBA.
Regards,
Prafull Jadhav.
MIS exceutive.
On Fri, May 3, 2013 at 4:57 PM, Abhishek Jain abhishek@gmail.comwrote:
Dear Prafull,
In this example, no it does not get
Dear Abhishek Sir,
I have just seen web site ..it it good one.
I will practice the same ...i know it will take time to understand the
whole funda as I am new for the same.
thanks a lot Sir
Reg,
Prafull Jadhav.
On Fri, May 3, 2013 at 5:14 PM, Abhishek Jain abhishek@gmail.comwrote
Dear Rakesh,
find the same.
Regards,
Prafull jadhav.
On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest ahmedhon...@gmail.com wrote:
Rakesh:
Run Pivot table, if no Idea just google it to learn Pivot tables / go to
youtube to learn pivot table. You will learn less time.
Start exploring
Dear Rakesh,
find the same with using Sumproduct formula .
Reg,
Prafull
On Wed, Apr 17, 2013 at 5:23 PM, Rakesh Kumar Sharma rakeshks@gmail.com
wrote:
Dear Experts,
I want the month wise sum amt where the column tr is #N/A. I used SUMIF
but i don't know how to use conditional sumif.
Dear Xls Sir,
Can you explain the below formula.
When we used Lookup formula and Rept .
Why you have mention in formula Z and 255 ?
Thanks in Advance .
Regards,
Prafull Jadhav.
On Thu, Apr 11, 2013 at 10:56 PM, Gum Nam shaukh...@gmail.com wrote:
HI,
Thanks, I tried your formula it gave me
Dear Shrinivas ,
Please find the attachments contain formula as per your requirement
But this is not include below Criteria
(@ and characters are not allowed in any of the Column)
That you will get from Our experts .. I am not able to formulise the same.
Regards,
Prafull Jadhav.
On Tue
Dear Anil,
it is perfect and I appreciated.
I am also learning Excel Macro but I am not able to understand from where I
have to start .
what is beginning point to understand .how to create short macro code in
excel .
Can you guide me for the same .
Thanks in Advance .
Regards,
Prafull Jadhav
Please share a example file with criteria
On Sat, Apr 6, 2013 at 3:45 PM, Shrinivas Shevde shrinivas...@gmail.comwrote:
Dear All
Can Anyone answer this
Regards
Shrinivas
On Mon, Apr 1, 2013 at 1:48 PM, Shrinivas Shevde
shrinivas...@gmail.comwrote:
Dear Rajan
Thanks for reply
'Management information System'.
On Fri, Apr 5, 2013 at 2:14 PM, karthik N n.karthi...@gmail.com wrote:
Dear Team
Please Answer the Question
What is the MIS ?,Explain.
Regards
karthik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
Dear Ashish Sir,
Can you explain the below formula ..what is Small function work here.
=IFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,),ROW(A1)),)
Regards,
Prafull Jadhav
On Thu, Apr 4, 2013 at 10:40 PM, ashish koul koul.ash...@gmail.com wrote:
Try this one too without pivot table .
On Thu
Dear Ashish Sir,
Thanks a lot .
Regards,
Prafull Jadhav.
On Thu, Apr 4, 2013 at 11:00 PM, ashish koul koul.ash...@gmail.com wrote:
Its an array formula so u have to enter with CTRL+SHIFT+ ENTER
iFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,),ROW(A1)),)
Lets break the formula
IFERROR
Dear All,
I attached the sheet in which I require data vertically with company name.
example data is attached .
Regards,
Prafull Jadhav.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
there are 500 rows it takes 1 hour to do the same by transpose.
On Wed, Apr 3, 2013 at 6:03 PM, Anil B ank.bira...@gmail.com wrote:
its simple dude paste as special and select transpose thats it.
Thanks,
Anil
On Wed, Apr 3, 2013 at 5:52 PM, prafull jadhav
prafulltjad...@gmail.comwrote
.
Regards,
Prafull Jadhav.
On Wed, Apr 3, 2013 at 8:54 PM, ashish koul koul.ash...@gmail.com wrote:
try this
Sub sample()
Dim i As Long, j As Long, k As Long
For i = 2 To Sheets(1).Range(a65356).End(xlUp).Row
j = Sheets(2).Range(a65356).End(xlUp).Row + 1
k = Sheets(1
contain easy macros.
Thanks in Advance .
Regards,
Prafull Jadhav.
9920553518
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
used any type of macro here . the
dropdown box is taken from developer menu.
Warm Regards,
Gawli Anil
On Wed, Apr 3, 2013 at 10:29 AM, prafull jadhav
prafulltjad...@gmail.comwrote:
Dear Anil,
I have created the same with help of validation and index formula by
editing your chart
Dear Ashish,
Can we do it by using formula.
Regards,
prafull Jadhav;
On Sat, Mar 30, 2013 at 1:00 PM, ashish koul koul.ash...@gmail.com wrote:
*Try this*
*Sub sample()*
*Dim i As Long*
*With Sheets(1)*
*For i = 1 To .Range(a1).End(xlToRight).Column*
*Z = .Range
, Mar 30, 2013 at 2:20 PM, prafull jadhav
prafulltjad...@gmail.comwrote:
Dear Amar,
find the same with using sumproduct.
Regard,
Prafull Jadhav.
On Sat, Mar 30, 2013 at 1:59 PM, amar takale amartak...@gmail.comwrote:
Dear All Experts
I required formula here Average Price ( Financial
...
Warm Regards,
Gawli Anil
On Fri, Mar 29, 2013 at 10:38 AM, Prince prince141...@gmail.com wrote:
sry for mistake
PFA.
On Thursday, March 28, 2013 9:20:47 PM UTC+5:30, Prince wrote:
PFA
regards
Prince
On Thursday, March 28, 2013 11:18:17 AM UTC+5:30, prafull jadhav wrote:
Dear
Dear All,
in attached sheet i have updated sample data .
I am not getting the out put . Please help me in this reagard.
I have mentioned what my requirement .
Regards,
Prafull Jadhav.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Anil
On Thu, Mar 28, 2013 at 11:18 AM, prafull jadhav prafulltjad...@gmail.com
wrote:
Dear Prince,
find the same.
Regards,
Prafull Jadhav.
On Thu, Mar 28, 2013 at 9:19 AM, Prince prince141...@gmail.com wrote:
Share your workbook.
Regards
Prince
On Wednesday, March 27, 2013 6:05
Regards,
Prafull Jadhav.
MIS-Executive.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles
Dear Prince,
find the same.
Regards,
Prafull Jadhav.
On Thu, Mar 28, 2013 at 9:19 AM, Prince prince141...@gmail.com wrote:
Share your workbook.
Regards
Prince
On Wednesday, March 27, 2013 6:05:37 PM UTC+5:30, prafull jadhav wrote:
Dear All,
Sumproduct function return the Max function
...@gmail.com
To: excel-macros@googlegroups.com
HI ,
find the same if it is as per your requirement .
Regards,
prafull jadhav.
On Sun, Mar 24, 2013 at 2:27 PM, David Grugeon da...@grugeon.com.auwrote:
I want to know where we are going next with this. What happens if the
amounts are different
HI ,
find the same if it is as per your requirement .
Regards,
prafull jadhav.
On Sun, Mar 24, 2013 at 2:27 PM, David Grugeon da...@grugeon.com.au wrote:
I want to know where we are going next with this. What happens if the
amounts are different?
On Sunday, 24 March 2013, santosh subudhi
HI Find the same.
On Wed, Mar 20, 2013 at 5:09 PM, Vinay Saraf vi...@vinaysaraf.com wrote:
You should sort your data..
*From *Jan to Dec
*TO April to March*
On Wed, Mar 20, 2013 at 4:59 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
I want to plot a graph
101 - 142 of 142 matches
Mail list logo