PDA

View Full Version : Solved: Compare multple value



anandbohra
10-16-2007, 04:18 AM
Hi all
I am stuck to small logical problem
i am making master summary sheet from 4 independent workbook (each contains mini summary with date of report)
now through link i put all the date in Range A1 to A4
say
range A1 contain 15/10/2007 (link to file 1 sheet 1 range a15)
range A2 contain 14/10/2007 (link to file 2 sheet 2 range a15)
range A3 contain 15/10/2007 (link to file 3 sheet 3 range a15)
range A4 contain 15/10/2007 (link to file 4 sheet 4 range a15)

now if i manually see the output i can say that File 2 is not updated as it shows date 14/10/2007 means my a1=a2=a3=a4 is false

so pl help me in excel by providing logical function which compare each value with other & finally produce True if all are same otherwise false.

matthewspatrick
10-16-2007, 04:52 AM
If Application.Min([a1], [a2], [a3], [a4]) = Application.Max([a1], [a2], [a3], [a4]) Then
'do something
Else
'do something else
End If

anandbohra
10-16-2007, 10:04 PM
hi matthewspatrick

thanks for the reply but i tried this in EXCEL & got the acceptable solution
=and(A1=A2, A2=A3,A3=A4,A4=A1)