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)
  • Logit

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

    p45cal

    Change the Font Size on the displayed LOV

    In which case, best attach a file where this is happening (only showing a few cells behaving this way, maybe the macro trying to adjust the font, but...

    p45cal Yesterday, 06:44 PM Go to last post
    amyfb

    Change the Font Size on the displayed LOV

    oh, you had me all excited there for a minute, but, when I looked, the shrink to fit box is unchecked. I took off word wrap as well, just in case that...

    amyfb Yesterday, 06:35 PM Go to last post
    p45cal

    Change the Font Size on the displayed LOV

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

    p45cal Yesterday, 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 Yesterday, 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 Yesterday, 02:46 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 11:57 AM.
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