Tyril_Simmons
New Member
- Joined
- Apr 17, 2002
- Messages
- 2
I'm trying to use Excel built in functions to return the first value after the #N/A within my range of data. The data appears in column A1:A24 as shown below:
2
#N/A
3
4
5
6
7
#N/A
#N/A
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
The function should return the value 3.
Any one with any ideas?
2
#N/A
3
4
5
6
7
#N/A
#N/A
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
The function should return the value 3.
Any one with any ideas?