vba programming

Happy holiday and Happy new year for all. I am trying to use conditional formatting without use F4 so I can scroll down, but, do not work, why? I don't know. I am looking for a VBA code (not formulas). my situation is: data : B3:G64 results start in: M2 what I am trying to do? I want to...

I need to got the list according to the rank. <colgroup><col style="width: 48pt;" span="5" width="64"> <tbody> A B C D 1 bin score rank 2 1 37 3 2 48 4 3 31 5 4 18 6 5 31...

Hello. I looking to see how many 6 odds and 0 even, 5 odds and 1 even etc etc I have in the 36 rows at the attachment, the same the total in that range. so I can change this 36 row and see it. the images make clear what I need. I rather a VBA PLEASE. <colgroup><col style="width: 23pt...

Hello. I am trying to create optimal combinations for that I need that the numbers I write under the green line; swap those value in the right square according to the left square. <colgroup><col style="width: 48pt;" span="15" width="64"> <tbody>...

Hello. How can I substract a series of numbers from an array. example. <colgroup><col style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;" span="6" width="21"> <col style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;" width="65"> <col style="width: 35pt...

Hello everyone. I am trying to know how to count the last cells without formatting as you see at the attach there are yellow cells and blank cells, the first two cells ON I in the green line I write "0" in the column "M" you can see 12, because if you count, there are 12 blank cells before you...

Hello everyone. I am trying to generate a recurrence frequency report and this is what I have been doing manually, (to long by hand) =FREQUENCY(B1:G36,I1:I53) =FREQUENCY(B2:G37,I1:I53) =FREQUENCY(B3:G38,I1:I53) and so on until I reach =FREQUENCY(B18:G53,I1:I53) I want the out put in J:AA my...

Hi everybody. I am doing this manually but of course must be fast way in vba to do it, I am doing repeating divisions, example: =(A2+A3)/2 , (B2+B3)/2 , (C2+C3)/2 , (D2+D3)/2 and (E2+E3)/2 =(A2+A3+A4)/3 , (B2+B3+B4)/3 , (C2+C3+C4)/3 , (D2+D3+D4)/3 , and (E2+E3+E4)/3 =(A2+A3+A4+A5)/4...

I am trying to find the best coefficient trendline, but therange of the information is also very important.<o:p></o:p> So the goal is what is the best RANGE, and the bestCOEFFICIENT TRENDLINE, that really can be trustfull when you try to forecastingsomething and is not a ferrytail.<o:p></o:p> Is...

Looking for a code that generate a list of combinations of numbers from x set, taken 5 at the time and be able to input how many odds and evens. I need the inputs on sheet 1 and the output on sheet 2 G:K

Hi everyone.<o:p></o:p> Days ago I posted this question on OZGRID FORUM; untilnow NO answer at all.<o:p></o:p> How to generate a combinations that match some criteriafrom X numbers taken five at the time.<o:p></o:p> 1)input the number A1:A30 (more than 6 to choose)<o:p></o:p> 2)input the number...

Hello.<o:p></o:p> I am trying to highlight duplicates. I have an arrayA2:E6057 to compare against G2:GD6056 so what I am looking for is to compareline by line, example<o:p></o:p> Row A2:E2 against G2:GD2, next A3:E3 against G3:GD3 andso on until 6056 line (is one line or row less). I am have to...

HELLO. Trying to accomplish some statistics. I need to see thedistance between every number counting the rows NOT CELL BY CELL; the attach isclear.<o:p></o:p> 1 ) H1 is the max inte, mean take the maximum numberin the distance by row report.<o:p></o:p> 2) I1 is the Trend function apply to...

Hello, I hope this request do not produce any confusion with my last post because looks like similar, but is really different. I am looking to know the different between every numberaccording to the position in a array, but I gonna exaplain first as straightline example.<o:p></o:p> The bim is...

<tbody> A B C D E F G H I J K L 1 5 16 19 34 1 31 46 2 10 14 19 31 2 31 36 56 61 3 10 14 29 32 3 22 6 20 23 27 30 4 15 21 23 27 29 5 32 50 55 16 22 23 25 31 6 1 3 5 7 9 7 2 21 30 31...

I need to rearrange a stat report according to the conditions I am putting under the letters. the data is from A3:F39 the bin is at G3:G39. what I really want is to relocate the bin according to the conditions example: on column O you can see this condition (E+F)-B=D if the results are iqual or...

Hello everyone. I post this 3 days ago on ozgrid, and this is the post.(no answer). The list at the left is the data (A1:F1900) in the middle the table (is like a parking lot - place number), and in the right is the swap results, I mean if I put the table in front of the list, and want to know...

Hello. This question is about combinations, If I want to know how many combination of 49 numbers taken 6 at the time I know is just to use =combin(49,6) and give me 13'983.816 possible combinations. What about if I want to enumerate this number by possition, and every time I enter any...

Hello everyone. I am trying to generate a FREQUENCY REPORT but I need the results show up in different way than the regular frequency function, I was trying to do it using =IFERROR(INDEX ....etc. but as you know I think is longer than a vba code, and beside do not work in my case, so the images...

I need some help doing the following:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have Office Home and Business 2010, this is the version without Access, and I want to create a small macro that is triggered by clicking a floating button that only...