View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default True false function for alpha data

In C1 enter =B1=A1

Copy down.


Gord Dibben MS Excel MVP

On Tue, 17 Nov 2009 12:36:06 -0800, R Y <R
wrote:

Row # Column1 Column2 Outcome
1 80E 80E TRUE
2 999 80E FLASE
3 80E 80E TRUE
4 CB1 80E FALSE
5 80E 80E TRUE
6 999 80E FALSE
7 999 C76 FALSE

I'm trying to write a formula that gives me a true/false outcome for the
above data and the results would be where the outcome is located (completed
manualy)