Thread
:
True false function for alpha data
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
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)
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben