G Guest Jul 12, 2007 #1 How I can display True/Fale in a one or two colum, if colum A1 to A500 and C1 to C5000 have same amount. With a formula or Micro
How I can display True/Fale in a one or two colum, if colum A1 to A500 and C1 to C5000 have same amount. With a formula or Micro
P Pete_UK Jul 12, 2007 #2 Your ranges are not the same lengths (maybe a typo), but enter this in D1: =(A1=C1) Then copy down to D500 (or is it D5000 ?) Hope this helps. Pete
Your ranges are not the same lengths (maybe a typo), but enter this in D1: =(A1=C1) Then copy down to D500 (or is it D5000 ?) Hope this helps. Pete
G Guest Jul 12, 2007 #3 What do mean by "have same amount" ? A1=C1, A2=C2? And why (possibly) two columns for the result? =(A1=C1) will display TRUE if equal, otherwise FALSE
What do mean by "have same amount" ? A1=C1, A2=C2? And why (possibly) two columns for the result? =(A1=C1) will display TRUE if equal, otherwise FALSE
