LARGE POLL OF NUMBERS

Closed
Report
Posts
7
Registration date
Saturday March 27, 2010
Status
Member
Last seen
May 12, 2010
-
Posts
7
Registration date
Saturday March 27, 2010
Status
Member
Last seen
May 12, 2010
-
<Edit> Hello, </Edit>
I have a poll of numbers in the format below in excel 2007. My task is to locate a row with a question mark, then check all the numbers above it which are similar. Using the example below, I must find the numbers that have 0 1 0 at the beginning.
a)Is there any formula I can use?
b)And what about if the poll of numbers is indeed long and there are many rows with question marks because my task is to start at the top looking for rows with question marks then checking above them if there are any rows with the same numbers and more then move down till the bottom.

EXAMPLE
POLL OF NUMBERS
0 1 0 0 2
1 0 0 1 0
1 0 0 1 1
1 1 0 0 1
0 0 1 0 0
0 0 1 0 1
0 0 1 0 0
0 0 1 1 0
1 1 1 1 0
0 0 0 0 1
0 0 2 1 0
0 1 0 2 1
0 0 0 0 1
0 1 0 0 ?
0 1 0 1
0 0 0 0
0 0 1 1
0 0 1 1
0 1 0 ?

DESIRED RESULT:

0 1 0 0 2
0 1 0 2 1
0 1 0 0 ?
0 1 0 1
0 1 0 ?
All the help will be appreciated.
Rhoknee

<Edit> Thanks</Edit>

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
are these poll numbers are in one column or in different columns for e.g
column A
0 1 0 0 2
or are they in columns A to E
Posts
7
Registration date
Saturday March 27, 2010
Status
Member
Last seen
May 12, 2010

In different columns, A to E.
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
I have prepared the macro. Then when I again went to your requirements I get into a logical problem

The question mark (?) is in row 14
It is
0 1 0 0 ?
There are 4 columns A to D before the question mark column which is in column E
your example shows

"I must find the numbers that have 0 1 0 at the beginning. "
To my logic it should be
0 1 0 0
Four columns CLARIFY

secondly

"if there are any rows with the same numbers and more"
that means in column A more than 0, in column B more than 1,in column c more than 0 and incolumn D more than 0 (column E will remain as it is )

that means the following rows will qualify .

0 1 0 0 2
1 1 0 0 1
1 1 1 1 0
0 1 0 2 1


This logic is also to be CLARIFIED

Send me the TWO clarifications and I have only to tweak the macro to suit your clarifications
Posts
7
Registration date
Saturday March 27, 2010
Status
Member
Last seen
May 12, 2010

Sorry for the confusion,I did not explain it well. I have attached a link that has the poll of numbers.
Basically my aim is to look at the poll of numbers in columns E to M down to row 117. Starting at the top we search for a "?", we first find 1 1 1 0 1 0 0 1 at row 19. We check the above rows to see if we find any row starting with 1 1 1 0 1 0 0 1. if we do we note both anywhere on the right as I have done in the work sheet. If not we do nothing and move down the pool of number searching for the next ? We do this all the way down.In the example, we stop at 0? In the example I did not generate all the numbers as they are so many starting with 0.....

(For example If the numbers in the row are 7653420?, we check the above rows for any rows starting with 7653420....

http://wikisend.com/download/547730/example1.xlsx
I really appreciate you time.