Use Last Recognized Cell, simple task, help!

[kittykater]

Hey Guys,


Been wracking my brain around this, seems like it should be easy to do and I'm sure it is.


So I have this simple report shown here

All I need to do is populate the second column like so. Is there a formula or way (perhaps using countifs?) to do this?

Thanks for the help!

Cross Posted Here:


http://www.excelforum.com/excel-gen...l-simple-task-help.html?p=2834611#post2834611


http://www.mrexcel.com/forum/showth...-Cell-simple-task-help!&p=3188093#post3188093


http://www.ozgrid.com/forum/showthread.php?t=166831&p=614685#post614685

 

[xladept]

Hi KittyKater,

Try this:

=IF(MID(A46,1,1)=">",B45,A46)

 

[T. Valko]

Hey Guys,


Been wracking my brain around this, seems like it should be easy to do and I'm sure it is.

All I need to do is populate the second column like so. Is there a formula or way (perhaps using countifs?) to do this?

Thanks for the help!

Cross Posted Here:


http://www.excelforum.com/excel-gen...l-simple-task-help.html?p=2834611#post2834611


http://www.mrexcel.com/forum/showth...-Cell-simple-task-help!&p=3188093#post3188093


http://www.ozgrid.com/forum/showthread.php?t=166831&p=614685#post614685

Try this...

Enter this formula in B1:

=A1

Enter this formula in B2 and copy down as needed:

=IF(LEFT(A2)=">",B1,A2)