Thanks for clearing it up. Assuming your data starts in row 1:

=IF(E1=SUMIF(A:A,D1,C:C),"=",IF(E1SUMIF(A:A,D1,C: C),"","<"))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"out0015" wrote:

I tried to post it clearly but the screen could only fit so much.
The last column F is the < = column that i want to input automatically
when i manually input column E. the 6781 in column D is less than 6781 in
column A in terms of column C. I am trying to compare column C to column E,
thats it!
by looking at column E, look at the same number at column A then column A is
associated with column C, so we are comparing column E to column C. 6781 in
column E = 53 compare that to column A (which means look at the value of
column A in column C. column A has to inputs of 6781 so add those two you get
49+6= 55, which gets 53<55.

A B C D E F
3795 59 TH ST ELEMENTARY 28 5548 22
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60







"Luke M" wrote:

I believe you posted this earlier in the forum! You need to explain yourself
more, simply saying "compute" is not a legitimate term for describing what
you want. You also tend to create sevearl run-ons in your logic, making it
unclear. You state that 6781 is less than 6781, which makes no sense. Also,
we have no idea what the 49+6=5550 has to do with anything. Is the text
embedded in the cells with numbers? If not, is it even important?

Why does the last line missing half the data??

Instead of repeatedly posting the same thing, try to give more detail.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"out0015" wrote:

A B C D
E F




3795 59 TH ST ELEMENTARY 28 5548 22
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60


Help: I need a formula to automatically compute column F. ie 5548 in column
D is greater than 5548 in coulumn A 2221. 6781 in column D is less than 6781
in column A 49+6= 5550.