Hi All,
Awaiting for your help on formula.
Thanks,
Kaushik Savla
-- Forwarded message -
From: KAUSHIK SAVLA
Date: Wed, Sep 5, 2018 at 8:06 PM
Subject: $$Excel-Macros$$ Formula needed
To: MS EXCEL AND VBA MACROS
KAUSHIK SAVLA
[image: Attachments]1:53 PM (6 hours ago)
to
KAUSHIK SAVLA
[image: Attachments]1:53 PM (6 hours ago)
to excel-macros
Hi team,
Need an formula whick will look at each cell of Column A and Column B and
fetch result
Criteria as below:-
if Account beginning with 1 and if have balance positive then OK, otherwise
"To check"
xclude
weekends ie. Saturday and Sunday
3. I want formula to give the same result as shown in Column E.
Please do the needful.
Regards,
Kaushik Savla
--
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 f
Hi David,
For current data word current will be mentioned and for prior data word
prior would be mentioned.
Regards,
Kaushik Savla
On Mon, Apr 30, 2018, 15:54 who wrote:
> [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible
> for Automatic Cleanup!
Hi David,
Please let me know what additional information is needed.
Regards,
Kaushik Savla
On Sat, Apr 28, 2018, 07:42 who wrote:
> [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible
> for Automatic Cleanup! (david.lanm...@gmail.com) Add cleanup r
Please help on this one.
--
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, like Please He
data
from Column A to AO and paste the same in Sheet F
10.Now Filter for "Current" in Column B of Sheet D. Copy the visible data
from Column A to AO and paste the same in Sheet F
11. Refresh the formulas of whole workbook
Attached is the sample file for reference
Thanks,
Kaushik Savla
Hi Paul,
I followed the instructions.
However what's happening is the macro is just showing running and not giving
any outcome.
I kept it running for nearly 3 hours.
Regards,
Kaushik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT
Macro is just running and not fetching any outcome.
Regards,
Kaushik
On May 26, 2017 16:11, "'Martin George' via MS EXCEL AND VBA MACROS" <
excel-macros@googlegroups.com> wrote:
>
>
> On Thu, 5/25/17, Paul Schreine
Hi Paul,
The macro for this one is not working.
Can you please share your file with macro. So i can compare with my file.
I am getting error message the data cannot be pasted as shape and size are
not same.
Regards,
Kaushik
On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner
Could you please share your dummy workbook which you created?
Regards,
Kaushik Savla
On Thursday, May 25, 2017 at 11:47:39 PM UTC+5:30, Paul Schreiner wrote:
>
> The workbook that you add the VBA macro to is identified as "ThisWorkbook".
>
> so, in the macro:
>
>
;
> Rng.Formula
> End If
> puts the listing on the first sheet of the workbook.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In
Hi Paul,
Macro got run and gave finished message.
Where can I find the desired output?
Regards,
Kaushik
On May 25, 2017 19:06, "Paul Schreiner" wrote:
> OK.
> Spent WAY longer on this than I should have.
>
> I should've had you create a "dummy" set
k say name B, C, D, E in different cells.
What I want is in new workbook it should display
Worksheet A - Linked from external workbook X, Y and internal worksheets
B, C, D, E.
This process repeat for all worksheets within a workbook.
Regards,
Kaushik Savla
8373916768
On May 25, 2017 00:53,
name mention the unique source with
name say linked to external ABC, XYZ, files and linked to a, b, c, d, e,
f Worksheets.
This I want to do for all 100 worksheets.
Hope this helps.
Regards,
Kaushik
On May 25, 2017 00:23, "KAUSHIK SAVLA" wrote:
> Hi Paul,
>
> What I am l
mention the unique source with name
say linked to external ABC, XYZ, files and linked to a, b, c, d, e, f
Worksheets.
This I want to do for all 100 worksheets.
Hope this helps.
Regards,
Kaushik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT
Hi Paul,
I am getting error message mentioning the cells cannot be pasted as the
size and shape is not same.
Regards,
Kaushik
On Tuesday, May 23, 2017 at 11:32:58 PM UTC+5:30, KAUSHIK SAVLA wrote:
>
> Hi Team,
>
> I am trying to do below in an excel. You can assume there are 60
Hi Paul,
The code is not working.
Can you please provide full code starting with Sub...till End sub
Regards,
kaushik Savla
On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner
wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the
;
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, May 23, 2017 2:56 PM, KA
ul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
Hi Paul,
I want to know each worksheet is linked to what source.
This I want to do because say suppose one source is incorrect, through
this I will know it will affect which worksheets of my workbook.
Regards,
Kaushik
On May 24, 2017 00:17, "Paul Schreiner" wrote:
So, you
manually is impossible.
Regards,
Kaushik Savla
--
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
Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Application.Goto Range(Cells(ActiveWindow.SplitRow + 1,
ActiveWindow.SplitColumn + 1).Address)
ActiveWorkbook.Save
Next
End Sub
Regards,
Kaushik Savla
--
Are you
Hi everyone,
This is Kuldeep Kaushik from Faridabagd. I am 35 yes old and working in HR of a
pvt. Hospital.
My major tasks includes providing various MIS reports to complete hospital.
This group can help in increasing my excel skills.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
this sheet data is coming from tab Sheet3 and Sheet4. I want
sheet3, Sheet4 against Sheet 2.
Sheet3 - In this sheet data is coming from tab Sheet4, Sheet5 and Sheet7. I
want Sheet4, Sheet5 and Sheet7 against Sheet3.
And so on
Please help.
--
*Warm Regards,*
*Kaushik
Thanks.Macro works for what I was looking for.
--
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 t
Hi Team,
Finding each cell in whole workbook would be very time consuming with ctrl + f.
Can u pls suggest some short cut to get the desired results.
Regards,
Kaushik
--
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
than 14 but less than or equal to 30 More than 30 Greater than
30
--
*Warm Regards,*
*Kaushik Savla*
--
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
e like “-1”, “1”. Simply right -1, 1.
>
> ** **
>
> ** **
>
> * *
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *KAUSHIK SAVLA
> *Sent:* Wednesday, September 04, 2013 2
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav wrote:
>
> Remove* "" * from formula ...for number value
>
>
> On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
>
>> Hi Team,
>>
>> Request you to kindly provide me
Hi Team,
Request you to kindly provide me solution to below silly problem I am
facing in excel.
I am trying to get sum of data range B2 to B6 in cell B8. Answer which I am
getting is not correct, seems some problem with formatting.
Pls help.
--
*Warm Regards,*
*Kaushik Savla*
--
Are you =EXP
Thanks Vijay and Ahmed to resolve the query.
Regards,
Kaushik
--
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
Hi Team,
I am having some data in Cell A1 to A100 and I want to concatenate
range of data from A1 to A100 with comma as seperator.
Example:
Cells
A1 10
A2 20
A3 30
&so on
I want result as 10, 20, 30 & so on.
Please help.
Warm Regards,
Kaushik Savla
--
Are you =
.@ahcindia.com (Please don't delete or modify
while replying to this email) *For Internal Use of Employer* - Monster
Resume ID: 3540940 Personal Folder ID: 13512253 Dear Kaushik,
Hi,
This is with reference to a suitable career prospect and job opportunity.
Abyss & Horizon Consultin
Note: The biggest challenge I am facing is there is no fix range of
the data in each worksheet. Eg in one worksheet there is data upto 200
rows, in another 240 rows, etc.
Need your help.
Thanks,
Kaushik Savla
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
Hi team,
Awaiting for response in below query.
Appreciate your help in looking into it.
Regards,
Kaushik
-- Forwarded message --
From: "KAUSHIK SAVLA"
Date: May 27, 2013 8:42 PM
Subject: Re: $$Excel-Macros$$ Vba code for pivot table drill down and
renaming shee
questions.
Regards,
Kaushik
On Mon, May 27, 2013 at 8:03 PM, Bé Trần Văn wrote:
> Please attach File, I know how to handle new look.
>
>
>
> 2013/5/27 KAUSHIK SAVLA
>
>> Hi All,
>>
>> Need your help in pivot table drill down.
>>
>> I am having hug
which I do not have since need
to get this prepared in 1 hour as per deadline.
Pls take any hypothetical example.
Thanks in advance for your help.
Regards,
Kaushik
--
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
Hi team,
Awaiting ur valuable response on my below email.
Regards,
Kaushik Savla
-- Forwarded message --
From: "KAUSHIK SAVLA"
Date: Apr 15, 2013 8:21 PM
Subject: Fwd: $$Excel-Macros$$ Time Tracking Tracker
To:
Hi All,
I am getting error message when I am trying to
ue, _
AllowFormattingColumns:=True, _
AllowFormattingRows:=True, _
AllowSorting:=True, _
AllowFiltering:=True, _
Password:=pwd
End If End If End If End Sub
Pls suggest on it.
Regards,
Kaushik Savla
-- Forwarded message --
From: KAUSHIK SAVLA
Date: Sat, Apr 6, 2013 at 1:15 PM
Thank You very much for prompt response!
On Thu, Apr 11, 2013 at 10:22 PM, ashish koul wrote:
> =MID(A1,FIND(5,A1),6)
>
>
>
> On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA
> wrote:
>
>> Hi Team,
>>
>> I need a formula to find anything starting from 5
Hi Team,
I need a formula to find anything starting from 5 in a cell and to take 6
digit right of the cell starting from 5 as below.
Eg.
DataDesired Result
ABC 500012 XYZ 500012
XYZ500134XYZ 500134
Regards,
Kaushik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
essible by anyone.
Is there any way I will be only knowing the password to unprotect without
getting displayed to all.
Regards,
Kaushik Savla
On Fri, Apr 5, 2013 at 8:41 PM, KAUSHIK SAVLA wrote:
> Thank You for the help.
>
>
> On Friday, April 5, 2013, Paul Schreiner wrote:
> &g
>
>
> Paul
>
> -
> “Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John W
Hi Team,
I need Time Management Tracker which does the following:-
If anyone double click in start time column the time of system get capture
automatically which cannot be edited , similarly for end time.
Need password protected to enable changes my myself.
Regards,
Kaushik
--
Are you =EXP
On Oct 21, 2012 5:31 PM, "SAJID MEMON" wrote:
> Dear experts,
>
> I have done a small project in excel 2003 with some command buttons. when
> i open my project in excel 2007 then command buttons are not press or
> working.
> Why this problem come in 2007? please give me settings or any suggessti
Congratulations Noorain.
Regards,
Kaushik Savla
On Sep 2, 2012 10:44 AM, wrote:
> **
> Congrats Noorain..
>
> Rgds
> Vaibhav
> --
> *From: * Ayush Jain
> *Sender: * excel-macros@googlegroups.com
> *Date: *Sun, 2 Sep 2012 10:32:31
suppliers namely A,B,C,D.*
*4. The extracted data should automatically rename the worksheet tab
containing the name of supplier.*
*
*
*Looking forward for your prompt response.*
*
*
*Regards,*
*Kaushik Savla*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Hi Noorain,
Congratulations
Thanks for helping us always.
Regards,
Kaushik
--
FORUM RULES (986+ 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 not get
Many thanks Asa for your reply.
Regards,
Kaushik
On Feb 10, 2012 10:57 AM, "Asa Rossoff" wrote:
> Does the attachment gets deleted from the original email in your Inbox? I
> have not heard of that before.
>
> If you mean your reply email does not include the attachment
Hi,
Good Morning
I am facing problem in MS Outlook. I am receiving emails with
attachments but when I reply to that email attachments gets deleted.
Please sugegst me the corrective action.
Many thanks in anticipation of your assistance.
Regards,
Kaushik Savla
--
FORUM RULES (986+ members
showing tax payable.
(Attachment file would be here from specific file path)
Kindly let me know in case you require further information.
Best Regards,
Kaushik Savla - Assistant Manager
JLT India Pvt Ltd
What I want to do - Firstly, I want Sender name to be captured
automatically as per email
Hi Rajan,
Problem resolved.
Excellent job to help us on this article.
Regards,
Kaushik
--
FORUM RULES (986+ 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
Hi Rajan,
I am using excel 2007 version.
Regards,
Kaushik
--
FORUM RULES (986+ 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 not get
quick attention
Hi Chandra,
It is not working in my system
Cold you please what you did to get it worked properly?
Regards,
Kaushik
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem
Hi Sam,
In your email there is no attachment or print screen.
can you please let me know which window you are getting?
Regards,
Kaushik
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
Hi Sam,
I have Acrobat 9 installed in my system.
Pls suggest.
Regards,
Kaushik Savla
--
FORUM RULES (986+ 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
Hi Noorain,
Unable to find anything as reference in tools option in Acrobat 9.
Please suggest.
Regards,
Kaushik
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
That code not working too.
Pls suggest.
Regards,
Kaushik Savla
--
FORUM RULES (986+ 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 not get
quick
Thanks for the reply.
Mr Excel tip requires a software named as Able2Extract professional.
I don't want to use any software/converter.
I want VBA Code for conversion.
Please help me.
Regards,
Kaushik Savla
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, acc
Hi,
How to convert pdf file to excel without any pdf converters?
regards,
Kaushik Savla
--
FORUM RULES (986+ 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
Hi,
Does any one uses Smarstream application for uploading Accounting Journal
Entries?
Best Regards,
Kaushik Savla
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Congrats Rajan.
Many thanks for devoting your valuable time daily from your busy schedule.
Regards,
Kaushik Savla
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Happy Birthday Noorain.
On Jan 2, 2012 8:36 PM, "Kris" wrote:
> Happy B'day Noorain !
>
> --
> FORUM RULES (934+ 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 Adv
Hi Rajan,
Could you please suggest how to do it?
Regards,
Kaushik Savla
On Wed, Dec 28, 2011 at 7:14 PM, Rajan_Verma wrote:
> Try to adjust paragraph setting in your signature Option..
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegrou
Hi,
I want a vba code to have line spacing as zero in my signature.
Currently when I am creating an email I am getting my signature
dispayed as below:-
Kaushik Savla
Assistant Manager – Jardine Discretionary Trust Accounting
JLT India Pvt Ltd
Direct Line: +91 022 43377441, Extenstion # 4141
Hi,
I want a vba code to have line spacing as zero in my signature.
Currently when I am creating an email I am getting my signature
dispayed as below:-
Kaushik Savla
Assistant Manager – Jardine Discretionary Trust Accounting
JLT India Pvt Ltd
Direct Line: +91 022 43377441, Extenstion # 4141
showing tax payable.
(Attachment file would be here)
Kindly let me know in case you require further information.
Best Regards,
Kaushik Savla - Assistant Manager
JLT India Pvt Ltd
What I want to do - Firstly, I want Sender name to be captured
automatically as per email received from sender
Hi Noorain,
I am using Micorsoft Outlook 2007. Where can I find object library?
Secondly I want sender name to automatically displayed as per email
received.
Regards,
Kaushik Savla
On Mon, Dec 12, 2011 at 8:28 PM, NOORAIN ANSARI wrote:
> Dear Salva,
>
> First select *Tools-Reference-
Hi Noorain,
Many thanks for the response.
I tried but it is not working.
Further I don't want any excel spreadsheet to be used. I just want to use
only Outlook.
Please suggest.
Regards,
Kaushik Savla
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate t
Hi Guys,
I am waiting for any response on below Vba query in Outlook.
Request you to look into it and help me.
Regards,
Kaushik Savla
-- Forwarded message --
From: KAUSHIK SAVLA
Date: Sat, Dec 10, 2011 at 3:58 PM
Subject: Vba Code for Outlook
To: excel-macros@googlegroups.com
ed?? Goto ExitProc End If Set MsgReply = Msg.Reply
WithMsgReply .Subject = "RE:" & Msg.Subject .HTMLBody = "Hello " & strGreetName
& "," & .HTMLBody .Display End With ExitProc: Set Msg = Nothing
Set MsgReply = Nothing End Sub
But actually I am looking for insert
payable.
(Attachment file would be here)
Kindly let me know in case you require further information.
Best Regards,
Kaushik Savla - Assistant Manager
JLT India Pvt Ltd
What I want to do - Firstly, I want a code which will write the above green
highlighted text message automatically. Secondly, I
payable.
(Attachment file would be here)
Kindly let me know in case you require further information.
Best Regards,
Kaushik Savla - Assistant Manager
JLT India Pvt Ltd
What I want to do - Firstly, I want a code which will write the above green
highlighted text message automatically. Secondly, I
Thanks all for the help
Problem got resolved,
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
Query on paste link - Should i select each worksheet of workbook and
do the paste special value paste link? If so then is there any
shortcut to link whole workbook to another workvook.
Regards,
Kaushik
On 8/4/11, XLS S wrote:
> Use paste special with paste link..
>
> On Wed, Au
;D2:H2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Calculate
End Sub
Please help on this macros.
Regards,
kaushik savla
--
--
Some important links for excel users:
1. Follow us on TWIT
Hi All,
How to import only selected data from another workbook?
Please help.
Regards,
Kaushik
--
Sent from Gmail for mobile | mobile.google.com
Kaushik Savla
--
--
Some important links for excel users:
1. Follow
Hi Rajan,
I want to get it in another new workbook not in the same workbook.
Please help on this.
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
It will take a lot of time initially.
If there is any code or formula then would be helpful very much.
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Thanks Ashish and Rajan.
Its works fine.
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
HI,
Answer should come to 10 as per row no. 16 which is latest from the given
data (ie May 2011 latest month from available data, and total of May 2011 is
10)
But in the attavhed sheet answer is coming as 80 which is incorrect.
Regards,
Kaushik
Hi All,
I want excel function which can calculate the total of latest month relating
to latest year.
Please find attached file for the data.
Please help.
Regards,
Kaushik
--
--
Some important links for excel users
excellent poem
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com
---
KAUSHIK SAVLA wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-f8192d6cd9-72f73129e5-C7TBpa-Kz4A3NYkZ_J1GeRZjtpk
Y
Thanks Rajan.
It works perfectly
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http
Thanks Rajan,
But Vba is not ending. It is giving me debug required at End If in Vba Code,
further the totals are also not tying after Vba Code applying.
Please do the needful by looking it again.
Regards,
Kaushik
Thanks Haseeb.
I am using excel 2003 where will i get group function in pivot and how
much criteria will it support?
On 7/27/11, Haseeb Avarakkan wrote:
> Hello Kaushik,
>
> You already created Pivot Table Group the date in to Month & Year. And drag
> the Year in Column Area, M
Thanks All.
It works excellent.
Regards,
Kaushik
On Wed, Jul 27, 2011 at 1:18 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> If you need a formula use SUMPRODUCT or SUMIF
>
> See the attached.
>
>
> HTH
> Haseeb
>
> For Tips visit;
> htt
Thanks all.
Formula works but counts one less, so i am adding one manually.
Regards,
Kaushik
Hi All,
I want to count the number of spaces in a cell:-
Eg In Cell A1 data is "9 7 5 6" I want function which returns answer as 4
count.
Please suggest.
--
--
Some important links for excel users:
1. Follow us on T
t.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><&
lt;><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Sent from Gmail for mobile | mobile.google.com
Kaushik Savla
--
-
gt;
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http:
;><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Sent from Gmail for mobile | mobile.google.com
Kaushik Savla
--
--
Thanks Ankur
On Wed, Jul 20, 2011 at 7:19 PM, ankur wrote:
> hi kaushik
> plz use this formula
> =SUM(IF(A2=1,A2,0),IF(B2=3,B2,0),IF(OR(C2=1,C2=2),C2,0),IF(D2=1,D2,0))
> sample file is attached for ur reference
>
>
> On 20/07/2011, Aindril De wrote:
>> Hi Kaushik,
Hello Guys,
Please help me to get to result in the attached.
I have tried with sumifs, if etc., but not getting the accurate result.
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on
Hi ,
I wanna join this group
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/grou
transpose to happen if meets criteria that it match the claim number,
i have 5 records as such.
I have attached an spreadsheet as example
Please help its urgent.
Regards,
Kaushik
--
--
Some important links for
Hi Priya,
Please find attachment.
Let me know if you need anything else.
Thanks & Regrds,
Kaushik Savla
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
1 - 100 of 102 matches
Mail list logo
