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,N:OW) ! Joi
uot;'" & Rng.Formula
>
> End Ifputs
> 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 all the places yo
can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Wednesday, May 24, 2017 1:42 AM, KAUSHIK SAVLA > wrote:
>
>
> Hi Paul,
>
> The code is not working.
>
> Can you please provide full co
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
sWorkbook.Sheets(1).Cells(nRow, "D").Value = "'" &
> Rng.Formula
> End If
> End If
> Next Rng
> Next Sht
> ThisWorkbook.Activate
> MsgBox "Finished"
> End Sub
> *Paul*
>
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
Hi Paul,
What I am looking for is below.
1. I have a workbook with 100 worksheets
2. Each worksheet is linked to several external Workbooks and several table
within workbook.
3. What I want to do is first list all name of tabs sequentially in a new
workbook and against each worksheet name me
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*
> -
ng as ever you can.” - John Wesley*
-
On Tuesday, May 23, 2017 2:07 PM, KAUSHIK SAVLA
wrote:
Hi Team,
I have several huge data files.
Each file has links to several worksheets and several workbooks.
Can anyone help me with a vba code which will go in each works
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
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
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 title
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 =
Fyi
-- Forwarded message --
From: "Abyss & Horizon Consulting Pvt. Ltd."
Date: Jun 17, 2013 2:19 PM
Subject: Urgent job opening with Atos for VBA_Gurgaon
To:
To respond back directly to the Employer, please click on Reply button,
or send an email to anus...@ahcindia.com (Pleas
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
Hi All,
Need your help in pivot table drill down.
I am having huge excel database around 15 rows having whole data of
different accounts.
I want to create a pivot on it on basis of Account No. and Amount which is
located in column K and F respectively.
After pivot table is created with above
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(E:
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
q
nt to include attachments sent to you in your reply, Forward the
> message instead of replying to it.
>
> Asa
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of KAUSHIK SAVLA
> Sent: Thursday, Februa
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 wi
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 or
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, Code
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, F
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 Pr
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 gr
g 3, 2011 at 4:47 PM, KAUSHIK SAVLA
> wrote:
>> Hi All,
>> How to import only selected data from another workbook?
>> Please help.
>>
>> Regards,
>> Kaushik
>>
>> --
>>
;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 :
htt
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
--
-
a.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><&
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;
> http://www.excelfox.com/forum/forum.php
>
> --
>
-
On Tue, Jul 26, 2011 at 4:41 PM, Daniel wrote:
> Hi,
>
> ** **
>
> =LEN(A1)-LEN(SUBSTITUTE(A1," ",""))
>
> ** **
>
> Regards.
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@goo
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
--
--
Hi All,
I want to transpose certain data from row to column if meets specific
criteria: eg
Whole data is as below:
Claim No. Amount
1 10
2 20
1 30
1 10
2 20
I want as
Claim No.
1 10 30 10
I want tran
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 :
95 matches
Mail list logo
