=IF(A2=9,N(1),IF(A2=10,N(1),IF(A2=6,N(-1),IF(A2=N(7),,IF(A2=N(8),)
On Wed, Sep 4, 2013 at 2:37 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
Request you to
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Remove* * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
Request you to kindly provide me solution to
Hi,
Here is ur solution
Don't use 1 when u put number in if condition always give numbers as it
is. There is no need to give like -1, 1. Simply right -1, 1.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
Thanks Ravi!
On Wed, Sep 4, 2013 at 2:38 PM, Ravi Kumar excellearn2...@gmail.com wrote:
Hi,
** **
** **
Here is ur solution
** **
Don’t use “1” when u put number in if condition always give numbers as it
is. There is no need to give like “-1”, “1”. Simply right -1, 1.
Dear Kaushik,
No need to close numbers in double quotes.
just simply type numbers as numbers, like Type 1 instead of 1 or -1
instead of -1
On Wed, Sep 4, 2013 at 2:37 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull
Welcome friend
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:40 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help on silly problem
Hi Thameem,
Suppose you have the total for everyone of the 40 sheets on cell B100. The
following formula would sum every total of the 40 sheets you have.
I guess this is what you want.
=SUM(Plan2!B100;Plan3!B100;Plan4!B100)
Best regards.
OS
2013/8/12 ashish koul koul.ash...@gmail.com
can u
what you want?..
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan dhamulo...@gmail.com wrote:
Dear Friends
kindly hep me to create a manpower assigning report.
E.g:
*Project name *:xx
*Input:*
*Per day target*:according to project name its
Template for Manpower as assigning report.
On Thursday, 29 August 2013 15:55:12 UTC+5:30, XLS S wrote:
what you want?..
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan dhamu...@gmail.comjavascript:
wrote:
Dear Friends
kindly hep me to
Thanks a ton !!!
On 8/20/13, De Premor d...@premor.net wrote:
paste this on userform1
'
Dim Target As Range
Private Sub CommandButton1_Click()
Target.Offset(1).Select
Unload Me
End Sub
Private Sub TextBox1_Change()
Target = TextBox1.Text
End Sub
paste this on userform1
'
Dim Target As Range
Private Sub CommandButton1_Click()
Target.Offset(1).Select
Unload Me
End Sub
Private Sub TextBox1_Change()
Target = TextBox1.Text
End Sub
Private Sub UserForm_Activate()
Set Target = Selection
TextBox1.Text =
can u share the sample file ...
On Mon, Aug 12, 2013 at 1:05 PM, thameem thamee...@gmail.com wrote:
Dear all,
for example I have one excel with 40 sheets, in those sheets I have one
total r sum... I need formuale or codes, to sum all total of 40 sheets in
one sheet...
--
Are you
Respected Cute Awsome,
You can find cracks and activation keys for download.Just google for
windows 7 activation keys or download a cracked version and install.Then
you will not receive the message.
Regards,
Vijaykumar
On Sat, Jul 27, 2013 at 4:38 PM, Excel Learn excellearn2...@gmail.comwrote:
(a) This is not a Windows help forum.
(b) What you're asking supports piracy and is probably illegal.
On Sat, Jul 27, 2013 at 3:48 PM, Cute Awesome aqibmari...@gmail.com wrote:
I am using windows 7 i am not using genuine software for the last 2 years
now i have message on my scree that this
K do one thing go to start button-type cmd -write click over there and
select run as administration then type in command prompt slmgr -rearm,
your windows will reactivate.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cute Awesome
Sent:
Thanks Ravinder :)
On Mon, Jul 22, 2013 at 4:05 PM, ravinder negi ravi_colw...@yahoo.comwrote:
PFA..
--
*From:* Dhaval Shah todhavals...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Monday, July 22, 2013 3:46 PM
*Subject:* $$Excel-Macros$$ Need
Perfect, thank you so much for your help!! Saves me a lot of time.
On Wednesday, July 17, 2013 10:28:34 AM UTC-4, ashish wrote:
check the attachment see if it helps
On Wed, Jul 17, 2013 at 12:15 AM, bobsc...@yahoo.com javascript:wrote:
excel 2003 and the last 4 would be the bottom
On
which version of excel are you using and last 4 do you mean from top or
bottom of column ?
On Tue, Jul 16, 2013 at 7:33 AM, bobscore...@yahoo.com wrote:
Hello,
I am using Excel 2003. I have attached a simple workbook which has two
worksheets. One worksheet is titled Scores and the other
excel 2003 and the last 4 would be the bottom
On Tuesday, July 16, 2013 9:36:13 AM UTC-4, ashish wrote:
which version of excel are you using and last 4 do you mean from top or
bottom of column ?
On Tue, Jul 16, 2013 at 7:33 AM, bobsc...@yahoo.com javascript: wrote:
Hello,
I am
Hi
You can hide all unwanted col rows and protect workbook so that user will
not be having access to that portion.
Thanks
On Mon, Jul 1, 2013 at 9:25 AM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Seniors,
I have a data from Colum A to Column D in excel sheet, I want show only
Hi Vabz,
I'hve follow your insturction and I'hve got my answer but when I'hve unhide
the sheet, the data will not showing. please help and advise for the same.
Thanks,
Ashish kumar
On Monday, July 1, 2013 2:06:10 PM UTC+5:30, Vabz wrote:
Hi
You can hide all unwanted col rows and protect
there is prob, i tried one formula {=A10=today()}, but its not getting
highlight, might be because of vlookup, example i added vlookup formula,
for A10, based on A10 cell date, I need to highlight A1:A10
On Thu, Jun 27, 2013 at 4:04 PM, Divaker Pandey divake...@gmail.com wrote:
See in
use conditional formatting.
On Thu, Jun 20, 2013 at 2:02 PM, thameem thamee...@gmail.com wrote:
Dear Members,
plz help me to get formuale for high-lighting selected cells
automatically, when value of one cell get 0 or 1 etc
regards
Thameem.M
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
thank you
On Fri, Jun 21, 2013 at 5:50 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
use conditional formatting.
On Thu, Jun 20, 2013 at 2:02 PM, thameem thamee...@gmail.com wrote:
Dear Members,
plz help me to get formuale for high-lighting selected cells
automatically, when value of
Try this.
On Wed, May 29, 2013 at 1:17 PM, vikas khen vikk...@gmail.com wrote:
Hi Team,
I have one excel sheet in which i need to arrange the data in such a
manner that all the data will come with the help of transpose option under
the one by one. i had try this by many methods but
*Hi Team,*
thank you very much for helping me
Regards
On Wed, May 29, 2013 at 1:46 PM, priti verma pritiverma1...@gmail.comwrote:
Solution with formula.
PFA
On Wed, May 29, 2013 at 1:17 PM, vikas khen vikk...@gmail.com wrote:
Hi Team,
I have one excel sheet in which i need to arrange
Dear Anil,
Please find the attached file.
One more help needed.
In the attached file there is three sheets.
First sheet is the data where i will update week on week. By the end of
month i have to prepare the report as in third sheet.
actually what i do.. i will collate the week on week data to
Dear Maksood,
Pls see attachment hope it will help to you.
On Tue, May 7, 2013 at 6:05 PM, maksood alam 786maks...@gmail.com wrote:
Hi guys,
I have to select two dates, start date and end date. e.g. start date is
31/dec/2012 and end date is 31/jan/2014, then it should start range from
Hi maksood,
you can use series function with column selection..and in step value put 7
and Stop value put end date
[image: Inline image 1]
On Tue, May 7, 2013 at 6:05 PM, maksood alam 786maks...@gmail.com wrote:
Hi guys,
I have to select two dates, start date and end date. e.g. start date
Noorain bhai,
Need it throgh Vba Coding.
On Tue, May 7, 2013 at 6:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Maksood,
Pls see attachment hope it will help to you.
On Tue, May 7, 2013 at 6:05 PM, maksood alam 786maks...@gmail.com wrote:
Hi guys,
I have to select two
Does this help ?
On Fri, Apr 12, 2013 at 1:56 PM, kishwar.sha...@gmail.com wrote:
I have worked on macros but not at a advanced level. Now i have been asked
to do the following and need help
1. list down all excel files if a folder is selected by a user. i have
created the browse button
Thanks Abhishek..
This is really very usefull..
Regards,
Rahim
On Fri, Apr 12, 2013 at 2:59 PM, Abhishek Jain abhishek@gmail.comwrote:
Sorry the earlier file fetches all files from a folder.
If you want to list only excel files or of any other type, this gives an
excellent choice.
Thanx!! to all of you
it has solved my query completely.
Regards,
Deepak
On Wed, Apr 3, 2013 at 10:58 AM, prafull jadhav prafulltjad...@gmail.comwrote:
Dear Anil,
Ok..thanks .
Can you clear one things here ..is there any different between validation
and drop down box is taken from
Dear Praful,
There is plenty of difference between Data Validation and a drop down box
from the developer tab.
The list box in the data validation or data validation in general is used
for validating an entry which adheres to specified condition or not.For
example when a cell or range of cells
Try the attachment . double click on cell f3-f5
Regards
Ashish
On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi
Kindly find attached ,
i need a graph which change as i select the desired cell.
suppose if i want to see sales then when i wil select Sale cell the
Thanx Ashish!!
Regards,
Deepak
On Tue, Apr 2, 2013 at 7:24 PM, ashish koul koul.ash...@gmail.com wrote:
Try the attachment . double click on cell f3-f5
Regards
Ashish
On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi
Kindly find attached ,
i need a graph
Dear Deepak,
Pl see the attached sheet. Is it OK.
Warm Regards,
Gawli Anil
On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi
Kindly find attached ,
i need a graph which change as i select the desired cell.
suppose if i want to see sales then when i wil select
Dear Praful,
Yes it is right. but even me didn't 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
Dear Anil,
Ok..thanks .
Can you clear one things here ..is there any different between validation
and drop down box is taken from developer menu
Regards,
Prafull.
On Wed, Apr 3, 2013 at 10:48 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Praful,
Yes it is right. but even me didn't
First of all, .xlsx files are designed SPECIFICALLY to remove all modules when
the file is saved.
(Microsoft hoped to use this as a mechanism to reduce the spread of viruses)
Second, when you save the file, close and reopen it, (assuming .xlsm or .xlsb
format)
is the macro module still there?
Dear All,
Hope you will be well. here is attached the excel workbook Stock Count
Report.xls.in this work book has many sheet as by people name, i want to
developed dashboard by showing data by each people of his outlets and each
day as of brand wise and summary per people sheet name.
please
I really don't understand what you want. Please attac a dashboard sheet
like you want it with the relevant column headings and the data for at
least 2 of the rows
On Tuesday, 29 January 2013, Pankaj Singh wrote:
Dear All,
Hope you will be well. here is attached the excel workbook Stock
Thanks for the help, Ashish. I'll play around with it and see if I can get
it to work for me.
Richard
--
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 Help,
Dear Pankaj,
Pl share a workbook with us.
Warm Regards,
Gawli Anil
On Tue, Jan 29, 2013 at 1:16 AM, David Grugeon da...@grugeon.com.au wrote:
I really don't understand what you want. Please attac a dashboard sheet
like you want it with the relevant column headings and the data for at
least
Hi Richard
just a suggestion - Why don't u consolidate/ merge all the input sheets to
single then create a simple pivot table for ur analysis
below macro will merge data from multiple sheets to single you might have
to do minor changes so that it meets your requirement
Sub merge1()
Dim i As
Dear Noorain Sir,
Thanks for your valuable support.
Thanks
Ashish Kumar
On Thursday, January 10, 2013 1:13:59 PM UTC+5:30, NOORAIN ANSARI wrote:
Dear Ashish,
You can try,,
For date
=date(year(a1),month(a1),day(a1)
and press ctrl+shift+#
For time
=date(Hour(a1),minute(a1),second(a1)
Dear Senior,
Thanks for your reply support. I'll keep this in my mind for better
future assistance.
Thanks
Ashish kumar
On Thursday, January 10, 2013 1:03:01 PM UTC+5:30, Ms-Exl-Learner wrote:
Please make it in an excel workbook and send it to us for our better
understanding of your
Please make it in an excel workbook and send it to us for our better
understanding of your data structure.
On 10-01-2013 1:01 PM, kumar.ashish861 wrote:
Dear Seniors,
Pls help to seperate date time, if both are in 1 cell.
7/11/2012 13:51
Formula req..!
Thanks in advance
Ashish
Hi, Thank you very much. This is simply superb. :-)
On 08/01/2013, Swapnil Palande palande.swapni...@gmail.com wrote:
Hi Mathan,
Pls find attached excel for solution.
Open the attached excel and press Ctrl + q to run macro.
I have added extra 2 columns (Pieces Remain and Total Length) for
Hi Jocky,
Please find attached with solution.
Regards,
Anoop
Sr. Developer
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I have attached one excel sheet in wich i need to set the formula for the
person for the entire week.i.e is if one person is working
Hi Anoop,
There is No formula in the attached sheet, :(
On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Jocky,
Please find attached with solution.
Regards,
Anoop
Sr. Developer
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta jocky6...@gmail.com wrote:
Hi
please see if this helps...
On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Anoop,
There is No formula in the attached sheet, :(
On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Jocky,
Please find attached with solution.
Regards,
Hi Jocky,
Formula's been written in validation rule which will restrict any entry
other entry except 9:00:00 for Mon-Thu and 12:00:00 for Sat - Sun.
Try to write something there, you'll get error prompting to enter valid
values.
On Fri, Jan 4, 2013 at 7:11 PM, ashwani agnihotri
Hi Jocky,
Made changes in sheet removing validation to show up the values there. Find
attached the updated one.
On Fri, Jan 4, 2013 at 8:38 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Jocky,
Formula's been written in validation rule which will restrict any entry
other entry except
Hi Jocky,
I have been given to simple way solution. Please find the
attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I have attached one excel sheet in wich i need to set the formula for the
Hi Dhaval,
PFA...
Regards,
Anoop
Sr. Developer
On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah todhavals...@gmail.com wrote:
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
other ways for shortening the formula
=IF(A2=FALSE,B2,A2)
or
=SUBSTITUTE(A2B2,FALSE,)
On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Dhaval,
PFA...
Regards,
Anoop
Sr. Developer
On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah
IF(A2,A2,B2)
Regards
David Grugeon
On 10 December 2012 15:20, The Viper viper@gmail.com wrote:
other ways for shortening the formula
=IF(A2=FALSE,B2,A2)
or
=SUBSTITUTE(A2B2,FALSE,)
On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma
aks.sharm...@gmail.comwrote:
Hi Dhaval,
THANKS A LOT
On Mon, Dec 10, 2012 at 11:59 AM, David Grugeon da...@grugeon.com.auwrote:
IF(A2,A2,B2)
Regards
David Grugeon
On 10 December 2012 15:20, The Viper viper@gmail.com wrote:
other ways for shortening the formula
=IF(A2=FALSE,B2,A2)
or
=SUBSTITUTE(A2B2,FALSE,)
On Mon,
Before importing data use the following function
=clean(your expression)
On Fri, Nov 9, 2012 at 5:39 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
but how?
Can you help me please.
On 11/9/12, Anoop K Sharma aks.sharm...@gmail.com wrote:
Use Clean function
On Fri, Nov 9, 2012 at
but how?
Can you help me please.
On 11/9/12, Anoop K Sharma aks.sharm...@gmail.com wrote:
Use Clean function
On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay
mangesh.da...@gmail.comwrote:
Hi Friends,
I need your help.
I have Excel file containing some data. I have import this data to MS
Use Clean function
On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay mangesh.da...@gmail.comwrote:
Hi Friends,
I need your help.
I have Excel file containing some data. I have import this data to MS
Access 07 table by using Append query.
But when I access the table, it contains some
Dear Neeraj,
Try this one and drage to down.
=DATE(D3,C3,B3)
Regards,
Kuldeep Singh
On Wed, Oct 31, 2012 at 11:55 AM, Neeraj neerajchauhan...@gmail.com wrote:
Dear Experts,
** **
Kindly find the attached sheet and resolve the problem….
--
Join official facebook page of this
Pl find attached sheet for you info.
Excuse typo errors...
Regards,
Gawli Anil
On Wed, Oct 31, 2012 at 11:55 AM, Neeraj neerajchauhan...@gmail.com wrote:
Dear Experts,
** **
Kindly find the attached sheet and resolve the problem….
--
Join official facebook page of this forum @
thanks kuldeep
On Wed, Oct 31, 2012 at 12:00 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Dear Neeraj,
Try this one and drage to down.
=DATE(D3,C3,B3)
Regards,
Kuldeep Singh
On Wed, Oct 31, 2012 at 11:55 AM, Neeraj neerajchauhan...@gmail.comwrote:
Dear Experts,
** **
=DATE(D2,C2,B2)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj
Sent: 31 October 2012 11:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help
Dear Experts,
Kindly
Is the 200 workbooks the ONLY files in the folder C:\EBACKUP ?
If so, you can place this macro in a standard module of your master workbook:
Sub CopyData()
Dim fso, Fldr, fl, fc, f
Dim Sht
Sht = Option Letter
Fldr = C:\EBACKUP\
Application.ScreenUpdating = False
Set fso
http://accessvbaprogramming.wordpress.com/2012/09/18/type-sql-query-in-text-box-in-access-form-and-export-output-to-excel/
On Sun, Oct 28, 2012 at 3:12 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
Dear Friends,
I am using MS Access 2007.
I need VBA code to export the result of the any
attach the sample file
On Sat, Oct 27, 2012 at 10:41 PM, Rupendra Phatak rup...@gmail.com wrote:
Hi Friends,
I am having data in a excel which contains records of maturity
deposits/securities in different. sheets the only common field is
Maturity Date in all sheets.
Now what i need is to
Please help.
On Oct 15, 2012 8:08 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:
Dear Experts,
Please help me with Macro. I need to assign a auditor for each Policy and
create worksheet for each auditor in same workbook by copy the policy to it.
Kindly refer the attached file. Based
Dear Amol,
You have try through Developer tab..
On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav asja...@gmail.com wrote:
Hello experts,
I need help related to following things
1) How to import xml file in excel using VBA
2) how to export xml file using vba
Regards,
Amol J
--
Join
Yes, I am able import and export it using devloper tab,
Is it posible using VBA??
Thanks
Amol
On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Amol,
You have try through Developer tab..
On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help related to XML with excel
Yes, I am able import and export it using devloper tab,
Is it posible using VBA??
Thanks
Amol
On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI
noorain.ans
--
*From: *Amol Jadhav asja...@gmail.com
*Sender: *excel-macros@googlegroups.com
*Date: *Thu, 11 Oct 2012 11:54:30 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: *excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Need Help related to XML with excel
Yes, I am able import
=COUNTIFS(A2:A12,Karthik,B2:B12,Collected)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karthik N
Sent: 05 October 2012 8:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need
Dear Karthik,
In 2003 Version you can also use
*=SUMPRODUCT(--(B4:B14=Karthik)*($C$4:$C$14=Collected))*
On Fri, Oct 5, 2012 at 8:23 PM, karthik N n.karthi...@gmail.com wrote:
Hi Friends
Need help
How many cases are collected in karthik, pls send me a any formula
*name* *status*
See the attached file, its siolved
Ashish
On Thu, Oct 4, 2012 at 7:14 PM, karthik N n.karthi...@gmail.com wrote:
Hi Team,
Please help in the attachment file
Regards
karthik.N
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
Sub export_range_as_table()
' add a reference to the Word-library
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
'add refrence microsoft word
Dim wrdTable As Word.Table
Dim datacell
Set wrdApp = CreateObject(Word.Application)
Set wrdDoc = wrdApp.Documents.Add ' create a new document
Are you saying that you want to HIDE COLUMNS??? Please define your problem with
examples if possible.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Thursday, September 20, 2012 1:10 AM
To: excel-macros@googlegroups.com
Subject:
-
From: Vabz in.vaib...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 8:59:52 AM
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
hi..
what i feel is this solution is very complex !!
Rgds//Vabz
On Tuesday, September 11, 2012 7:09:23 AM
And, I wonder why he insists.. Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, September 12, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three
Its really Great Help Asa !!!
Thanks a ton !!!
On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Mangesh,
I've read your other replies, and as to why you haven't received a formula
method -- most people don't want to take the trouble on a volunteer basis
to
Homework done...
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Tuesday, September 11, 2012 4:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Its really Great Help
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
Hi Friends,
I need your help to divide the string into three parts.
The description and sample is given below :
[image: Inline image 1]
Waiting for your
Yes u r right.
I did by using Text to Column option. Its works fine.
But I need it by using formula.
Thanks
On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh
Hi Mangesh..
PFA.. Cheers
Rgds//Vabz
On Monday, September 10, 2012 4:41:13 PM UTC+5:30, Mangesh wrote:
Yes u r right.
I did by using Text to Column option. Its works fine.
But I need it by using formula.
Thanks
On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar
In B2 put =LEFT(A2,FIND(,,A2)-1)
In C2 put =MID(A2,LEN(B2)+2,FIND(,,A2,LEN(B2)+2)-LEN(B2)-2)
In d2 put =MID(A2,LEN(B2C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay mangesh.da...@gmail.com wrote:
Hi Friends,
I need your help to divide the string into three parts.
The description and
Thanks ALL for the Great Help !!!
On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon da...@grugeon.com.au wrote:
In B2 put =LEFT(A2,FIND(,,A2)-1)
In C2 put =MID(A2,LEN(B2)+2,FIND(,,A2,LEN(B2)+2)-LEN(B2)-2)
In d2 put =MID(A2,LEN(B2C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay
: $$Excel-Macros$$ Need help - To divide the string into three parts
Yes u r right.
I did by using Text to Column option. Its works fine.
But I need it by using formula.
Thanks
On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote:
Dear Mangesh,
you can use text
-Macros$$ Need help - To divide the string into
three parts
Yes u r right.
I did by using Text to Column option. Its works fine.
But I need it by using formula.
Thanks
On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar
kumarmanoj.11...@gmail.comwrote:
Dear Mangesh,
you can use text to colum
As I said, I would simply use TTC
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Monday, September 10, 2012 9:24 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi
mangesh.da...@gmail.com
*Sent:* Monday, September 10, 2012 6:11 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into
three parts
Yes u r right.
I did by using Text to Column option. Its works fine
Hi Mangesh,
I've read your other replies, and as to why you haven't received a formula
method -- most people don't want to take the trouble on a volunteer basis to
provide a more complex or difficult solution to a given problem when simple
solutions exist. Also in business, the simplest solution
Pl use a meaningful subject for immediate response on your issues
On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert,
Please help me to find rank in attached file..
Regard
Manoj
--
Join official facebook page of this forum @
Dear Pravin,
Please provide ans..
Regard
Manoj
On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.com wrote:
Pl use a meaningful subject for immediate response on your issues
On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert,
Please
Dear Manoj,
Please try it in Range(M2), Hope it will help to you.
otherwise
Please explain more
On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Pravin,
Please provide ans..
Regard
Manoj
On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.com
Hi Manoj,
Find the attached file.
use this formula hope it will help you.
=RANK(B2,$B$1:$B$6,0)
if you need anything else Pls explain properly.
Regards
Amresh
On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Pravin,
Please provide ans..
Regard
Manoj
Hi Amresh,
Required output is not match.
*Your Ans*
*Required Ans*
*1*
4
4
1
1
2
2
4
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi Manoj,
Find the attached file.
use this formula hope it will help you.
Thanks for all
Amresh's formula is ok for me..
Regard
manoj
On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi Manoj,
Find the attached file.
use this formula hope it will help you.
=RANK(B2,$B$1:$B$6,0)
if you need anything else Pls explain properly.
201 - 300 of 656 matches
Mail list logo