Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Training
    • Monkey Tools Add-in
    • Monkey Tools Account
    • Books & Other Products
    • Private Courses
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Home

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Word - VBA Programming (8)
  • JoePublic

    There is no available content written by JoePublic
  • MVP Logo
  • Recent Forum Posts

    p45cal

    Change the Font Size on the displayed LOV

    Are you sure you don't have Shrink to fit on?:
    ...

    p45cal Today, 03:03 PM Go to last post
    p45cal

    sumproduct formula or replacement

    Just out of interest, a shorter version of the formula in msg#1 for more recent versions of Excel:

    Code:
    =SUM((INDEX(I2:FD273,SEQUENCE(272),SEQUENCE(,51,1,3))="")*(INDEX(I2:FD273,SEQUENCE(272),SEQUENCE(,51,2,3))=FX13)*(C2:C273=FZ11))
    ...

    p45cal Today, 02:51 PM Go to last post
    p45cal

    find the winner name from highest numbers

    In cell N3:

    Code:
    =IF(L3=MAX($L$3:$L$13),J3,"")
    O3:
    Code:
    =IF(L3=MAX($L$3:$L$13),K3,"")
    P3:
    Code:
    =IF(L3=LARGE($L$3:$L$13,2),J3,"")
    ...

    p45cal Today, 02:46 PM Go to last post
    amyfb

    Change the Font Size on the displayed LOV

    Hello!
    I have a list of values that displays in a very tiny font size, smaller that the size of the values in the list itself.

    I...

    amyfb Today, 02:36 PM Go to last post
    AliGW

    find the winner name from highest numbers

    This has been cross-posted here: https://www.mrexcel.com/board/thread...mbers.1205474/
    ...

    AliGW Today, 01:21 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 04:37 PM.
Powered by vBulletin® Version 4.2.5
Copyright © 2022 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it