|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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
Sheet1 But what i need is for it to be modified to ignore blank spaces so i can get this result. Excel 2010
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 _______________________________________________ |
Thread Tools | Search this Thread |
Display Modes | |
|
|