| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ARE ALL THE CELLS EQUAL?
Instead of entering a lengthy formula like:
=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
If A1 is not blank..the below will do
=IF(COUNTIF(A1:A10,A1)=ROWS(A1:A10),"All cells are same","Not same") If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
Here's another approach...
Array entered** : =IF(AND(A1:A10=A1),"Same","Not the Same") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Faraz A. Qureshi" wrote in message ... Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
Isn't there anyway for cells not in an array but distributed?
-- Best Regards, Faraz "Jacob Skaria" wrote: If A1 is not blank..the below will do =IF(COUNTIF(A1:A10,A1)=ROWS(A1:A10),"All cells are same","Not same") If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
Isn't there anyway for cells not in an array but distributed?
-- Best Regards, Faraz "T. Valko" wrote: Here's another approach... Array entered** : =IF(AND(A1:A10=A1),"Same","Not the Same") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Faraz A. Qureshi" wrote in message ... Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")
-- David Biddulph "Faraz A. Qureshi" wrote in message ... Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
XClent David!
Thanx! -- Best Regards, Faraz "David Biddulph" wrote: =IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT") -- David Biddulph "Faraz A. Qureshi" wrote in message ... Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")
How did you know the data was numeric? -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT") -- David Biddulph "Faraz A. Qureshi" wrote in message ... Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ARE ALL THE CELLS EQUAL?
Inspired guesswork. :-)
-- David Biddulph "T. Valko" wrote in message ... =IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT") How did you know the data was numeric? -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT") -- David Biddulph "Faraz A. Qureshi" wrote in message ... Instead of entering a lengthy formula like: =IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK") Any idea how to determine if all the cells are equal by entering address of each cell once only, namely: D12, D7, E9, G2, H17, F11, I6 or that of a range, like: B1:B50 only once? Thanx in advance. -- Best Regards, Faraz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equal Cells | Excel Worksheet Functions | |||
| setting multiple cells equal to other cells | Excel Worksheet Functions | |||
| Sum equal cells | Excel Worksheet Functions | |||
| how to seperate cells with equal blank cells | Excel Discussion (Misc queries) | |||
| if two cells are equal? | New Users to Excel | |||
Linear Mode
