Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Ap ageing worksheet, to ten vendors, protected worksheet

    The file attached below is an account payable ageing report created by my self and some friends from Windows Secrects. The next steps I would like to do are the following:

    1. Obtain the top 10 Vendors that we owe the highest amount within the ageing worksheet.

    2. Be able to open the detail and close to summary of the vendor with the worksheet being protected.

    is this too much for Excel to do. Please no Maros.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In a blank sheet, add the headers (change as desired):
    A1: Rank
    B1: Inv Amt
    C1: Vendor name

    In A2:A11 enter the values 1-10 respectively
    In B2 enter the array formula (confirm with ctrl-shift-enter):
    =LARGE(IF(RIGHT(AGEING!C10:C2545,5)="TOTAL",AGEING !H10:H2545),A2)
    In C2 enter the formula:
    =INDEX(AGEING!C:C,MATCH(B2,AGEING!H:H,0))

    Copy B2:C2 to B3:C11

    2) select the sheet to be protected
    Review - protect sheet (select the desired options, add a password if desired).

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I'll give it a try. Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •