Thread: Excel - in a row of numbers, put last entered number Cell B2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJ RJ is offline
external usenet poster
  
Posts: 40
Default Excel - in a row of numbers, put last entered number Cell B2
Cell A1 has number for January, Cell A2 number for Feb, Cell A3 number for
Mar etc.

I need a formula that will pull the data from the last month entered into
B2. (IF A12 is blank get A11, but if A11 is blank get A10, if A10 is also
blank get A9 etc.) This needs to go for at least 12 - 15 cells)
Thanks
Reply With QuoteReply With Quote