IF question complicated

[Anon]

Hi there hoping someone can help.
My documents looks something like this.

Begin End C this formula will be put in c1
1 1 If(a1>1,b1<>"",b1 else go down the
column until you find a number and put it in C1 so that it
2 ***I want to be able to but begin
and end time on the same line so I can manipulate the data later.
3
4 2
5 1
6
7 3
8 2
9
10
11 4

Hope this is clear it would need to look like this
Begin End C
1 1 2
2
3
4 2
5 1 3
6
7 3
8 2 4
9
10
11 4


Thank you for reading this....
CD

 

[Max]

Assume that the source data posted is within A1:B11
In C1: =COUNTIF($A$1:A1,"<>")
In D1: =COUNTIF($C$1:C1,C1)
In E1, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(D1=1,INDEX(B$1:B$11,MAX(IF(C$1:C$11=C1,ROW(C$1:C$11)))),"")
Copy C1:E1 down to E11. This "pulls" up col B's data (End) and aligns it
exactly as sought with col A's data (Begin) in col E.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[Anon]

Assume that the source data posted is within A1:B11
In C1: =COUNTIF($A$1:A1,"<>")
In D1: =COUNTIF($C$1:C1,C1)
In E1, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(D1=1,INDEX(B$1:B$11,MAX(IF(C$1:C$11=C1,ROW(C$1:C$11)))),"")
Copy C1:E1 down to E11. This "pulls" up col B's data (End) and aligns it
exactly as sought with col A's data (Begin) in col E.
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik







- Show quoted text -

Thank you sooo much you are a genius.... It works I didn't thinkt his
was possible. Thanks again for your time.

 

[Max]

Welcome, and thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[Bernd P]

Hello,

Array-enter into C1:
=IF(ISBLANK(A1),"",INDEX(B2:B$65536,MATCH(FALSE,ISBLANK(B2:B$65536),
0)))

Regards,
Bernd