| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula and Formating Help
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and Formating Help
May as well do this:
In A2: =IF(B2="Ref","",if(B1="Ref",C1,A1)) and copy all the way down. "Jeremy" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and Formating Help
This works with one proplem. Where the Ref is Ref will always be the first
part but there are characters after that change. "Sean Timmons" wrote: May as well do this: In A2: =IF(B2="Ref","",if(B1="Ref",C1,A1)) and copy all the way down. "Jeremy" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and Formating Help
OK, so you can just change to look at C instead.
=IF(C2"","",if(C1"",C1,A1)) "Jeremy" wrote: This works with one proplem. Where the Ref is Ref will always be the first part but there are characters after that change. "Sean Timmons" wrote: May as well do this: In A2: =IF(B2="Ref","",if(B1="Ref",C1,A1)) and copy all the way down. "Jeremy" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and Formating Help
Sorry when I stated characters after I mean that the REF whill have charters
after for example REF12 or REF/WO and so on. "Sean Timmons" wrote: OK, so you can just change to look at C instead. =IF(C2"","",if(C1"",C1,A1)) "Jeremy" wrote: This works with one proplem. Where the Ref is Ref will always be the first part but there are characters after that change. "Sean Timmons" wrote: May as well do this: In A2: =IF(B2="Ref","",if(B1="Ref",C1,A1)) and copy all the way down. "Jeremy" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and Formating Help
Ohh!!
=IF(ISERROR(SEARCH("Ref",B2)),IF(ISERROR(SEARCH("R ef",B1)),A1,C1),"") "Jeremy" wrote: Sorry when I stated characters after I mean that the REF whill have charters after for example REF12 or REF/WO and so on. "Sean Timmons" wrote: OK, so you can just change to look at C instead. =IF(C2"","",if(C1"",C1,A1)) "Jeremy" wrote: This works with one proplem. Where the Ref is Ref will always be the first part but there are characters after that change. "Sean Timmons" wrote: May as well do this: In A2: =IF(B2="Ref","",if(B1="Ref",C1,A1)) and copy all the way down. "Jeremy" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating with IF and AND formula | Excel Discussion (Misc queries) | |||
| Conditional Formating Formula? | Excel Discussion (Misc queries) | |||
| IF formula with conditional formating help please | Excel Discussion (Misc queries) | |||
| Formula Formating | Excel Worksheet Functions | |||
| Formating with a formula | Excel Discussion (Misc queries) | |||
Linear Mode
