Search results

Got it! Thanks to all who responded Cheers

Hui, This macro works but its not quite what I'm looking for. In the first case I'm looking for one that can count the cases in multuple cells not the summary of multiple cells in one cell. So like the formula would have to work with like =checkstr(A1:A13,9,1) and this would return the...

Array is a row with 13 different values.

HUI, I'm not sure if you remember me but a few months ago you helped me with a very useful count macro which recapped the alternance between values and zeros for a given set of numbers in one cell(thanks by the way!). I have started on this project again (oh goodie) and I am stuck on something...

Hui, You helped me in the past with a very useful macro which was a specialized count that would recap the number of zeros in a given range. I'm on a new project now and I am needing to bring some tables into Access from excel. I need to find a way which when i bring the tables in from excel...

Hui, You're right, this works fine, I messed it up in mine at first but now it is working just fine. Thanks alot! Also, I have another question. Do you know of a way to make an IF statement "adjustable" meaning that a user could easilly change it to the criteria that they wish it to be. Like...

Hui, This new macro does the same thing as the first, it does not account for the negetives it is just counting zeros vs non zeros. I would think that the new one would be a simpler syntax don't you?- since all I want to do is count the sequence of posative values against the values that are...

Hui, About a month ago you sent me a very handy vba code that recapped the occurences of zeros in a given array of numbers into one cell. So like for example an array of 1-4-0-0-0-3-4-5 would return into one cell "2-3-3"- the "2" representing the 1 and the 4, the first "3" representing the next...

Hui, No problem with the original post, your macro brought me very far in my project. That is not a bad idea aout the cell outlines but, and correct me if I'm wrong, I can just do that with a simple conditional format right? Also- I read your post about donught charts being invented by American...

I guess it'd help if I sent the actual vba code, here it is: Function NumbZeros(myData) As String Dim myArr Dim myStr As String On Error Resume Next Count = 0 Count0 = 0 myStr = "" Set myArr = myData For i = 1 To myData.Count - 1 If myArr(i) <> 0 Then 'Data <>0...

Is there someone who can help me color code part of this vba macro? What this macro does is take a range of numbers and tells the order and amount of zeros vs. non-zeros. So for example if there was a range of 1-6-0-4-0-0-7-4 this macro would return in one cell "2-1-1-2-2"- the first 2 would...

Hui, This works awesome! Thank you very much. Would there be a way for me to easilly color code the numbers that represent the number of zeros? Other than that this is exactly what I am looking for. Thanks again!

What I am trying to do is show the number of non zeros vs the number of zeros in a given range. For example; I have a table that is about 1800 rows down and 13 coloums accross. The thirteen values in a given row could be something like: 1-6-0-0-4-5-2-8-4-2-0-0-0. What I want to do idealy would...