From: Alexander on 20 Apr 2010 03:22 I have a number of stats on hand. In column A is the results of column B, C, D, E, F, G. (Note* column B, C, D, E, F, G values are sometime +'ve sometimes -'ve) Is there a function that can tell me the relations between value A vs B, A vs C, A vs D... etc) Your help can save my job~ Thanks From: ozgrid.com on 20 Apr 2010 04:11 =IF(AND(A1=B1,A1=C1,A1=D1,A1=E1,A1=F1,A1=G1)) -- Regards Dave Hawley www.ozgrid.com "Alexander" wrote in message news:628F0EE1-43A3-4BE3-8F55-31B671CFD62D(a)microsoft.com...>I have a number of stats on hand. In column A is the results of column B, >C, > D, E, F, G. (Note* column B, C, D, E, F, G values are sometime +'ve > sometimes > -'ve) Is there a function that can tell me the relations between value A > vs > B, A vs C, A vs D... etc) > > Your help can save my job~ Thanks From: Mike H on 20 Apr 2010 04:46 Hi, May be this =COUNTIF(B1:G1,A1)=6 or even =IF(COUNTIF(B1:G1,A1)=6,"Do this for true","Or this for false") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Alexander" wrote: > I have a number of stats on hand. In column A is the results of column B, C, > D, E, F, G. (Note* column B, C, D, E, F, G values are sometime +'ve sometimes > -'ve) Is there a function that can tell me the relations between value A vs > B, A vs C, A vs D... etc) > > Your help can save my job~ Thanks  |  Pages: 1 Prev: find a nameNext: Printing spreadsheet and diagram