View Single Post
  #1   Report Post  
sonar
 
Posts: n/a
Default 1-7 Columns, to find last column with figure in


Hi

I have prices in Mo, Tu, We, Th, Fr, Sa, Su Columns.

These figures arrive from information inserted in different sheets
called Mo, Tu, We, Th, Fr, Sa, Su.

What I would like to know is, what formula would be best to use to
check which column had a price in last. Say Mo R10, Tu R12, We R13 Tu,
Fr, Sa, Su, and it will give the answer R13 (which is Wednesday)

Can anyone recommend something?

Thanks
Sonar


--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=400942