Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not just True/False | Excel Discussion (Misc queries) | |||
#REF!, TRUE or FALSE | Excel Worksheet Functions | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Reverse false and combine with true true value | Excel Worksheet Functions |