Trouble creating a excel list that skips blanks

Microsoft Excel 2010 - complete product...
September 7, 2018 at 02:44:56
Specs: Windows 7
I have a list of references that I want to create a list using a formula but I cannot seem to get it to work. I've been using the formula '=IF(ISERROR(SMALL($B$2:$B$27,ROW())),"",SMALL($B$2:$B$27,ROW())) but I just get a blank cell. A sample of the data I have to work with is below. Would really appreciate some help.

BD Companies CI Instalment Contract CN Non-Instalment Contract CI Instalment Contract CN Non-Instalment Contract
121732347 PORT GBCMU3 5?D3OS3T_p6 =IF(ISERROR(SMALL($B$2:$B$27,ROW())),"",SMALL($B$2:$B$27,ROW())) =IF(ISERROR(SMALL($C$2:$C$27,ROW())),"",SMALL($C$2:$C$27,ROW()))
137970229 PORT GBCMU3 5LD8COL6_p6
138425513 PORT GBCMU3 5LD8COR8_p6
137974542 PORT GBCMU3 5LD8COX5_p6
137967066 PORT GBCMU3 5LD8CP2Z_p6
138431231 PORT GBCMU3 5LD8CP8T_p6
115430913 PORT GBCMU3 6VD4AWLI_p6
115431509 PORT GBCMU3 6VD4AWZ9_p6
115429982 PORT GBCMU3 6VD4AXD0_p6
115423416 PORT GBCMU3 6VD4B0R9_p6
115430918 PORT GBCMU3 6VD4B1IR_p6
128969552 PORT GBCMU3 E?D7CH77_p6
128969552 PORT GBCMU3 E?D7CHD6_p6
126794618 PORT GBCMU3 I1D3XUBE_p6
126791722 PORT GBCMU3 I1D3XUPC_p6
162549421 PORT GBCMU3 J=D3XTJ0_p6
115428676 PORT GBCMU3 Q*D8KCEC_p6
115428676 PORT GBCMU3 Q*D8KCMM_p6
137300857 PORT GBCMU3 SDD4NON3_p6
117905737 PORT GBCMU3 U.D43A5R_p6
354759 PORT GBEFE0 )!D8KIMY_p6
96950805 PORT GBRHM0 YLD9DWIX_p6
143937649 PORT GBRHM2 :RD90PYS_p6
121779952 PORT GBRHM2 2QD8KHYW_p6
121779952 PORT GBRHM2 2QD8KJKH_p6
139712485 PORT GBRHM2 8XD7BUMZ_p6


See More: Trouble creating a excel list that skips blanks

Reply ↓  Report •

#1
September 7, 2018 at 05:26:37
First, I'm confused. What does this mean?

"I have a list of references that I want to create a list..."

Second, your subject line mentions "...A Excel List That Skips Blanks" but I don't see any mention of "blanks" in your actual post. Once again, I'm confused.

Third, please click on the following How-To link and read the instructions on how to post example data in this forum. Then repost your data so that it is easier for us to read. Don't forget to use Row numbers and Column letters so that we can understand your layout.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question