# Formula help with next non blank cell

#### Cherrypi

##### New Member
Hi everyone
I'm not great with excel but am trying to learn. I'm a teacher trying to make a spreadsheet to give some feedback to pupils. I have got it to do some question analysis and identify students weak areas based on there responses and am now trying to collate findings. I need excel to return for me a list of weaknesses from cells.

I have got it to return the first non blank cell using this formula:-
=INDEX('Student Weaknesses'!\$B2:\$R2,MATCH(TRUE,INDEX(('Student Weaknesses'!\$B2:\$R2<>""),0),))

This works fine but I now need to in the adjacent cell to follow the same rule but to return the next non blank cell after this one. I did manage to get it to return the last non blank cell but can't get it to do the next one. It's driving me up the wall and any help would really be appreciated!

Thanks!

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Possibly try the formula below which must be entered with Ctrl-Shift + Enter and not just Enter.

=INDEX('Student Weaknesses'!\$B\$2:\$R\$2,SMALL(IF('Student Weaknesses'!\$B\$2:\$R\$2<>"",COLUMN('Student Weaknesses'!\$B\$2:\$R\$2)-COLUMN('Student Weaknesses'!\$B\$2)+1),2))

Actually if I am assuming right what you are trying to do then try the formula below and drag across.
Again it must be entered with Ctrl-Shift + Enter and not just Enter (if you have done it correctly it will surround the formula with {}).

=IFERROR(INDEX('Student Weaknesses'!\$B\$2:\$R\$2,SMALL(IF('Student Weaknesses'!\$B\$2:\$R\$2<>"",COLUMN('Student Weaknesses'!\$B\$2:\$R\$2)-COLUMN('Student Weaknesses'!\$B\$2)+1),COLUMN('Student Weaknesses'!A:A))),"")

Replies
1
Views
386
Replies
8
Views
327
Replies
5
Views
653
Replies
2
Views
194
Replies
3
Views
345

1,207,401
Messages
6,078,261
Members
446,324
Latest member
JKamlet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back