View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
union865kri[_4_] union865kri[_4_] is offline
external usenet poster
 
Posts: 1
Default Excel Formula or VBA???

It does show up in the posts that I read, but since it isn't in the on
you ar reading, I'll add it.

=((LARGE(OFFSET(R1,0,0,1,-(COLUMN(R1)-LARGE(IF(A1:R1<"",COLUMN(A1:R1))
,5)+1)),2)+LARGE(OFFSET(R1,0,0,1,-(COLUMN(R1)-LARGE(IF(A1:R1<"",COLUMN
(A1:R1)),5)+1)),3)+LARGE(OFFSET(R1,0,0,1,-(COLUMN(R1)-LARGE(IF(A1:R1<"
",COLUMN(A1:R1)),5)+1)),3))/3 -36)*0.9

If you have any ideas, I do appreciate it. Thanks again

--
Message posted from http://www.ExcelForum.com