View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
something68 something68 is offline
external usenet poster
 
Posts: 38
Default Extract two separate totals from one column

In Column A, row 8 - I show: A, S
In Column A, row 9 - I show: 1.0, 7.0

I would like Column M, row 9 to extract 1 from column a, row 9
I would like Column O, row 9 to extract 7 from column a, row 9