Formula to skip a cell

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

This is a bit confusing (at least to me)

Worksheet B is pulling data from worksheet A. This is
needed only if column C is not = to "n/a". In order to
not have blank rows in W/S B, the formula says to use the
next row of info as such:

=IF('Data input Sheet'!C11="N/A", 'Data input Sheet'!
12:12,'Data input Sheet'!A11)

With "Data input Sheet" being the worksheet A stated above.
In this case, the Row the formula is from is Row 11.

Now the problem is that if column "C" is = to n/a, it uses
the next row of information. If the next row's column "C"
is not = to n/a, it is also listed causeing a duplicate
record on my worksheet.

Is there a way to avoid a duplication and also avaoid a
blank row of info.

Thanks
Doug
 
Doug,

One possible solution is to change your formula to return a blank if
the value is N/A:

=IF('Data input Sheet'!C11="N/A","",'Data input Sheet'!A11)

then use Data | Filter.... AutoFilter, and select Non-Blanks on your
range with the formulas.

If that isn't satisfactory, then you would really need a macro
solution and not a formula solution.

HTH,
Bernie
 
Back
Top