Hi
Try :
Use below formula in Conditional Formatting
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("65:90"))),"")))=3
Reference :http://dmcritchie.mvps.org/excel/strings.htm
Thanks
Mahesh
On Thu, Jul 28, 2011 at 3:39 AM, qcan wrote:
> Hi,
>
> Can anyone help me with some sort of formula
I have attached file which gives us simple idea whatever i want to do.
Please help me. It's urgent for me to keep accounting record.
ananta Sapkota
--
--
Some important links for excel users:
1. Follow us on TWITTER
Dear All,
Try this
1. In a blank cell, enter the number 1.
2. Select the cell and press *Ctrl+C*.
3. Hold down the *Ctrl* key as you click each hyperlink you want to
remove.
4. Right Click and Choose Paste Special from
5. Select the Multiply radio button (In Operations).
6. C
Try this see if it helps
On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee wrote:
> hello
>
> i need to combine multiple excel files(15) into one excel file. Each file
> has 2 sheets... R and S and data from both needs to consolidated into
> respective sheets. .. so i need a macro which can give one f
hello
i have 15 files in one folder. i need to combine two sheets called as
maps and shipment of all the 15 files into one consolidated file with
2 sheets( with respective data). Structure and columns are same in
sheets for all the files.
Can you pls give a macro.. also can you please let m e
Exzcellent guys. Amazing. Thanks.
On Jul 28, 8:18 am, XLS S wrote:
> Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole
> cell.but your solution color only first 3 letter ...
>
> On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma wrote:
>
>
>
>
>
> > Hope it will
hello
i need to combine multiple excel files(15) into one excel file. Each file
has 2 sheets... R and S and data from both needs to consolidated into
respective sheets. .. so i need a macro which can give one file with two
sheets that consolidate data from all the files... All the files have sam
I am sorry, I don’t know how to do it. Maybe it is possible to achieve it
with a class module, but evenso, I’m not able to do it so far.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : samedi 30 juillet 2011 17:00
vijaykumar and venkat
thank you very much for your valuable input.
On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR wrote:
> Dear Krishna,
>
>
> The profile of MIS Executive changes with the type organisation.If it is a
> small organisation MIS Executive role would be to prepare normal reports
>
If 10 Rows Consist in Range rng then loop will Run 9 Time From 9 TO 1
Every time R value will decrease 1 because of Step -1
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Saturday, July 30, 2011 8:06 PM
To: excel-macros@googlegrou
Hello, Ayush,
Thanks for the translation. It’s a quite nice poem, although, sadly, the
essence of a poem cannot be translated.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la
part de Ayush Jain
Envoyé : samedi 30 juillet 2011 16:54
À :
HI,
Let’s suppose you have a certain range of cells (let’say A1 :B20)
You define “rng” as this range :
Set rng = Range(“A1:B10”)
« rng.Rows.Count » is the number of rows of rng (10)
So :
« rng.Rows.Count » - 1 = 9
Now :
For r = rng.Rows.Count - 1 To 1 Step -1
Means
Dear Rajanverma,
Thanks for your help
aju v chacko
On Sat, Jul 30, 2011 at 6:33 PM, Rajan_Verma wrote:
> Also add this Function to Remove Special Character From Sheet name ,Because
> if the Special Character inclu
Dear Krishna,
The profile of MIS Executive changes with the type organisation.If it is a
small organisation MIS Executive role would be to prepare normal reports
like the work you do.If it is a big and reputed organisation your role in
addition to normal report preparation would be to do fianaci
Dear daniel,
Thanks. Now it is working fine.But the sub '*
Worksheet_BeforeDoubleClick'* is included as worksheet level event routine
of w.sheet *analysis*.How can i incorporate this in personal macro
workbook.Once again thanking u for Ur help.
with regards
Hello Daniel,
I tried to use google translate to convert the same into english. Few lines
converted very well but the meaning may have changed in few lines.
Noorain, Can you please fix the lines where the intended meaning is changed.
Thanks.
Where is the daily barrage of hundreds Questions.
The
Hello, Noorain,
I am really sad not to understand the meaning of your poem (is it
Hindi ? I failed to learn it a few years ago) I shall really enjoy to
get a translation from it. If you have time enough to do it.
Regards.
Daniel
On 30 juil, 04:20, NOORAIN ANSARI wrote:
> Dear Experts,
>
> I ha
stored proceure compiles only once and stores in database
managemant system so it is optimized for best performance
while sql query compiles every time and executes using dbms
driver so its performance decreses
On Sat, Jul 30, 2011 at 2:54 PM, Venkat CV wrote:
> Dear All,
>
> What is the dif
Thanks Noorain !
Excellent poem everytime :)
2011/7/30 Jattin Agarwal
> kamal hai , asey hi poem likhtey raho , aur hamey kush karte raho
>
> 2011/7/30 NOORAIN ANSARI :
> > Dear Experts,
> >
> > I have written a poem on our group to complete 8000 Members in
> EXCEL-MACRO
> > faimly.
> > read a
See the attached sheet.. Revert if any Queries :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Dim val1 As Variant
If Target.Column = 2 Then
Application.EnableEvents = False
val1 = Target.Value
kamal hai , asey hi poem likhtey raho , aur hamey kush karte raho
2011/7/30 NOORAIN ANSARI :
> Dear Experts,
>
> I have written a poem on our group to complete 8000 Members in EXCEL-MACRO
> faimly.
> read and Enjoy...
>
> जहा रोज सैकड़ों Questions की होती है बौछार.
> फिर लगते है अति-उत्
Hi All,
This is srinivas from Hyderabad working in a MNC company .
I support UK clients here. My job is processing payroll for UK clients on
Monthly Basis.
Normally in UK we need to deduct National Insurance contribution from
employee salary.
There are different NI catogories and for each cate
Congrates
--
--
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/groups?gid=1871310
3. Ex
Hi Noorain,
SuperbPoem..Better if you Publish in English Every one can read Easily
worldwide..all our group members..
*Best Regards,*
*Venkat*
*Chennai*
*
*
2011/7/30 XLS S
> Wonderful. मज़ा आ गया
>
> 2011/7/30 NOORAIN ANSARI
>
>> Dear Experts,
>>
>> I have written a poem on our group to
hi noorain ,
fine but my name s missing;
thnks
2011/7/30 NOORAIN ANSARI
> Dear Experts,
>
> I have written a poem on our group to complete 8000 Members in EXCEL-MACRO
> faimly.
> read and Enjoy...
>
> जहा रोज सैकड़ों Questions की होती है बौछार.
> फिर लगते है अति-उत्तम Answers की
Dear All,
What is the difference between SQL Stored Procedures and SQL Querys,
Can any one Explain Clearly..
*Best Regards,*
*Venkat*
*Chennai*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TW
Hi Ashish.
Welcome...
*Best Regards,*
*Venkat*
*Chennai*
*
*
On Sat, Jul 30, 2011 at 2:38 PM, Ashish <4everash...@gmail.com> wrote:
> Thanks Venkat, the solution works for me.
>
> Ashish.
>
>
> On Jul 29, 7:14 pm, Venkat CV wrote:
> > Hi ,
> >
> > Try the Below you May get the output as requir
Thanks Venkat, the solution works for me.
Ashish.
On Jul 29, 7:14 pm, Venkat CV wrote:
> Hi ,
>
> Try the Below you May get the output as required...
>
> =TEXT(A1,"DD-MM-YY")
>
> *Best Regards,*
> *Venkat*
> *Chennai*
> *
> *
>
> On Fri, Jul 29, 2011 at 5:25 PM, Ashish Khandelwal
> <4everash..
Thnaks for reply
On Fri, Jul 29, 2011 at 4:52 PM, XLS S wrote:
> No, because this is currently using Microsoft object
>
> On Fri, Jul 29, 2011 at 10:34 AM, Shrinivas Shevde > wrote:
>
>> Thanks .Can I just Copy paste as a simple Flash game I dont want to use
>> Excel or Word
>> Is it possible
>
Hi Kirish,
Just go to Linked in and search MIS Executive and see what are
all responsibilities and then you may get clear Picture what they are
doing...
*Best Regards,*
*Venkat*
*Chennai*
On Sat, Jul 30, 2011 at 11:41 AM, krishna mummina
wrote:
> Thank you very much for the links. Most of them
30 matches
Mail list logo
