Can someone give some hints???
Id like to know if someone have a code for visual basic/ excel to calculate the SUM OF the product of a sequence of numbers in VBA, i'm using windowns 7/vista. In other words
I want to calculate the value of of
The definition of the product of n numbers is https://es.wikipedia.org/wiki/Productorio
x = 10 -1/n is the number generating function for j from 0 to n
Product functio...
SANDRADEPAR
Last Activity: Sep 13 '17, 09:51 PM
Joined: Mar 6 '10
Location:
-
Sum of product vba
-
ok many thks bro.
Can Someone , please, provide further help? many thks in advance -
OK. THANK YOU SO MUCK. MO WORKS NOW.
But i need insert MO in other vba formula by using the same previous generating function for MO (x = 10 -1/n):
Function summot(j, n) As Double
For j = 1 To n
sum = sum +Application.Co mbin(n,j)*Appli cation.Workshee tFunction.mo(n, j)
Next
summot= sum
End Function
For example, i'd like to calculate for j=9 n=9
Can u tell me please how to calculate the...Leave a comment:
-
Product in vba/excel
Can someone give some hints???
Id like to know if someone have a code for visual basic/ excel to calculate the the product of a sequence of numbers in VBA, i'm using windowns 7/vista.The definition of the product of n numbers is https://es.wikipedia.or g/wiki/Productorio
What i already tried:
Function mo( j, n)
Dim x As Double, j As Double
x = 10 -1/n
For j = 1 To... -
many thanks for your help zmbd,
i try to execute your 964972.zip file so many times in my EXCEL 2010.But it didn't work.
I run loopandcomparea djecentcells first, and after i run LoopAndCompareW ithinRow . Nothing happened.
It didn't write any results.
All the test that i made in EXCEL 2010 were unsuccessfull.
I don't know if the codes of loopandcomparea djecentcells and LoopAndCompareW ithinRow are compatible with old...Leave a comment:
-
thank you codegazer ,
i inserted the adjustments that u provided me above into the code:
...Code:Sub difference() Dim lngLastRow As Long Dim lngLastColumn As Long Dim lngMatch As Long Dim arrMatch(100) As Variant Dim arrMatchValues(100) As Variant Dim arrMatchValues2(100) As Variant Const valDif = 19 lngMatch = 0Last edited by zmbd; Dec 25 '15, 06:06 PM. Reason: [z{You must format the script using the [CODE/] tool - site requirement. Third Request}]Leave a comment:
-
many thanks to all, codegazer and zmbd
What i'm trying to say (the main goal) is that to find ALL POSSIBLE SOLUTIONS THAT any two numbers within each line/row differ by 19 or its absolute value is 19 such as 58 - 39 = 19 or |58 - 39|= 19 or |39 - 58|= 19 for each line/row.
the code that i posted above is omitting some results in some lines (it displays only 1 pair per line/row in final results, and no more results, it...Leave a comment:
-
many thanks to all,
codegazer i 'm trying to find ALL POSSIBLE SOLUTIONS THAT two numbers in each row differ by 19 or
its absolute value is 19 such as 58 - 39 = 19 or |58 - 39|= 19 or |39 - 58|= 19
the code that i posted above is omitting some results in some lines (it displays only 1 pair per line/row in final results, and no more results, it is excluding some results, and i don't know why) and i dont know how to fix...Leave a comment:
-
friend, thanks for your help .
yeah that's the main idea : to find the exact difference of two numbers or their absolute value |A-B|=|C| , that should be 19.
the code that i posted previously is omitting some results in some lines (it displays only 1 pair per line/row, and no more results) i dont know how to fix that.
i tried valDif in the code such as A-B, B-C, C-D, but it is omitting some results in some lines (it...Leave a comment:
-
i tried this code but i got limited results (the code omitting some results i dont know how to fix this:
...Code:Sub difference() Dim lngLastRow As Long Dim lngLastColumn As Long Dim lngMatch As Long Dim arrMatch(100) As Variant Dim arrMatchValues(100) As Variant Dim arrMatchValues2(100) As Variant Const valDif = 19 lngMatch = 0 Sheets("Plan1").SelectLeave a comment:
-
thks for your help.
Would you fix the code up, please?
many thanks in advanceLeave a comment:
-
yeah u got the idea into mind: exact difference of two numbers or ABS is 19. i saw that u wrote it in the code. I TRIED your code in MS EXCEL 2010, but it returned no results, because it displayed error messages: error compilations in the code.
I got almost-nothing skills in programming, I recently have begun study vba 4/5/6 windowns a month ago.
Would you fix the code up, please?
many thanksLeave a comment:
-
doubt on calculating difference vba/excel
Can someone give some advices???
Id like to know if someone have a code for visual basic/ excel to calculate the exact difference of two numbers in a extremely huge sample, such as.
...Code:34 46 61 70 73 78 88 89 90 95 100 49 51 55 62 63 64 76 82 84 93 97 47 48 54 55 57 67 74 79 85 91 99 49 51 55 60 63 64 67 78 83 93 98 54 59 65 69 71 73 87 92 98 99 100 42 47 48 58 72 73 74 75 76 80 93 50 56 59 64 70 73 85
Last edited by zmbd; Nov 28 '15, 01:11 AM. Reason: [Rabbit{Please use [code] and [/code] tags when posting code or formatted data.}][z{removed the yelling and slightly rewrkd q.}] -
Count triples
Can someone give some hints???
Id like to know if someone have a code for visual basic/ excel to calculate the ocurrence of triples or triplets.
Because id like to count the ocurrence of triples numbers in a DNA or RNA chromossome , in order to verify certain parameters in sequences like
16 11 88 32 25 0 70 78 73 61 90 89 46 95 6 33 34 21 14 22
76 63 18 44 84 11 55 93 8 29 82 62 17 64 24 14 37 97 49 51
34 8...
No activity results to display
Leave a comment: