Average by Date

  • Thread starter inta251 via OfficeKB.com
  • Start date
R

Ron Coderre

Try this:

On the "Company" sheet
Put this ARRAY FORMULA (use 'ctrl+shift+enter'....instead of 'enter') in
A2:
=IF(SUM((trips!$W$2:$W$10000<>"")*ISERROR(MATCH(trips!$W$2:$W$10000,$A$1:A1,0)))<>0,INDEX(trips!$W$2:$W$10000,MATCH(1,--ISERROR(IF(ISBLANK(trips!$W$2:$W$10000),0,MATCH(trips!$W$2:$W$10000,$A$1:$A1,0))),0),1),"")

Copy that formula down as far as you need.
(adjust range references to suit your situation)


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
I

inta251 via OfficeKB.com

Ron, thanks for respond!
BINGO! BINGO! BINGO!
THANKS! THANKS! THANKS!
Only one little problem, i can not do sort ascending.
But i can live with that.
Once again, THANKS!
 
R

Ron Coderre

Please try this:

With my previously posted formula starting in A2 and copied down

Put this formula in B2 and copy down
=T(LOOKUP(MATCH(SMALL(INDEX(COUNTIF($A$1:$A$10,"<"&$A$1:$A$10)+($A$1:$A$10="")*10^10,0),ROWS($A$2:A2)),INDEX(COUNTIF($A$1:$A$10,"<"&$A$1:$A$10)+($A$1:$A$10="")*10^10,0),0),ROW($A$1:$A$10),$A$1:$A$10))

That formula will list the Col_A values in ascending order.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
I

inta251 via OfficeKB.com

This is just perfectoooooo!!!!!
I did just as you posted. Working 100%+.
To make nice view, i just hide column A.
Sometime i am wondering, how you guys can keep in the head all this formulas.
Anyway, THANKS for your help.
Sincerely, Igor. (inta251)
 
R

Ron Coderre

Thanks for letting me know that worked for you.....I'm glad I could help.


***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top