Formula and Formating Help

J

Jeremy

I have a spreadsheet that I am needing to place information in C in A. Below
is what the sheet looks like as well as what it should look like.

Current
A B C
1 Ref 1234
2 123/09
3 049/04
4 Ref 1235
5 123/09
6 049/04
7 197/01



With Formula or Formating
A B C
1 Ref 1234
2 1234 123/09
3 1234 049/04
4 Ref 1235
5 1235 123/09
6 1235 049/04
7 1235 197/01

Thank you
 
S

Sean Timmons

May as well do this:

In A2:

=IF(B2="Ref","",if(B1="Ref",C1,A1))

and copy all the way down.
 
J

Jeremy

This works with one proplem. Where the Ref is Ref will always be the first
part but there are characters after that change.
 
S

Sean Timmons

OK, so you can just change to look at C instead.

=IF(C2>"","",if(C1>"",C1,A1))
 
J

Jeremy

Sorry when I stated characters after I mean that the REF whill have charters
after for example REF12 or REF/WO and so on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top