Previous Topic Next Topic

LARGE POLL OF NUMBERS

Closed
rhoknee Posts 7 Registration date Saturday March 27, 2010 Status Member Last seen May 12, 2010 - Mar 27, 2010 at 05:16 PM
rhoknee Posts 7 Registration date Saturday March 27, 2010 Status Member Last seen May 12, 2010 - Mar 29, 2010 at 03:35 PM
<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 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 27, 2010 at 09:49 PM
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
0
rhoknee Posts 7 Registration date Saturday March 27, 2010 Status Member Last seen May 12, 2010
Mar 28, 2010 at 03:45 AM
In different columns, A to E.
0
Answer 2 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 28, 2010 at 10:12 PM
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
0
rhoknee Posts 7 Registration date Saturday March 27, 2010 Status Member Last seen May 12, 2010
Mar 29, 2010 at 03:35 PM
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.
0