A B C

1 2895 59 TH ST ELEMENTARY 28
2 5466 6 TH AVE ELEMENTARY 49
3 7855 6 TH AVE ELEMENTARY 6
4 2954 92 ND ST ELEMENTARY 21
5 5677 93 RD ST ELEMENTARY 60
D E F
8 2895 59 TH ST ELEMENTARY 28
9 5466 6 TH AVE ELEMENTARY 50
10 2954 92 ND ST ELEMENTARY 23
11 5677 93 RD ST ELEMENTARY 60


if C column is less than F display < in column e
if C column is greater than F display in column e
if C column is = to F display =

Thanks

Hi,
I assume your information starts in cell 1 so in column E1 enter

=IF(C1=F1,"=",IF(C1F1,"",IF(C1="","",IF(C1<F1,"< "))))

I add an option to show blank if cell C1 is blank


"out0015" wrote:

A B C

1 2895 59 TH ST ELEMENTARY 28
2 5466 6 TH AVE ELEMENTARY 49
3 7855 6 TH AVE ELEMENTARY 6
4 2954 92 ND ST ELEMENTARY 21
5 5677 93 RD ST ELEMENTARY 60
D E F
8 2895 59 TH ST ELEMENTARY 28
9 5466 6 TH AVE ELEMENTARY 50
10 2954 92 ND ST ELEMENTARY 23
11 5677 93 RD ST ELEMENTARY 60


if C column is less than F display < in column e
if C column is greater than F display in column e
if C column is = to F display =

Thanks

When trying your suggestion, excel spits out 0 on every column.
I need to compare all the numbers c column associated with its b and a info.
same thing with f column. the f column is associated with its info in d and e.
please advise. i need a formula that searches all of the c column info with
b and a
together to find a match in every single hit in column f.

"Eduardo" wrote:

Hi,
I assume your information starts in cell 1 so in column E1 enter

=IF(C1=F1,"=",IF(C1F1,"",IF(C1="","",IF(C1<F1,"< "))))

I add an option to show blank if cell C1 is blank


"out0015" wrote:

A B C

1 2895 59 TH ST ELEMENTARY 28
2 5466 6 TH AVE ELEMENTARY 49
3 7855 6 TH AVE ELEMENTARY 6
4 2954 92 ND ST ELEMENTARY 21
5 5677 93 RD ST ELEMENTARY 60
D E F
8 2895 59 TH ST ELEMENTARY 28
9 5466 6 TH AVE ELEMENTARY 50
10 2954 92 ND ST ELEMENTARY 23
11 5677 93 RD ST ELEMENTARY 60


if C column is less than F display < in column e
if C column is greater than F display in column e
if C column is = to F display =

Thanks

For example: column g is where <, , = should be placed.

-for the first input 59th st has 28 total, 59th st needs to look at a, b, c
which is the first one on the list then compares, 28 = 28, then it would put
= in column g.
-second one is 6th ave. which has 50. 6th ave is the 2nd and 3rd input so
49+6=55.
50 is less than 55 so i want column g to display <.
and so on.


hope this helps.


"Eduardo" wrote:

Hi,
I assume your information starts in cell 1 so in column E1 enter

=IF(C1=F1,"=",IF(C1F1,"",IF(C1="","",IF(C1<F1,"< "))))

I add an option to show blank if cell C1 is blank


"out0015" wrote:

A B C

1 2895 59 TH ST ELEMENTARY 28
2 5466 6 TH AVE ELEMENTARY 49
3 7855 6 TH AVE ELEMENTARY 6
4 2954 92 ND ST ELEMENTARY 21
5 5677 93 RD ST ELEMENTARY 60
D E F
8 2895 59 TH ST ELEMENTARY 28
9 5466 6 TH AVE ELEMENTARY 50
10 2954 92 ND ST ELEMENTARY 23
11 5677 93 RD ST ELEMENTARY 60


if C column is less than F display < in column e
if C column is greater than F display in column e
if C column is = to F display =

Thanks