Thread: Separate value in 1 column to 2 columns based on value in other co
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Versace77 Versace77 is offline
external usenet poster
  
Posts: 29
Default Separate value in 1 column to 2 columns based on value in other co
Hi everyone,

Looking for help on trying to separate debits/credits that are listed in one
column (Column 2). Column 4 has either a DB or CR. I'm looking for a way to
have the values in C2 move (cut/paste) to Column 3, same row, if the value in
C4 is a CR.

Thanks as always.

Versace77
Reply With QuoteReply With Quote