the people you can,
As long as ever you can.” - John Wesley
-
From: David Grugeon da...@grugeon.com.au
To: excel-macros@googlegroups.com
Sent: Wed, August 15, 2012 3:06:05 AM
Subject: Re: $$Excel-Macros$$ Please help (Word
Hi Paul
I try to avoid putting chunks of text in merged cells (if possible) because
the cell does not adjust its height so you can easily end up with text
which is hidden and may be important. I know you can kludge this by having
a copy of the cell off to the right made the same width as the
Now I understand why the first requirement was first. This is a fair
implementation of that requirement IMHO.
Some weird things seem to happen if you edit a line after it has been
wrapped. That may not be an issue for MM.
I still think Excel is not cut out to be a word processor and for dealing
What is your issue.? Please explain
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help (Word Wrap in Excel).
Dear
Dear Manoj,
Please see attached sheet, Change range as per State Name
Hope it help to you.
On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji.
I need 1st,2nd and 3rd Max sealing model name in every state...
Regard
Manoj
On Fri, Jul 20, 2012
Dear Manoj,
Please see attachment without Array Function.
On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji,
Thanks for reply
Your formula is correct but can you do it without Erry..
Regard
Manoj
On Fri, Jul 20, 2012 at 4:08 PM, NOORAIN
Manoj Please change reference of range, As per need otherwise it will show
same result.
On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji,
when i drag this formula it show same result...
On Fri, Jul 20, 2012 at 5:52 PM, NOORAIN ANSARI
Dear Manoj,
Need more clarification..
What is criteria of Model1,Model2,Model3
Please explain
On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert,
Please help me
Query file attached with mail...
Regard
Manoj
--
--
FORUM RULES (986+
Thanks Deba. Its very nice even before using it I never know that Excel
could do all these stuff so nicely.
Thanks again Dear.
On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan drdeva...@gmail.com wrote:
Dear Mangesh,
To create this calendar in the range B2:H9, follow these steps:
1. Select
Please tell us so that we can edit and learn it. How to make ?
calender_Simple.xls file
On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Manoj,
Please find attached simple Calender.
You can create it simply.
On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar
Dear Mangesh,
To create this calendar in the range B2:H9, follow these steps:
1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge
Center.
2. Enter a date into the merged range. The day of the month isn’t important.
3. Enter the abbreviated day names in the range B3:H3.
Hi,
use below formula
=find(B1,A1)
Regards
Amresh
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote:
Dear Expert.
i have 2 Coll A1 B2
A1 Contain (Foto Fast Elec)
B1 Contain (Fast)
I want khow B1 is in A1 or not...
Regard
Manoj
--
FORUM RULES (986+
Dear Manoj,
You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found)
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert.
i have 2 Coll A1 B2
A1 Contain (Foto Fast Elec)
B1 Contain (Fast)
I want khow B1 is in A1 or not...
Regard
Thanks Noorain Ji...
its working..
On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Manoj,
You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found)
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar
kumarmanoj.11...@gmail.comwrote:
Dear
Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!
Regards,
@Suman
Send on the move with Galexy y.
On Jul 11, 2012 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Manoj,
You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found)
On Wed, Jul 11,
Subject: Re: $$Excel-Macros$$ Please help me.
Dear Suman,
It is working fine with table, Pls see the attached sheet.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
http://www.excelmacroworld.blogspot.com www.excelmacroworld.blogspot.com
On Wed, Jul 11, 2012 at 1:43 PM, Suman
I need diff in between these two dates in Hours
Start Date End Date
4/1/2012 5:01 4/3/2012 6:15
Whatever the diff in between these two dats in terms of hours (hh:mm)
Please help
--
With regards,
MaNgEsH
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Dear Mangesh,
Please use it..
=TEXT(B2-A2,[H]:mm:ss)
On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
I need diff in between these two dates in Hours
Start Date End Date
4/1/2012 5:01 4/3/2012 6:15
Whatever the diff in between these two dats in terms of
Thanks Noorain
On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Mangesh,
Please use it..
=TEXT(B2-A2,[H]:mm:ss)
On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay
mangesh.da...@gmail.comwrote:
I need diff in between these two dates in Hours
Start Date End Date
4/1/2012
Hello Expert,
I've studied Attendance register made by Santosh. I have not understood how
excel is using criteria2, criteria3 etc Rule 1 2.
I've tried to find same in excel function list to read help but I've not
found.
Please advice or share syntax. Please share good book for excel 2007 for
to contact me.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Date: Tue, 19 Jun 2012 06:32:56 -0700
From: nashi...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help : Use of Criteria Rule1-2
Hello Expert,
I've studied Attendance
Hi,
I have a drop down list which is created using menu 'data validation'.
Is it possible to get the items in the first line in the drop down while
start entering the letters of the items.
Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
entering P itself Pen and pencils
Check mails of this group.
It has been already answered some days before.
ManGesh
On Tue, May 29, 2012 at 1:36 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
I have a drop down list which is created using menu 'data validation'.
Is it possible to get the items in the first line in the
Dear Team
Please go through the attached excel sheet and help me in the calculation of
* discount* (Column - D) based on the *discount criteria *(Column G:I)
Regards
Rajender Soni
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Hi,
PFA
On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender soni.rajen...@gmail.comwrote:
Dear Team
Please go through the attached excel sheet and help me in the calculation
of* discount* (Column - D) based on the *discount criteria *(Column G:I)
Regards
Rajender Soni
--
FORUM RULES (986+
Dear Rajendra,
Waheed solution is nice, you can also use...vlookup with approximate match
=VLOOKUP(B2,$G$3:$I$5,3,*1*)
On Tue, May 8, 2012 at 3:03 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi,
PFA
On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender soni.rajen...@gmail.comwrote:
Dear Team
Hi
Attached is a file in which in the loss column ( M Column ) the amount
appears with the - ( Minus ) in the beginning. Kindly advise what can be
done by which the minus will not appear.
Thanks and Regards
Aruna
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
See the attached file
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aruna jayaram
Sent: Apr/Sun/2012 11:09
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help on basic Excel
Hi
Attached is a file in which in the loss
] *On Behalf Of *Aruna jayaram
*Sent:* Apr/Sun/2012 11:09
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Please help on basic Excel
** **
Hi
Attached is a file in which in the loss column ( M Column ) the amount
appears with the - ( Minus ) in the beginning. Kindly advise
See the attached sheet
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aruna jayaram
Sent: Apr/Sun/2012 11:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help on basic Excel
Hi Rajan,
In the M column it should
:* Apr/Sun/2012 11:21
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Please help on basic Excel
** **
Hi Rajan,
In the M column it should appear as 1600 and not -1600.
Thanks
Aruna
On Sun, Apr 8, 2012 at 11:12 PM, Rajan_Verma rajanverma1...@gmail.com
wrote
Hi,
Please help me how to show percentage in bar chart like value
--
Thanks Regards
Anil Kumar
--
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,
Hi,
Find the attached file.
On Fri, Feb 24, 2012 at 2:11 PM, anil panchal anil.kan...@gmail.com wrote:
Hi,
Please help me how to show percentage in bar chart like value
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Dear Anil,
Please see attached sheet,
Maries solution is good but You can do it without using helping column
On Fri, Feb 24, 2012 at 3:41 PM, anil panchal anil.kan...@gmail.com wrote:
Hi,
Please help me how to show percentage in bar chart like value
--
Thanks Regards
Anil Kumar
, January 27, 2012 7:41 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please Help me to create summary and Macro.
Hi Experts,
i am currently facing very serious problem cuz every day i have to
generate data from various workbooks wich is bassed on the daily reports.
and i have
yes dilip, i guess u r right. i want the results as per the results
highlighted in red border. and hyperlink format in red font.
regards,
Avinash
On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Avinash,
Not entirely getting your point.
Please confirm if you
Hi Avinash,
Not entirely getting your point.
Please confirm if you need following which I can understand per your post :)
1) Following results as per Date in first field this you have
already attached
DateTotal Product Actual PriceTotal Number Of ProductsGrand
Total Sheet
Dear Excel Members,
Please help me how to calculate the Tenurity of a agent.
Regards,
Satvik
Sent from BlackBerry® on Airtel
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi Satvik,
use the below formula .
=(today()-A1)/30.5
On Mon, Jan 2, 2012 at 9:32 PM, Satvik satvik...@gmail.com wrote:
Dear Excel Members,
Please help me how to calculate the Tenurity of a agent.
Regards,
Satvik
Sent from BlackBerry® on Airtel
--
FORUM RULES (934+ members already
Hi..
Please attach sample file with output what you want by Formula..
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Satvik
Sent: Jan/Mon/2012 09:33
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
11:40 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ PLEASE HELP ME
DEAR ALL MY EXCEL FRND.
PLEASE SEND SOME FORMULA FOR MEDAL TALLY CHAMPIANSHIP
Chandra Singh Bohra
Champawat
Uttrakhand
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise
Dear Friends
Anyone has solved assignment of SMU first semester. if you have then Please
forward.
amreshkushw...@gmail.com, mail2sanja...@gmail.com, always...@gmail.com
Please this is very urgent.
--
***Thanks
Sanjay Kumar Maurya*
--
FORUM RULES (934+ members already BANNED for violation)
that the first time i send for help thanks
From: hanna habiel jhonalshar...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Saturday, October 29, 2011 1:40 PM
Subject: $$Excel-Macros$$
Dear All,
good day for all ,
i need your help for the attached file
Dear Pravesh,
Please try through below code..
Sub ImportPDFFileData()
'Author: Steve Lipsman
'Purpose: Import PDF File Data Into Excel Worksheet
'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References
'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After Reference
Is Saved
Thnaks yaar, but i am new in Macro world so dont know even ABC of it, can u
plz send the final file. I will be very thankful to you. its very urgent for
me plz
On Mon, Oct 24, 2011 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Pravesh,
Please try through below code..
Sub
Worksheet_Change(ByVal Target As Range)
If Target.Row 2 Or Target.Column 7 Then Exit Sub
If UCase(Target) = DONE Then Target.Offset(, 1) = Date
End Sub
-Original Message- From: XLS S
Sent: Wednesday, August 10, 2011 1:19 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
I sent the original answer. I should have told you to save your file as an
.xlsM (macro enabled file)
From: Sundarvelan N
Sent: Monday, August 22, 2011 6:59 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help
Hi Team,
Still i'm notable to find the solution
Attach a file
From: Sundarvelan N
Sent: Tuesday, August 09, 2011 11:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
Hi Friends,
Please refer the attached image. Please help on this scenatio.
Thanks
N.Sundarvelan
9600160150
, August 10, 2011 1:19 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help
Hey Sundaryelan,
Please find the attachment
.
On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N nsund...@gmail.com wrote:
Hi Friends,
Please refer the attached image. Please help
Please Attach Your excel file..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: Wednesday, August 10, 2011 10:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
Hi Friends,
Please refer the attached
Hi frds
Please help me.
--
***Thanks
Sanjay Kumar Maurya*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
see if it helps
On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya mail2sanja...@gmail.comwrote:
Hi frds
Please help me.
--
***Thanks
Sanjay Kumar Maurya*
--
--
Some important links for excel users:
1.
hi Sanjay,
just see whether this helps...i created a pivot according to my
understanding of the quwestion...just get back to me if it is not enough
On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya mail2sanja...@gmail.comwrote:
Hi frds
Please help me.
--
***Thanks
Sanjay Kumar Maurya*
--
Hi,
Please find the attached sheet with solution.
Thanks
Rupesh Kr.
On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya mail2sanja...@gmail.comwrote:
Hi frds
Please help me.
--
***Thanks
Sanjay Kumar Maurya*
--
Dear Frd
Thanks for your reply and solution but I have more data so pivot table
is not possible for it. if u have any easy format please tell me.
Thanks
Sanjay Kumar Maurya
On 8/3/11, sreejith k.s sreejith.ks1...@gmail.com wrote:
hi Sanjay,
just see whether this helps...i created a pivot
Hey Sanjay
Try to use Indirect Functionplease find the attachment
On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya mail2sanja...@gmail.com wrote:
Dear Frd
Thanks for your reply and solution but I have more data so pivot table
is not possible for it. if u have any easy format
Dear Friends
Thank your very much for your great reply.
may u define this formula. I can not find any source for *Groups* . I am
using that other place that function is not working.
Thanks again
Sanjay Kumar Maurya
On Thu, Aug 4, 2011 at 5:18 AM, XLS S xlst...@gmail.com wrote:
Hey Sanjay
Dear Experts,
Please find the attached file . my questions is i have alphabets Numbers
both in one cell now i want only count numbers like 123#n/aabcd345677 now i
want 9
Thanks Regards
Anil Kumar
113784
--
=LEN(SUBSTITUTE(a1,#n/a,))
On Tue, Jul 26, 2011 at 6:05 PM, anil panchal anil.kan...@gmail.com wrote:
Dear Experts,
Please find the attached file . my questions is i have alphabets Numbers
both in one cell now i want only count numbers like 123#n/aabcd345677 now i
want 9
Thanks
Try this
=LEN(SUBSTITUTE(C3,#n/a,))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil panchal
Sent: Tuesday, July 26, 2011 6:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
Dear Experts,
Please find
Hello Anil,
Also, If you have other text or charracters other than #n/a and just need to
count the numbers only, use this,
=COUNT(INDEX(MID(C2,ROW(INDEX(C:C,1):INDEX(C:C,LEN(C2))),1)+0,0))
Copy down
HTH
Haseeb
For tips visit;
http://www.excelfox.com/forum/forum.php
--
Can u please help me in writing a macro in excel as below:
1) When we click on the command button, it should prompt for entering
the number in the input box.
2) After entering the number, it should take us to the cell that has
the numer.
3) and coresponding cell should be filled with current
=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2,
and then copy across to other cells
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Thank you!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of GoldenLance
Sent: Monday, June 13, 2011 7:14 AM
To: excel-macros@googlegroups.com
Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good.
=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999
@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of §»VIPER«§
Sent: Wednesday, May 11, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.
pfa
On Thu, May 12, 2011 at 12:31 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
Hi,
Students English maths sceience Grades
suresha 45 80 90 90-100 A
srinivas 25 36 60 80-90 b
sunyana 38 65 70 60-80c
sunitha 80 90 68 36-60
hi sukumar,
please find attached.
regards,
saber
On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
Students English maths sceience Grades
suresha 45 80 90 90-100 A
srinivas 25 36 60 80-90
@googlegroups.com]
On Behalf Of Fabio Lemos
Sent: Saturday, May 14, 2011 7:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.
You also could simplify the formula by inserting the following in the E2
cell:
=OFFSET(INDIRECT('$A$2'!$A$1;TRUE
-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Please help to make my project good.
Dear Mr. Fabio Lemos,
Thanks for your interest.
I tried to apply your below mentioned formula. I am getting error message.
Can you please send me sample file with formula. Thanks a lot for this
kindness
12, 2011 8:36 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.
pfa
On Thu, May 12, 2011 at 12:31 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
check whether attach file helps.
On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of karan 1237
Sent: Wednesday, May 11, 2011 3:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help to make my project good
pfa
On Thu, May 12, 2011 at 12:31 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
check whether attach file helps.
On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1...@gmail.com wrote:
Respected Sirs/Mam,
I need your help making my project good. Please find attachment. I will
be very
Respected Sirs/Mam,
I need your help making my project good. Please find attachment. I will be
very obliged if someone can help me as earlier as possible.
--
Basically I have to do that when I click on drop down list select another
career i.e. Building and Construction so In sub career
please check the attachment if it helps..
best regards,
STDEV(i)
note:
we need dynamic* Max Value* of ScrollBar
so we use Scroolbar from ActiveX Control, instead of from FORM.
A little macro wil work each time you change the career
On Wed, May 11, 2011 at 5:21 PM, karan 1237
Hi
check whether attach file helps.
On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1...@gmail.com wrote:
Respected Sirs/Mam,
I need your help making my project good. Please find attachment. I will be
very obliged if someone can help me as earlier as possible.
--
Basically I
*Thank you so much. I am very grateful to you.
*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
On Sun, May 8, 2011 at 6:59 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
try to use this UDF (user defined function)
Function UniqueList(Dat As Range)
' List of UnSorted Unique Values '
*
LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT
SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT
*Hi Experts,
I want like this. Please help.
Thnx in Advance.
*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
--
try the attachment
On Sat, May 7, 2011 at 2:20 PM, karan 1237 karan1...@gmail.com wrote:
*
LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT
SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT
*Hi Experts,
I want like this. Please help.
try to use this UDF (user defined function)
Function UniqueList(Dat As Range)
' List of UnSorted Unique Values '
'-'
Dim Cel As Range, vArr(), n As Long, Tx As String
Tx = ,
For Each Cel In Dat
If InStr(1, Tx, , Cel , ) = 0 Then
Dear Experts,
How can Hide only workbook but userform should be visilble and work as it,
when we click on *Eng In out Report* button.
Please see attached sheet..
Thanks in Advance
--
Thanks regards,
Noorain Ansari
--
Thanks regards,
Noorain Ansari
--
by hiding application objec at time of userform initialized or activated
Application.visible = False
and don' forget to unhide the aplication (excel) at time of userform
deactivated or unloaded
Application.visible = False
se attachaed workbook
On Wed, Apr 27, 2011 at 1:38 PM, NOORAIN ANSARI
Thanks a lot of Setiywati(STDEV). and Ashish...
it's working fine
On Wed, Apr 27, 2011 at 3:50 PM, STDEV(i) setiyowati.d...@gmail.com wrote:
by hiding application objec at time of userform initialized or activated
Application.visible = False
and don' forget to unhide
Dear Gurus,
Please advise any formula to calculate the Book Value in given attachment.
Thanks in Advance
Regards,
Shrinivas
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
try this
=B3/(RIGHT(C3,LEN(C3)-FIND(~,SUBSTITUTE(C3,
,~,LEN(C3)-LEN(SUBSTITUTE(C3, ,)*1)
On Wed, Apr 27, 2011 at 7:32 PM, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
Dear Gurus,
Please advise any formula to calculate the Book Value in given attachment.
Thanks in Advance
Hi Sudhir,
Check if its working. I have done it for only Running Balance. I am not
clear with the Pending Amount the numbers are contradicting in the format
which you had attached. if you can let me know how it is done. I can rework
the code.
Regards
Umesh Dev
On Sat, Mar 19, 2011 at 12:15
Hi,
Thanx and It's feel good to see done with macro. And how to copy it to my main
workbook.
Meaning of Pending Amount : It mean's payment which was not collected yet.
Regards
Sudhir
On 21/03/2011, Umesh Dev umesh.d...@gmail.com wrote:
Hi Sudhir,
Check if its working. I have done it for
Hi Sudhir,
In the excel sheet which you have send me, for the party name b on 14th
March you have mentioned 1700 as the pending amount.
My question is How do you come to arrive at this figure? 1700
Regards
Umesh
On Mon, Mar 21, 2011 at 9:13 PM, sudhir kumar bluecore...@gmail.com wrote:
Hi Sudhir,
It is still not clear, how to get the Running Bal and the Pending Amount.
Regards
Umesh
On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar bluecore...@gmail.comwrote:
Dear Experts,
Please read my attachment and solve it.
thanx
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
Hi
Running balance mean's outstanding of Parties on left side display date.
Pending amount mean's pending bills upto outstanding.
thanx
On 19 March 2011 05:27, Umesh Dev umesh.d...@gmail.com wrote:
Hi Sudhir,
It is still not clear, how to get the Running Bal and the Pending Amount.
Dear Experts,
Please read my attachment and solve it.
thanx
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi
use this formula in data validation
=CONTAR.SI($C$2:$C$30;C1)=1
chilexcel
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41
2011/3/8 Rabindra Thapa rabinthapa2...@gmail.com
Dear all,
I have one attach file where I am keeping the
sorry, use this formula in data validation
=CONTAR.SI http://contar.si/($C$2:$C$30;C2)=1
2011/3/9 ChilExcel chilexcel...@gmail.com
Hi
use this formula in data validation
=CONTAR.SI($C$2:$C$30;C1)=1
chilexcel
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ;
Dear all,
I have one attach file where I am keeping the serial pipe number but the
problem is I am getting the same pipe number many times and it's hard to
search whether provide pipe number are reported or not.
Can u have any formula/validation i.e. when I type the reported pipe number
Hi Dearests,
Please Help Code Doesn't Work
On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar rakeshshail2...@gmail.comwrote:
*thanks Daniel Ji for the reply... here what I need and what the code
doesn't do.*
*
*
*This code runs as long as the Sheets(1).Cells(2, ColNumber) =
Plz share your code
On Feb 21, 2:06 pm, rakesh kumar rakeshshail2...@gmail.com wrote:
Hi Dearests,
Please Help Code Doesn't Work
On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar
rakeshshail2...@gmail.comwrote:
*thanks Daniel Ji for the reply... here what I need and what the code
Dear All,
I have cash entries in one workbook and I want total of some specific entries
in different workbook.
Please can you help me on the same.
Regards,
Shrinivas
--
--
Some important links for excel users:
1.
arre you using excel 2003 or 2007
if you are using 2007 simply apply filter by color
On Fri, Feb 18, 2011 at 3:49 PM, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
Dear All,
I have cash entries in one workbook and I want total of some specific
entries in different workbook.
Dear All,
my Question is we can use use two header in p. Table.?
--
Thanks Regards
Anil Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sat, January 29, 2011 12:33:37 PM
Subject: RE: $$Excel-Macros$$ Please help
Hai groups,
Can you tell me what is the use of $ sign excel
And can you give some examples please;;;
Thank you
From:excel-macros@googlegroups.com [mailto:excel
101 - 200 of 284 matches
Mail list logo