| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How i display True/Fale in one or two colum
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How i display True/Fale in one or two colum
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 On Jul 12, 5:32 pm, Qazi Ahmad wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How i display True/Fale in one or two colum
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 "Qazi Ahmad" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display TRUE / FALSE Instead Of 1 / 0 | Excel Discussion (Misc queries) | |||
| How to get true/false in one or two colum | Excel Discussion (Misc queries) | |||
| How to display a value in say B2 in B3 IF a value in B1 is true | Excel Discussion (Misc queries) | |||
| Display list from one colum if value in other column matches x | Excel Discussion (Misc queries) | |||
| how to display data from rows to colum | Excel Discussion (Misc queries) | |||
Linear Mode
