How i display True/Fale in one or two colum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get true/false in one or two colum 6
Formulas 1
An if statment tat returns a true blank 4
IF FUNCTION 1
How can I apply If statement using two row, multi columns 1
the If Statements 2
How do I merge colums with data 8
Segrigation of different datas from one colum 1

Back
Top