you should choose .xlsx format while saving your workbook
On Tue, Mar 12, 2013 at 11:35 AM, Chaya wrote:
> Sir, i am using Ms office 2010.
>
> -Chaya
>
>
> On Tue, Mar 12, 2013 at 11:28 AM, The Viper wrote:
>
>> what version of excel are you using?
>> Ëx
did save as than, please suggest
> experts..
>
> Thanks,
> Chaya
>
>
> On Tue, Mar 12, 2013 at 11:19 AM, The Viper wrote:
>
>> you cannot view more than 65536 rows in prior versions of excel.
>> if your excel version is 2007 or above, choose .xlsx file forma
you cannot view more than 65536 rows in prior versions of excel.
if your excel version is 2007 or above, choose .xlsx file format while
saving your workbook.
On Tue, Mar 12, 2013 at 11:05 AM, Chaya wrote:
> Dear Experts,
>
> I have a data base which contains more than 1 lacs rows
=SUBSTITUTE(A1,CHAR(10)," ")
On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh wrote:
>
> Hi,
>
> I want to remove all enter.
>
> Regards,
> Kuldeep Singh
>
> --
> 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 for
Thanks a lot everybody who give time for my solution.
>> Regards
>> Amar
>>
>>
>> On Fri, Mar 1, 2013 at 9:33 AM, The Viper wrote:
>>
>>> I don't understand Mr.Bé Trần Văn
>>>
>>>
>>> On Thu, Feb 28, 20
Hello xlstime!
Your formula won't work
Values in the array will be multiplied by 0 if it dose not meets the
criteria. It will be multiplied by 1 if it meets the criteria.
So using MIN function in SUMPRODUCT will give 0, if there is any value in
the array which does not meets the criteria.
O
I don't understand Mr.Bé Trần Văn
On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn wrote:
> Learn test.
>
>
> 2013/2/28 The Viper
>
>> can't get throuh formula?
>>
>> pfa
>>
>>
>>
>> On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey
can't get throuh formula?
pfa
On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey wrote:
> solved .
>
>
> On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote:
>
>> Dear All,
>>
>> I have facing some hyperlink issue in sheet,I attached sheet in detailed
>> information,Pls tell me It is possible?
>
"Maruti Kadam" is available in a9. but the original named range is
"Maruti_Kadam". an underscore is missing.
On Thu, Feb 28, 2013 at 12:54 PM, amar takale wrote:
> Dear All,
> I have Data validation sheet in which In output sheet cell B6,I put data
> validation with Indirect formula that time I
you can attach it as an object
On Tue, Feb 26, 2013 at 9:40 AM, अनिल नारायण गवली
wrote:
> Dear Amar,
>
> Yes it is possible with hyperlink
>
> just give the right url and save it.
>
> Pl see the attached sheet.
>
> Warm Regards,
> Gawli Anil.
>
> On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote:
>
s written it is not working. Again for strange reason where 2.30 was
> written after converting it become 2:03. Don't know why! Pls suggest!
>
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
> ----------
> *From: * The Viper
> *Sender: *
select the data and press ctrl+h
put .(dot) in "Find what" and put ":" in "Replace with"
click Replace all
On Fri, Feb 22, 2013 at 3:41 PM, wrote:
> Dear excel guru,
> I have a problem...I want my hour to be written as 4:45. But I entered
> 2 data as 4.45. Now if I am changing it to [h]:mm f
on't print this e-mail unless
> you really need to.*
>
> On Thu, Feb 21, 2013 at 3:57 PM, The Viper wrote:
>
>> assuming your date is in a1
>> =a1+7
>>
>>
>> On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh
>> wrote:
>>
>>>
assuming your date is in a1
=a1+7
On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh wrote:
>
> Hi All,
>
> One instant query. my format is 18/02/2013 & I want to add 7 days. Please
> help
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-4841100, Extn.: 2467,
pfa and check formula in conditional formating
On Wed, Feb 13, 2013 at 4:45 PM, Amit Gandhi wrote:
> Hi Experts
>
> I want to highlight minimum value of some particular columns say columns
> D,H,L in attached file through Conditional Formatting. How it can be
> possible? Pls help me here.
>
> Re
did you try =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10))
with CSE ???
On Thu, Feb 7, 2013 at 2:44 PM, Smitha S R wrote:
> Hi,
> Required is :
>
>
> Count of names matching product 'A' and Id '1S' is 4
> and count of names matching product 'A' and ID '2B' is 4
>
>
> On Thu, Feb 7,
use =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10)) with CSE
On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote:
> You can use:
>
> =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2)
>
> Aamir Shahzad
>
> On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote:
>
>> Hi,
>>
>> Please help me in findin
pfa
you can modify the range on formula as desired.
On Wed, Feb 6, 2013 at 9:34 AM, John A. Smith wrote:
> Paul,
>
> #1) By using conditional formatting, highlight any row the EXACT target
> value is in regardless of the column it's in
> #2) Has to be an EXACT match
> #3) Helper columns are okay
Dear Excel Learner,
*"You can also try"* Google stats will show you in active posters list and
you will get more counts.
On Fri, Jan 18, 2013 at 4:39 PM, Ms-Exl-Learner wrote:
> Hm... No one is understanding what I am trying to say...
>
> It's not only about this post, I am also talking about
What you're asking is not possible without helper column.
here is my openior. PFA
On Thu, Jan 10, 2013 at 5:39 PM, Hilary Lomotey wrote:
> Thanks Noorain,
>
> for what am trying to do, i need a formula instead. But that is the exact
> principle of what i was explaining. thanks
>
>
> On Thu, Jan
=MAX(IF(A1:A8=D1,ROW(A1:A8),""))
with CSE
On Thu, Jan 10, 2013 at 4:41 PM, Hilary Lomotey wrote:
> Hi Experts,
>
> In the attached, i have a list of items, some are repetitive in the list,
> if i want to find the relative position of each item what formula can be
> helpful, the normal match will
use
=REPLACE(A1,1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))-1)),"")
or
=MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))-1))+1,255)
On Thu, Jan 10, 2013 at 9:28 AM, Jaideep Panchal wrote:
> Hi Noorain,
>
> ** **
>
> Thanks for a quick response
ignore previous one.
pfa
On Sat, Jan 5, 2013 at 11:49 AM, The Viper wrote:
> pfa
>
>
> On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi wrote:
>
>> Here is the anwser, I have attached a file with solution. Please reply if
>> you want this?
>>
>> ---
pfa
On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi wrote:
> Here is the anwser, I have attached a file with solution. Please reply if
> you want this?
>
> --- On *Fri, 1/4/13, harshad shukla * wrote:
>
>
> From: harshad shukla
> Subject: $$Excel-Macros$$ Vlookup for two same values
> To: excel-m
apply the filter before protecting the sheet.
select the options "use filters" in sheet protection dialogue box
On Fri, Jan 4, 2013 at 3:17 PM, अनिल नारायण गवली wrote:
> Dear Dhaval,
>
> Hide the formula bar which is availabale in options tab of workbook.
>
>
> Thanks & Regards,
> Gawli Anil
>
>
Still finding the necessity for the lengthiest code from prince.
It can be achieved in few clicks through excel built in option called
"Remove Duplicates".
Assuming OP is using excel 2007 or later versions as he is working with 6
lakh records.
The below code is enough, even if we want to write in
Ayush,
Nowadays lots of spam in group. Moderators should be cautious
2013/1/4 سمية صفار
> اول موقع سكس شوب عربي
> يتميز المتجر بالمصداقية العالية و الموثوقية الكبيرة
> الاسعار المنافسة و الجودة العالية
> توفير كل طرق الدفع السهلة و المتاحة
> ضم الاف المنتجات الجنسية المتنوعة
> شحن الى الدول ال
""),"?",""),"<",""),">",""),"|",""),"""",""))
ask me if you have any doubts in this
On Thu, Jan 3, 2013 at 12:27 PM, The Viper wrote:
> place the name on a1
> belo
place the name on a1
below formula should work with CSE
=IF(SUM(IFERROR(FIND({"/","\","?","<",">","|","*",},A1),""))>0,"Wrong","Ok")
On Wed, Jan 2, 2013 at 8:34 PM, wrote:
> In excel 2012 I'm using the name typed in a cell as a part of the filename
> when saved via a macro.
> Because the fol
slightly modified your code.
check the attachment
On Thu, Jan 3, 2013 at 8:47 AM, Awal wrote:
> Hello,
> I would like to wish y'all a Happy New year...
> I am still learning VBA and I really need help:
> I want to be able to look up for an item and change its price.
> See attached file.Can some
Hi lalit
I don't find any need for that. just working as required by OP
On Wed, Jan 2, 2013 at 3:15 PM, Lalit Mohan Pandey wrote:
> Nice formula viper but the last space is missing.
>
>
> On Wednesday, 2 January 2013 15:07:20 UTC+5:30, §»VIPER«§ wrote:
>
>> =LEFT(A1,MIN(IFERROR(FIND({0,**1,2,3,
=LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),""))-1)&SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),"")),255),"
","")
this should work with CSE
On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal wrote:
> It's absolutely working fine.
>
> Pravin Gunjal
>
>
> -- Forwarded
for low value date its not working psl chk
>
> thanks
>
>
> On Mon, Dec 24, 2012 at 5:17 PM, The Viper wrote:
>
>> use
>>
>> =INDEX($C$2:$C$3000,MATCH(F2&MAX(IF($A$2:$A$3000=F2,$B$2:$B$3000,0)),$A$2:$A$3000&$B$2:$B$3000,0))
>> with CSE
>
use
=INDEX($C$2:$C$3000,MATCH(F2&MAX(IF($A$2:$A$3000=F2,$B$2:$B$3000,0)),$A$2:$A$3000&$B$2:$B$3000,0))
with CSE
On Mon, Dec 24, 2012 at 4:24 PM, Dhaval Shah wrote:
> *Hello Prince *,
>
> pls help me out lastly u send me one file as per my requirement but some
> how i facing problem with your fil
another approach
works even if dates are not sorted
pfa
On Tue, Dec 11, 2012 at 10:21 AM, Pravin Gunjal wrote:
> *Good one. Thanks Anoop.*
>
> -- Forwarded message --
> From: Anoop K Sharma
> Date: Tue, Dec 11, 2012 at 8:19 AM
> Subject: Re: $$Excel-Macros$$ Pl Solve my date que
other ways for shortening the formula
=IF(A2=FALSE,B2,A2)
or
=SUBSTITUTE(A2&B2,"FALSE","")
On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma wrote:
> Hi Dhaval,
>
> PFA...
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah wrote:
>
>>
>> --
>> Join of
below is the solution if i understood your requirement correctly
=IFERROR(INDEX(G$5:G$11,SMALL(IF(F$5:F$11=I$5,ROW(F$5:F$11),""),ROW()-4)-4),"")
with CSE
pfa
On Tue, Dec 4, 2012 at 6:19 PM, Paul Schreiner wrote:
> Noorain,
>
> In what way do you wish to make it more "dynamic"?
>
> How do you use
pfa
On Sat, Oct 27, 2012 at 3:06 AM, Viswanathan Yoganathan <
viswanathan.yoganat...@asia.xchanging.com> wrote:
> HI,
>
> ** **
>
> In the first column we have is year, based upon the month of the year it
> should fix into 4 quarters as shown in the below example.
>
> ** **
>
> *Year*
pfa
On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar wrote:
> Dear Expert,
>
>
> Request you to kindly help me on this matter...
> Please find the attachment..
>
> I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show
> 9564
>
>
>
>
> Regard
> Manoj
>
> --
> Join official facebook
here is my co-operation on your project
pfa
On Wed, Oct 3, 2012 at 1:38 PM, SAJID MEMON wrote:
> Dear Expert,
>
> I require your co-operation to complite my project. I have attached a
> require file in excel 2003. Please give me details with code to complite my
> project.
>
> Awiting your posit
well done rajan...
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> May'2012
> He has posted 147 posts in May 2012 and helped many people through his
> expertise.
>
> I truly appreciate his consist
Congrats Rajan..
On Thu, May 3, 2012 at 10:58 AM, Maries wrote:
> *Congrats Brother.*
>
>
> On Wed, May 2, 2012 at 8:15 PM, xlstime wrote:
>
>> Congratulation Rajan
>>
>> On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote:
>>
>>> Hello Everyone,
>>>
>>> Rajan Verma has been selected as
also you can use the below formula if you are using ms office 2007 or
later versions
=sumifs(d3:d409,g3:g409,">350", g3:g409,"<450")
On Mon, Apr 9, 2012 at 10:11 AM, Maries wrote:
> Hi,
>
> Try Below Formulas,
>
> =SUMPRODUCT(--((G3:G409>350)*(G3:G409<450))*D3:D409)
>
> =SUM(IF(--(G3:G409>35
=COUNTIF($A$2:$A$1393,A2)
or
=COUNTIF(A:A,A2) in a2 and copy down
On Sat, Apr 7, 2012 at 12:32 PM, Mohammed Muneer wrote:
> Please find the attachment.
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,
>
> CC...
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED
attachment??
On Sat, Apr 7, 2012 at 12:08 PM, Mohammed Muneer wrote:
> Dear friends can u please check the attached for the above subject.
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,
>
> CC...
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
in b2 =--LEFT(A2,FIND("+",A2)-1)
in c2 =IF(ISNUMBER(--(A2)),0,RIGHT(A2,LEN(A2)-FIND("+",A2)))
or =iferror(RIGHT(A2,LEN(A2)-FIND("+",A2)),0)
On Sat, Apr 7, 2012 at 10:51 AM, anil kumar wrote:
>
>
> On Sat, Apr 7, 2012 at 10:50 AM, anil kumar wrote:
>
>> Hi Friends,
>>
>> can anybody solve th
if your file name is exactly sample.xlsx then use
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
On Thu, Feb 16, 2012 at 6:07 PM, The Viper wrote:
> is "C:\Documents and Settings\priyanka\desktop\sample" the right path of
ords need to change ?
>
>
>
> CLS
> C:
> CD "C:\Documents and Settings\priyanka\desktop\sample"
> DEL /q /s /f "sample.xlsx"
>
> change the path and you can use the wildcards like below
>
> DEL /q /s /f "*sample.xlsx"
> or
> DEL /q /s /
paste the below code in notepad and save it with .bat extension and run
CLS
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
change the path and you can use the wildcards like below
DEL /q /s /f "*sample.xlsx"
or
DEL /q /s /f "sample*.xlsx"
On Thu, Feb 16
try this
Sub GetColumnRef()
Dim mSht
mSht = ActiveSheet.Name
Dim MyInput
MyInput = InputBox("Enter Column to Search eg D:5")
Sheets.Add.Name = MyInput
Sheets(mSht).Activate
End Sub
On Thu, Feb 16, 2012 at 12:09 PM, NOORAIN ANSARI
wrote:
> Dear Cab,
>
> Please try it..
>
> Sub GetColumnRef()
>
in addition to noorain formula you can use
=sumproduct(1/COUNTIF(A1:A356,A1:A356) without ctrl+shift+enter
On Wed, Feb 15, 2012 at 1:56 PM, NOORAIN ANSARI wrote:
> Dear Muneer,
>
> Please use..
>
> =SUM(1/COUNTIF(A1:A356,A1:A356)
> with ctrl+shift+ENter.
>
> See attached sheet.
> On Wed, Feb 1
its working fine.
now i have wrote two types of formulas
go through the attachment.
On Wed, Feb 8, 2012 at 4:53 PM, Ashish Bhalara wrote:
> Maximum number is 1003, not display in your formula
>
>
> On Wed, Feb 8, 2012 at 4:49 PM, The Viper wrote:
>
>> hi ashish
>>
hi ashish
use =MAX(--REPLACE(A2:A41,1,9,"")) with CSE
On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara wrote:
> Dear expert,
>
> I want to formula of maximum number find from a different list which
> example attached herewith.
>
> Thanks & regards
>
> Ashish Bhalara
>
> --
> FORUM RULES (986+ m
hi
check the attachment
On Sat, Feb 4, 2012 at 12:02 AM, raghu gr wrote:
> Hi experts,
>
> I have a invoice file and summary file, i want the formula in rate column,
> which has to pick from rate sheet.
> please help me in this regard
>
> Attached sample file
>
> Thank you
>
> with regards
>
please find the attached
On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Experts,
>
> Please See the attachment and Help me regarding VLOOKUP FUNCTION
>
> Thanking you in Advance
>
> Sanjib
>
>
>
>
>
>
>
>
>
> --
> -
>
> --
> FORUM RULES (986+ m
go through the attachment
On Thu, Feb 2, 2012 at 9:25 PM, sriram ji wrote:
>
>
>
> Dear Excel Guru,
>
> Kindly provide the solution for the attached file.
>
> Thanks & Regards,
> Sriram G
> Chennai
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate th
see the attached
=IF(ISERROR(LEFT(A2,FIND("_",A2)-1)),A2,LEFT(A2,FIND("_",A2)-1))
On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Hi,
>
> ** **
>
> I have list with the values. I need only text which comes before “*_*”.
> Please find a
in ab1
=if(countif(a1:t1,aa1)>0,countif(a1:t1,aa1),"")
On Fri, Feb 3, 2012 at 10:30 AM, qcan wrote:
> Hi,
>
> Not sure how to do this.
>
> Looking for a formula (preferably) or a macro to find a number in a
> row. Kind of like a "loto checker".
>
> In this case.
>
> - There are 20 columns
check the attachment. it may help
providing sample file better than showing the data in message body
On Thu, Feb 2, 2012 at 9:55 AM, chandra sekaran wrote:
> Dear all
> Here is my dataitem & Make is same then first item amount X 10 %
> should come same items and same make below formula
dear priyanka
better you can hide data range and protect your sheet. instead of hiding
whole sheet.
or as sam said you can protect the workbook structure.
@rajan & other folks
if the macros or disabled?
if the codes are modified or deleted?
On Tue, Jan 31, 2012 at 6:55 PM, Rajan_Verma wrote:
>
see the attachment if you want to do it with combination of functions
On Wed, Dec 28, 2011 at 11:57 AM, Aamir Shahzad wrote:
> thanks for your response Dguillett1 & Rohan but when I run the macro its
> shows attached error. Please see the issue. And I don't want to remove the
> duplicates if na
61 matches
Mail list logo