Move to next cell if the statement is false return value if true. -- PROBLEM

XYreal

New Member
Joined
Dec 13, 2016
Messages
1
ABC
1
20166-78#N/A
220166-110#N/A
320166-134#N/A
420166-135#N/A
520166-78
6#N/A
7#N/A
8#N/A
9#N/A
10#N/A
1120166-110
1220166-134
1320166-135
1420167-13
15#N/A
16#N/A
1712357-9
18563263-8

<tbody>
</tbody>



what formula should I used to get just the cell with values and not with "N/A".
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,118,309
Messages
5,571,477
Members
412,395
Latest member
nielsvanlit
Top