View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mauricio G. Mauricio G. is offline
external usenet poster
 
Posts: 1
Default take values from column A for values0 in column B

I have a table similar to Sheet 1 and need convert to Sheet 2, Exist a
function or how work???

Sheet 1 Sheet 2
Cod Value | C1 C5 C7
C1 25 |
C2 |
C3 | ===
C4 |
C5 10 |
C6 |
C7 2 |