Howdie all :)

Problem...My data is of two types

Type I - Numbers or #N/A - these are in cells a1,c1,e1,g1

Type II - Text or #N/A - these are in cells b1,d1,f1,h1

For Type 1

I need to put in cell I1 the first (or any) instance of a number - The

number if picked up in a1,c1,e1,g1 will always be the same, ie only two

options - the number or a N/A. I want the formulae in I1 to look at

a1,c1,e1,g1 and tell me what the number in the range is.

For Type II

Same as above but I need to display in J1 the result of the first

instance of text (text will always be the same - could either be text

(eg ABC234) or NA that could be in b1,d1,e1,g1..

MANY THANKS

D

*** Sent via Developersdex http://www.yqcomputer.com/ ***

Type I:

=IF(NOT(ISERROR(A1)),A1,IF(NOT(ISERROR(C1)),C1,IF(NOT(ISERROR(E1)),E1,G1)))

Type II:

=IF(NOT(ISERROR(B1)),B1,IF(NOT(ISERROR(D1)),D1,IF(NOT(ISERROR(F1)),F1,H1)))

HTH,

Bernie

MS Excel MVP

=IF(NOT(ISERROR(A1)),A1,IF(NOT(ISERROR(C1)),C1,IF(NOT(ISERROR(E1)),E1,G1)))

Type II:

=IF(NOT(ISERROR(B1)),B1,IF(NOT(ISERROR(D1)),D1,IF(NOT(ISERROR(F1)),F1,H1)))

HTH,

Bernie

MS Excel MVP

1. Finding values (text,numbers, regexps) in objects (arrays or key/value pairs)

3. index n's maximun values in an array

4. Mofify data values of n's variables

5. How to find the number of values under a custom field(lookup value

6. Finding a value then if not found find the value -1 character

7. Finding a value then if not found find the value -1 character and

8. formatting number value to text value in excel

9. converting text values to number & decimal values..

10. How to match a text value to a number value?

11. Concatenating date field into text ands using in a formula

12. Converting Option Group number values to text values

13. Find the each number used in row #1 and sum value of each number

14. Finding Closest Match To A Number Then Returning Field Value Linked To Number

15. changing a text value to a number value in a textbox?

3 post • Page:**1** of **1**