Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default How to get true/false 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default How to get true/false in one or two colum

Please don't multi-post - you have an answer elsewhere.

Pete

On Jul 12, 5:30 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to get true/false in one or two colum

In D1 enter =A1=C1

Copy down by double-clicking the fill handle of C1


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 09:30:03 -0700, 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default How to get true/false in one or two colum

It not help me because i have Bank cheque no in Colum A1 to A500 wich i
issued to custumers and in B1 to B1000 which show cheque no which draw from
bank. now i want to findout which chque is draw from bank. cheque no are not
in same raw. numbers are in different row i just want to findout the same
chequ number in bothe colum.
thanks.

"Gord Dibben" wrote:

In D1 enter =A1=C1

Copy down by double-clicking the fill handle of C1


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 09:30:03 -0700, 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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default How to get true/false in one or two colum

On Jul 12, 11:16 am, Qazi Ahmad
wrote:
It not help me because i have Bank cheque no in Colum A1 to A500 wich i
issued to custumers and in B1 to B1000 which show cheque no which draw from
bank. now i want to findout which chque is draw from bank. cheque no are not
in same raw. numbers are in different row i just want to findout the same
chequ number in bothe colum.
thanks.

"Gord Dibben" wrote:
In D1 enter =A1=C1


Copy down by double-clicking the fill handle of C1


Gord Dibben MS Excel MVP


On Thu, 12 Jul 2007 09:30:03 -0700, 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


=IF(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,0)),"Not Found","Found")

Put in C1 and copy down to C500. This will return "Found" if the
cheque no in column A is also listed in column B.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default How to get true/false in one or two colum

Thank you, it help me to over come my problem.

Thank you onece again.

"Tim Shnell" wrote:

On Jul 12, 11:16 am, Qazi Ahmad
wrote:
It not help me because i have Bank cheque no in Colum A1 to A500 wich i
issued to custumers and in B1 to B1000 which show cheque no which draw from
bank. now i want to findout which chque is draw from bank. cheque no are not
in same raw. numbers are in different row i just want to findout the same
chequ number in bothe colum.
thanks.

"Gord Dibben" wrote:
In D1 enter =A1=C1


Copy down by double-clicking the fill handle of C1


Gord Dibben MS Excel MVP


On Thu, 12 Jul 2007 09:30:03 -0700, 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


=IF(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,0)),"Not Found","Found")

Put in C1 and copy down to C500. This will return "Found" if the
cheque no in column A is also listed in column B.


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 524
Default How to get true/false in one or two colum

Thu, 12 Jul 2007 09:30:03 -0700 from Qazi Ahmad
:
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


Please read responses in the other newsgroup where you posted this,
and in the future please don't post duplicate articles.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not just True/False DWD Excel Discussion (Misc queries) 6 February 2nd 07 10:07 PM
#REF!, TRUE or FALSE Hurtige Excel Worksheet Functions 1 August 11th 06 02:18 PM
Search for 2 true arguments and return true or false David Excel Discussion (Misc queries) 3 July 15th 06 10:18 AM
Function to return True/False if all are validated as True by ISNU Tetsuya Oguma Excel Worksheet Functions 2 March 15th 06 10:28 AM
Reverse false and combine with true true value Emmie99 Excel Worksheet Functions 5 August 17th 05 04:38 PM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"