Dear All,
Hope you all are doing well !
I need your assistance to sort out my problem. I need to extract 6 7 Digit
number from the string.
Example :
I. C, Rajendra Palace, New Delhi 110053
II. C, 301 Rajendra Palace, 110053 New Delhi
III. C, Rajendra Palace, 110 053 New Delhi
*Result : *
I.
check the below mentioned linked
regards
sanjib
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
On Fri, Oct 7, 2011 at 11:37 AM, karan 1237 karan1...@gmail.com wrote:
Dear All,
Hope you all are doing well !
I need your assistance
Hello everybody,
I have a excel file in which i use protect op. but I have forgot password.
becoz i use this file some time not daily.
If we can unprotect sheet than tell soon.
Anil
--
--
Some important links for
To unprotect sheet / workbook structure protection, this should help.
however, this will not open the workbook, if you have protected the
file.
http://www.straxx.com/excel/password.xla
Regards,
Sam
On Oct 7, 12:41 pm, anil kumar kmr7a...@gmail.com wrote:
Hello everybody,
I have a excel file
Hi Anil,
see the below link.
www.straxx.com/excel/password.html
Regards,
DILIPandey
On 7 Oct 2011 13:12, anil kumar kmr7a...@gmail.com wrote:
Hello everybody,
I have a excel file in which i use protect op. but I have forgot password.
becoz i use this file some time not daily.
If we can
You said that it stops at a random point.
It it the same point every time? or a different (random) point?
I've encountered something similar, it's as if a breakpoint is being saved.
Even when I exit Excel and re-open the file.
When it stops, I was able to select Debug- Clear_All_Breakpoints
http://www.box.net/shared/q6id1k3plhn3avp7q6gt
Here is the link, I want the stats to worked out for Grade 8 the same as it
is done for Grade 9. .PLEASE assist.
Yours sincerely
Shane
--
--
Some important
http://www.box.net/shared/q6id1k3plhn3avp7q6gt
Hi
Here is the link above to the files I was talking about, I need a formula to
work the stats for me for Grade 8 just like the grade 9 sheet does
--
--
Some
I need the formula to lookup a value in a table and return the table column
header value. Please see attached spread sheet.
Thank you for your kind help.
John
--
--
Some important links for excel users:
1. Follow
You might want to clarify 'I need the formula for the GREEN cells to
lookup the value in the appropriate table', with an example.
On Oct 7, 5:44 pm, John A. Smith johnasmit...@gmail.com wrote:
I need the formula to lookup a value in a table and return the table column
header value. Please see
http://www.box.net/shared/q6id1k3plhn3avp7q6gt/1/122013897/969991807
Here is the grade 8 file I want to generate the same Stats as the grade 9
file
--
--
Some important links for excel users:
1. Follow us on
http://www.box.net/shared/q6id1k3plhn3avp7q6gt/1/122013897/969991807
HI
Here is the file of the Grade 8 schedule which I want to generate the same
stats as the Grade 9 sheet does
Yours sincerely
Shane
--
--
Some
http://www.box.net/shared/q6id1k3plhn3avp7q6gt
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hello Ashish,
Thanks a lot its working fine may I know is there any materials to learn
macros based on powerpoint and msword.
Thanks in advance.
Regards,
Chandra Shekar B
On Fri, Oct 7, 2011 at 7:48 AM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hello Ashish,
Thanks a lot its
GoldenLance,
I attached the example. It was detailed in the attachment.
John
On Fri, Oct 7, 2011 at 8:53 AM, GoldenLance samde...@gmail.com wrote:
You might want to clarify 'I need the formula for the GREEN cells to
lookup the value in the appropriate table', with an example.
On Oct 7,
Dear all,
Sometimes I work with large data, if i want to find some data,
normally I type the key word in find option, I want to highlight the
cell with some colour to view it clearly, which cell is highlighted.
Normally it goes to cell but i have some problem ( eye sight).
Thanks in advance
--
Sam,
Thanks for your solution. I got it to work and with the modification
suggested by DILIPandey, it does what I wanted. I just have to be
careful that my user enters 5% and not =5%.
The track changes, while interesting and will be used in the future,
didn't fit because the formulas can be
And if that doesn't work, from my experience, this normally goes away once
you've restarted the operating system.
Regards,
Sam
On Fri, Oct 7, 2011 at 4:05 PM, Paul Schreiner schreiner_p...@att.netwrote:
You said that it stops at a random point.
It it the same point every time? or a different
You are welcome John.
In order to include next set of data we can use defined name(s) but for this
to work, we need to create a locator cell, refrencing which Excel can
understand which period to pick up as I am not sure if you want right most
data to be picked up always.
Share your thoughts and
*2011* * * PictOld *Achievement (1-10)* PictOld *Improvement
(0-9)* *Jan-Mar* *Apr-Jun* *July-Aug* *Jul-Dec* *Jul11-Mar12* 100.00%
100.00% 100.00% 10 9
Yes, I want the formula to pick up the last entered value on the right (the
next period would be blank like the BLUE cell above).
Hi John,
Try these,
K3, copy down.
=LOOKUP(LOOKUP(9E+300,C3:J3),N3:X3,N$2:X$2)
L3, copy down.
=LOOKUP(LOOKUP(9E+300,C3:J3),Z3:AJ3,Z$2:AJ$2)
This will look the last entered value.
HTH
Haseeb
--
--
Some
Excellent! Thank you Haseeb, that works like a charm. Thank you for you
help.
John
On Fri, Oct 7, 2011 at 2:02 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Hi John,
Try these,
K3, copy down.
=LOOKUP(LOOKUP(9E+300,C3:J3),N3:X3,N$2:X$2)
L3, copy down.
2011/10/7 Dilip Pandey dilipan...@gmail.com
Hi Anil,
see the below link.
www.straxx.com/excel/password.html
Regards,
DILIPandey
On 7 Oct 2011 13:12, anil kumar kmr7a...@gmail.com wrote:
Hello everybody,
I have a excel file in which i use protect op. but I have forgot password.
that is what you need???
remove password of book?
or unlock leaves?
Please attach file
chilexcel
2011/10/7 GoldenLance samde...@gmail.com
To unprotect sheet / workbook structure protection, this should help.
however, this will not open the workbook, if you have protected the
file.
Please see attachment
2011/10/7 Bé Trần Văn betnmtdongna...@gmail.com
2011/10/7 Dilip Pandey dilipan...@gmail.com
Hi Anil,
see the below link.
www.straxx.com/excel/password.html
Regards,
DILIPandey
On 7 Oct 2011 13:12, anil kumar kmr7a...@gmail.com wrote:
Hello everybody,
Please see attached
for unlock sheets..
2011/10/7 ChilExcel chilexcel...@gmail.com
that is what you need???
remove password of book?
or unlock leaves?
Please attach file
chilexcel
2011/10/7 GoldenLance samde...@gmail.com
To unprotect sheet /
hi Dilip
straxx password ,,does not work, this discontinued
Chilexcel
2011/10/7 ChilExcel chilexcel...@gmail.com
Please see attachment
2011/10/7 Bé Trần Văn betnmtdongna...@gmail.com
2011/10/7 Dilip Pandey dilipan...@gmail.com
Hi Anil,
see the below link.
Hi, Karan,
Not a good one, but try this Array Formula,
If you are using XL 2003 or prior,
=MAX(IF(ISNUMBER(MID(SUBSTITUTE(A2,
,),ROW(INDIRECT(1:LEN(A2))),{6,7})+0),MID(SUBSTITUTE(A2,
,),ROW(INDIRECT(1:LEN(A2))),{6,7})+0))
If you are on XL 2007 or later,
=MAX(IFERROR(MID(SUBSTITUTE(A2,
Hi, I have the following code that searches for data based on what i
type in it (in this case it is FHCX) and posts it in a new sheet.
How can i get excel to read a menu with selections using X in a cell
and feed it into the code below to produce results on a new tab?
Sub ServiceReport()
'
I believe the forum is not able to comprehend what 'can i get excel to read
a menu with selections using X in a cell' is trying to convey. Maybe you
want to rephrase it, or share an example of what you are trying to do.
Sam
On Fri, Oct 7, 2011 at 10:55 PM, Monizri moni...@gmail.com wrote:
Hi,
Hi Anil
find attach workbook to unprotect worksheet
HTH
Mahesh
On Sat, Oct 8, 2011 at 2:58 AM, ChilExcel chilexcel...@gmail.com wrote:
hi Dilip
straxx password ,,does not work, this discontinued
Chilexcel
2011/10/7 ChilExcel chilexcel...@gmail.com
Please see attachment
31 matches
Mail list logo