About Us

dreamer[_6_]

Tom Ogilvy wrote:
[b]With Range("C1")
Formula = "=IF(ISERR(FIND("" "",B1,1)0),"""",VALUE(MID
(B1,FIND("" "",B1,1)+1,255)))"

testing in the immediate window:

? "=IF(ISERR(FIND("" "",B1,1)0),"""",VALUE(MID(B1,FIND(""
"",B1,1)+1,255)))"
=IF(ISERR(FIND(" ",B1,1)0),"",VALUE(MID(B1,FIND(" ",B1,1)+1,255)))

also, since you using A1 notation, you would use formula rather than
formulaR1C1

Sub tester5()
With Range("C1")
.Formula = _
"=IF(ISERR(FIND("" "",B1,1)0),"""",VALUE(MID(B1,FIND(""
"",B1,1)+1,255)))"
End With
End Sub

although I doubt that formula is what you want. Your discription of
what
you want is not very clear. I assume columns B and C already exist
and you
want to get these ranges somewhere else, but as I said, you
description is
not very clear.

--
Regards,
Tom Ogilvy

Well, I'll try to explain a bit more what I want to do.
The idea is to calculate standard deviation with values in column C.
Every value in column C has coresponding value in column B. Let's say
if B1:B5 is 20, I want to calculate the standard deviation of values
in column C with the range C1:C5. And if B6:B9 is 40, I calculate the
standard deviation of values in column C with the range C6:C9. And
the st.dev values should be written to column H. The problem is that
not every value in column C is there. For example value 80 in column
B has only 2 coresponding values in column C so only the range of
those 2 value should be returned.

---
Message posted from http://www.ExcelForum.com/

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
searching for my perfect algorithm....	meesh7391	Excel Discussion (Misc queries)	0	January 11th 06 01:55 PM
Curve fitting algorithm	ringo	Charts and Charting in Excel	4	January 11th 06 11:46 AM
looking for my perfect algorithm	meesh7391	Excel Discussion (Misc queries)	0	January 11th 06 12:06 AM
Algorithm Challenge	Lowkey	Excel Worksheet Functions	4	July 20th 05 06:40 PM
Need help with algorithm	RADO[_3_]	Excel Programming	1	November 4th 03 12:37 PM

Menu

About Us