rng =OFFSET(Foglio1!$A$1,,,50,50)
regards
r
2011/4/24 karan karankan...@gmail.com
Hi
Thanks for the formula. It does help, but while trying it on a new
sheet its not working it gives an error #NAME?
On Apr 19, 9:07 pm, ashish koul koul.ash...@gmail.com wrote:
see if it helps
hi karan
unfortunately with very small numbers is small rounding errors. I
attach a sample
file
regards
r
2011/4/25 roberto mensa robb@gmail.com
rng =OFFSET(Foglio1!$A$1,,,50,50)
regards
r
2011/4/24 karan karankan...@gmail.com
Hi
Thanks for the formula. It does help, but while
Hi
Thanks for the formula. It does help, but while trying it on a new
sheet its not working it gives an error #NAME?
On Apr 19, 9:07 pm, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga karankan...@gmail.com wrote:
Hi,
Can any1
with the arrayformula:
text in A2
definited name rng =OFFSET(Foglio1!$A$1,,,50,50)
in B2:
=MOD(LARGE(ISERROR(--MID(aSUBSTITUTE($A$2,.,0),ROW(rng),1))*ISERROR(--MID(SUBSTITUTE($A$2,.,0),ROW(rng)+COLUMN(rng),1))*IF(ISNUMBER(--MID(SUBSTITUTE($A$2,
On Tue, Apr 19, 2011 at 9:37 PM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga karankan...@gmail.comwrote:
Hi,
Can any1 pls let me know how do i separate the text and nos in a
given sentence. PFA the sheet where i need to separate
as an alternative to solving of siti Vi
Function GetNumbers_r(S As String, Index As Integer)
Dim mc
Dim RE As Object
Set RE = CreateObject(vbscript.regexp)
RE.Global = True
RE.Pattern = (?:0|[+-]? _
(?:(?!0)\d+(?:\.\d+)? _
|[0]+(?:\.\d+)?))
S = Replace(S, ,, )
Hi,
Can any1 pls let me know how do i separate the text and nos in a
given sentence. PFA the sheet where i need to separate the nos and text.
Thanks.
--
--
Some important links for excel users:
1. Follow us on
see if it helps
On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga karankan...@gmail.com wrote:
Hi,
Can any1 pls let me know how do i separate the text and nos in a
given sentence. PFA the sheet where i need to separate the nos and text.
Thanks.
--
try to use this UDF and see if it helps..
Function GetNumbers(S As String, Index As Integer)
'
' siti Vi / jakarta, 30-08-2009
'
Dim ArrN(), i%, tmp$, n%, t$, t2$
S = Trim(S) |
For i% = 1 To Len(S) - 1
t$ =