View Single Post
  #1  
Old 27th February 2016, 03:05 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default Excel formula help needed.

I currently use this formula

=IF(A1="","",IF(A1="end","",MATCH("?*",INDEX(A:A,1+MATCH(B1,A:A,0)):A$1048576,0)))
to get this result.

Excel 2010
ABC
1test1test15
2data
3data
4data
5data
6test2test24
7data
8data
9data
10test3test33
11data
12data
13end

Sheet1





But what i need is for it to be modified to ignore blank spaces so i can get this result.

Excel 2010
FGH
1test1test14
2data
3
4data
5data
6test2test23
7data
8data
9
10test3test33
11data
12data
13end

Sheet1



__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote