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 chayamon...@gmail.com wrote:
Dear Experts,
I have a data base which contains
save as than, please suggest
experts..
Thanks,
Chaya
On Tue, Mar 12, 2013 at 11:19 AM, The Viper viper@gmail.com wrote:
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
=SUBSTITUTE(A1,CHAR(10), )
On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
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
.
Regards
Amar
On Fri, Mar 1, 2013 at 9:33 AM, The Viper viper@gmail.com wrote:
I don't understand Mr.Bé Trần Văn
On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn betnmtdongna...@gmail.com
wrote:
Learn test.
2013/2/28 The Viper viper@gmail.com
can't get throuh formula?
pfa
can't get throuh formula?
pfa
On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey divake...@gmail.com wrote:
solved .
On Thu, Feb 28, 2013 at 3:41 PM, amar takale amartak...@gmail.com wrote:
Dear All,
I have facing some hyperlink issue in sheet,I attached sheet in detailed
I don't understand Mr.Bé Trần Văn
On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
Learn test.
2013/2/28 The Viper viper@gmail.com
can't get throuh formula?
pfa
On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey divake...@gmail.comwrote:
solved
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.
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 amartak...@gmail.com wrote:
Dear All,
I have Data validation sheet in which In output sheet cell B6,I put data
validation with Indirect
you can attach it as an object
On Tue, Feb 26, 2013 at 9:40 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
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
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, chhajersand...@gmail.com 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
there is only 8
is 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 viper@gmail.com
*Sender: * excel
assuming your date is in a1
=a1+7
On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
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,
you really need to.*
On Thu, Feb 21, 2013 at 3:57 PM, The Viper viper@gmail.com wrote:
assuming your date is in a1
=a1+7
On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh
naukrikuld...@gmail.comwrote:
Hi All,
One instant query. my format is 18/02/2013 I want to add 7 days.
Please
pfa and check formula in conditional formating
On Wed, Feb 13, 2013 at 4:45 PM, Amit Gandhi silkyro...@gmail.com 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
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 aamirshahza...@gmail.comwrote:
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 sperdwo...@gmail.com wrote:
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 sperdwo...@gmail.com 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
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 ms.exl.lear...@gmail.comwrote:
Hm... No one is understanding what I am trying to say...
It's not only about this post, I am
=MAX(IF(A1:A8=D1,ROW(A1:A8),))
with CSE
On Thu, Jan 10, 2013 at 4:41 PM, Hilary Lomotey resp...@gmail.com 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
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 resp...@gmail.com 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
Ayush,
Nowadays lots of spam in group. Moderators should be cautious
2013/1/4 سمية صفار trainlove10...@gmail.com
اول موقع سكس شوب عربي
يتميز المتجر بالمصداقية العالية و الموثوقية الكبيرة
الاسعار المنافسة و الجودة العالية
توفير كل طرق الدفع السهلة و المتاحة
ضم الاف المنتجات الجنسية
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
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, अनिल नारायण गवली gawlianil8...@gmail.comwrote:
Dear Dhaval,
Hide the formula bar which is availabale in options tab of workbook.
Thanks Regards,
pfa
On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi ravi_colw...@yahoo.comwrote:
Here is the anwser, I have attached a file with solution. Please reply if
you want this?
--- On *Fri, 1/4/13, harshad shukla er.harshad.shu...@gmail.com* wrote:
From: harshad shukla er.harshad.shu...@gmail.com
ignore previous one.
pfa
On Sat, Jan 5, 2013 at 11:49 AM, The Viper viper@gmail.com wrote:
pfa
On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi ravi_colw...@yahoo.comwrote:
Here is the anwser, I have attached a file with solution. Please reply if
you want this?
--- On *Fri, 1/4/13
from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Great day,*
*viper*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
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 mohan.pande...@gmail.com
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
slightly modified your code.
check the attachment
On Thu, Jan 3, 2013 at 8:47 AM, Awal malaw...@gmail.com 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
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, dannymari...@gmail.com 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 following
/excel-macros?hl=en.
--
*Great day,*
*viper*
--
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,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
date its not working psl chk
thanks
On Mon, Dec 24, 2012 at 5:17 PM, The Viper viper@gmail.com wrote:
use
=INDEX($C$2:$C$3000,MATCH(F2MAX(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 todhavals
MS EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Great day,*
*viper
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Great day,*
*viper*
--
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,
Urgent, Need
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Great day,*
*viper*
--
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,
Urgent
email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
--
*Great day,*
*viper*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
--
*Great day,*
*viper*
--
Join official
...@googlegroups.com.
--
*Great day,*
*viper*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
@googlegroups.com
--
*Great day,*
*viper*
--
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 may not be answered
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED for violation
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED
@googlegroups.com
--
*Great day,*
*viper*
--
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 may
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
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 /f sample*.xlsx
On Thu, Feb 16, 2012 at 5:58 PM, The Viper viper@gmail.com wrote:
paste
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 viper@gmail.com wrote:
is C:\Documents and Settings\priyanka\desktop\sample the right path of
your master folder
. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members
--
*Great day,*
*viper*
--
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 may not be answered.
2) Don't
data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM
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 ashishbhalar...@gmail.comwrote:
Maximum number is 1003, not display in your formula
On Wed, Feb 8, 2012 at 4:49 PM, The Viper viper@gmail.com wrote:
hi
and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED
--
*Great day,*
*viper*
--
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 may not be answered.
2) Don't post
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
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
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
*Great day,*
*viper*
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
*Great day,*
*viper
below link
http://www.facebook.com/discussexcel
--
*Great day,*
*viper*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Its based on your operating system.
download the first one and read the content. It will guide
--
*Great day,*
*viper*
On Fri, Sep 23, 2011 at 11:55 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello Noorain,
Could u pls let me know which one to download in the attached
of course
pfa
--
*Great day,*
*viper
*
On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I want to show a messge when we enter value which is more than 50k.As we
type 6 at that time a message show approval need.
Could it possible
Dear deepak
here is the sample formula
=If(sum(b2:b2)=100,Qualified,Not Qualified)
--
*Great day,*
*viper*
On Fri, Sep 23, 2011 at 3:04 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hil All
I have attached the file of data.
My problem is i have to find the qualifying month
file into excel window. But it wont convert
the file, that you can see the title bar after opening the file.
i would suggest that you have to import your data and save it as your
desired format.
--
*Great day,*
*viper*
On Fri, Sep 23, 2011 at 9:00 AM, NOORAIN ANSARI noorain.ans
Dear Kalyan
why don't you use
*
=SUMPRODUCT(($A$2:$A$37=F11)*($B$2:$B$37=$G$7)*(--SUBSTITUTE(C2:C37,MOC,)=--SUBSTITUTE(G8,MOC,))*(--SUBSTITUTE(C2:C37,MOC,)=--SUBSTITUTE(G9,MOC,))*$D$2:$D$37)
*
pfa
--
*Great day,*
*viper
*
On Fri, Sep 16, 2011 at 4:11 PM, Kal xcel kalx...@gmail.com wrote
hi
pfa
--
*Great day,*
*viper
*
On Thu, Sep 15, 2011 at 5:05 PM, Abhishek Jain abhishek@gmail.comwrote:
Dear Naanu,
Please check the attached sheet.
Cheers!
AJ
On Thu, Sep 15, 2011 at 4:43 PM, naanu v naanu2...@gmail.com wrote:
I have a database of some persons
Dear green
go through the attachment. it may help.
--
*Great day,*
*viper*
On Fri, Aug 26, 2011 at 10:42 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Please provide sample sheet.
On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar
impedimenta.st...@gmail.comwrote:
I have a series
Dear naanu
Go through the attachment. it may help. or please make it clear with sample
file
--
*Great day,*
*viper
*
On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote:
I want to know the formula to find out the solution.
** **
For Ex: I have two columns
Hi
please find the attachment it may help
--
*Great day,*
*viper
*
On Fri, Aug 26, 2011 at 2:13 PM, Daniel dcolarde...@free.fr wrote:
Have a look at the page :
http://support.microsoft.com/kb/106359/en-us
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com
why not?
simply use =IF(COUNTIF($A$3:$A$15,C3)=0,Text not found,Text found)
pfa
--
*Great day,*
*viper*
On Fri, Aug 26, 2011 at 4:57 PM, naanu v naanu2...@gmail.com wrote:
Thank u so much , but i want in below format
Aru fddfs Text found ihcx zesr Text found dst fddfs Text
hi jocky
pfa. it may help.
--
*Great day,*
*viper
*
On Mon, Aug 1, 2011 at 1:15 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I have one sheet in which Two Columns are there in which first Column
there is Employee id and employee name. In Second column i need the exact
,*
*viper
*
On Thu, Jul 28, 2011 at 11:23 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Try it...
{=SMALL(IF(F14:F230,F14:F23,),1)}
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Wed, Jul 27, 2011 at 6:33 PM, sundar
Hi,
pfa. it may help
--
*Great day,*
*viper
*
On Fri, Jul 29, 2011 at 9:53 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*See if it helps*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *always online
*Sent:* Friday, July 29, 2011
Hi Anwer
pfa. it may help
--
*Great day,*
*viper
*
On Thu, Jul 28, 2011 at 10:17 AM, Anwar Mohd anr7no...@gmail.com wrote:
Hi Experts,
I need a formula to summarize based on multiple crteria as per the attached
sheet.
From the data sheet i need to summarize partner revenue based
Hi
First of all I have to thank you. Unfortunately you did something for excel.
But my query is about ms access. Please find the OP. Your help will be
appreciated.
--
*Great day,*
*viper*
On Fri, Jul 22, 2011 at 7:49 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Try the Attached
be always open till the database
is open. I have removed the form control property close box from the form
but the users are still able to close the form using Cntrl+W button.
Can anyone give me the solution?
--
*Great day,*
*viper
Dear Karan find the attachment.
--
*Great day,*
*
Thamu*
On Tue, Jun 7, 2011 at 1:40 PM, karan 1237 karan1...@gmail.com wrote:
Hello Experts,
I need your assistance. I'v a workbook which has 4 sheet. I want to create
a automatically hyperlink (through formulae) when I change content
Dear kannan
find the attached solution.
--
*Thanks Regards
Thamu*
On Sat, May 28, 2011 at 6:48 PM, Omar omar27...@gmail.com wrote:
PUT THIS FORMULA IN C2
=IF(COUNTA(B:B)COUNTA(A:A);NO;INDIRECT(B COUNTA(B:B)))
*From:* excel-macros@googlegroups.com [mailto:
Hi
=ROUNDUP(5284/12,1) = 440.4
=ROUNDDOWN(440.4*12,0) = 5284
--
*Thanks Regards
Thamu
*
On Mon, May 16, 2011 at 11:57 AM, memonkavi memonk...@gmail.com wrote:
Dear sir
thanks 1nz again wat i requst that result i got from ur formula.,i
want to reverse for example i multiple 440.04 by 12
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
hi syed,
find the attached without array.
--
*Thanks Regards
Thamu
*
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi,
Hi i have attached my file i want in sheet 2 there are column c in that i
want the name from sheet 1 but there are two condition first
Hi
find the attachment. hope it will help.
--
*Thanks Regards
Thamu
*
On Wed, Mar 23, 2011 at 11:18 AM, Bhushan Sabbani bsabban...@gmail.comwrote:
Dear,
Please find the attached solved file for the same.
Please let me know was that solution helpful.
Warm Regards
Bhushan Sabbani
hi hanumant
if your text in A1 as=Sheet1!$F$4:$F$7
type the below formula anywhere in the worksheet
=MID(SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(A1,$,)),=,),
,),2,LEN(TRIM(SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(A1,$,)),=,),
,)))-2)
--
*Thanks Regards
Thamu
*
On Tue, Mar 22, 2011 at 3:11
Hi Akbar,
checkout the attachment and revert if it is not helpful.
--
*Thanks Regards
Thamu
*
On Sat, Mar 19, 2011 at 9:14 AM, Muhammad Talal Akbar
sh.talal.ak...@gmail.com wrote:
--
--
Some important
hi ashish
the same will work in 2003
--
*Thanks Regards
Thamu
*
On Sat, Mar 19, 2011 at 1:56 PM, ashish koul koul.ash...@gmail.com wrote:
try this (excel 2007) i haven't tested it on 2003
press f3 and click on paste list
On Fri, Mar 18, 2011 at 10:27 PM, hanumant shinde
hi
find the attachment and let me know if it is not helpful.
--
*Thanks Regards
Thamu
*
On Tue, Mar 8, 2011 at 10:22 AM, Markkim mark@gmail.com wrote:
Hi
I’m trying to extract EFT information from the following cell
PAYMENT BY AUTHORITY TO SG FLEET SALARY PACKAGING PTY LTD
Hi
find the attachment and revert if it is not what you want.
--
*Thanks Regards
Thamu
*
On Wed, Mar 2, 2011 at 11:54 AM, naresh v naresh.veerabo...@gmail.comwrote:
Hi Rambabu,
please find the solution..
Regards,
Naresh V,
Analyst
Hyderabad.
On Wed, Mar 2, 2011
Hi dharmesh
simply it will convert text (which numbers in text formats) to values.
equivalent to (value) function.
--
*Thanks Regards
Thamu
*
On Fri, Mar 4, 2011 at 10:52 AM, Dharmesh Shah dharmeshsha...@gmail.comwrote:
Thank you very much to group and specially to people who helped me
In
Hi
Ignore my previous mail. Now check the attachment and revert if it is not
helpful.
--
*Thanks Regards
Thamu
*
On Wed, Mar 2, 2011 at 10:45 AM, Nemi Gandhi nemigan...@gmail.com wrote:
attached again with explanation.
--
Nemi Gandhi
98204 92963
--
Hi
Ignore my previous mail. Now check the attachment and revert if it is not
helpful.
--
*Thanks Regards
Thamu
*
On Wed, Mar 2, 2011 at 10:45 AM, Nemi Gandhi nemigan...@gmail.com wrote:
attached again with explanation.
--
Nemi Gandhi
98204 92963
--
Hi Gandhi
find the attachment and revert if it is not helpful.
--
*Thanks Regards
Thamu
*
On Wed, Mar 2, 2011 at 10:45 AM, Nemi Gandhi nemigan...@gmail.com wrote:
attached again with explanation.
--
Nemi Gandhi
98204 92963
--
HI Naresh,
Have look at this, i did something by using function,
find the attachment.
--
*Thanks Regards
Thamu
*
On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR sajidmansooral...@gmail.com
wrote:
Why are you using this lengthy formula?
=INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0))
instead of
Sajid
Tools Share Workbook
--
*Thanks Regards
Thamu
*
On Sun, Feb 27, 2011 at 10:38 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Sajid,
Yes, it can be done.
Share your file and provide the LAN path of the file to all the
respective users. Sharing of the file (workbook) will
Hi
Find the attachment
--
*Thanks Regards
Thamu
*
On Wed, Feb 23, 2011 at 3:06 PM, Nemi Gandhi nemigan...@gmail.com wrote:
file is attached. Please help.
--
Nemi Gandhi
98204 92963
--
--
Some
Dear Ayush,
ICE (INTENSIVE CARE in EX(CELL)
--
Thanks Regards
Thamu
On 2/22/11, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am too excited to share that discussexcel.com website development is in
good progress and we are ready to launch the website on 4th Anniversary of
Dear Sandip,
find the attachment.
--
*Thanks Regards
Thamu
*
On Tue, Feb 8, 2011 at 10:56 AM, San Pat myitems2...@gmail.com wrote:
Hi All,
I am trying to extract a texts from the* parentheses.
I have attached the sample file. I want to extract texts from the
**parentheses
from
type this in c1
=IF(ISERROR(SEARCH(B1,A1)),False,True)
case sensitive free
--
*Thanks Regards
Thamu
*
On Mon, Feb 7, 2011 at 9:58 PM, rajan verma rajanverma1...@gmail.comwrote:
hello Mujeeb..
find attached Sheet ..
Rajan.
On Mon, Feb 7, 2011 at 3:08 AM, Mujeeb
95 matches
Mail list logo
