Latest activity

  • M
    Muh replied to the thread Filter & Find.
    Very Nice Sir , But While Using This Formula There is Division It is showing as 2 times. This is because the Value is in the Same...
    • 1752257204707.png
    • 1752257385352.png
  • shamimarita
    shamimarita replied to the thread Filter & Find.
    Hello Muh, You can use the following formula to show values based on the Month and Employee. Formula: =LET( combined...
    • 1752212971905.png
  • M
    Muh replied to the thread Filter & Find.
    Hi Can anyone Write a formula
  • shamimarita
    shamimarita replied to the thread micro.
    Hello Momo, You can use a simple VBA macro to rename sheets with the names of the months automatically. Go to the Developer tab >>...
  • M
    momo123 posted the thread micro in Macros & Excel VBA.
    i want a micro that names pages with the names of months otomatice
  • M
    Muh posted the thread Filter & Find in Excel Formulas.
    There is a data From Jan to May In Separate Sheets . We Need Answer required in "Table Sheet " 1. Answer Required Based On 2 Drop down...
  • shamimarita
    shamimarita replied to the thread [Solved] Leaderboard.
    Hello Gina, You’re very welcome, and I’m so glad to hear you got everything working and looking great! For your message board idea...
  • G
    Gina replied to the thread [Solved] Leaderboard.
    Thank you so much Shamimarita, I got it all figured out and it looks great. I am now trying to complete a message board for when the...
  • shamimarita
    shamimarita replied to the thread [Solved] Leaderboard.
    Hello Gina, Yes, the formula typically relies on the Month column in your source data (the table with Name, Month, Score), but you do...
  • G
    Gina replied to the thread [Solved] Leaderboard.
    YES! I got it to work! The only problem is that the formula seems to require a Month column o the leaderboard.
    • Leaderboard.png
    • Data.png
  • shamimarita
    shamimarita replied to the thread [Solved] Leaderboard.
    Hello Gina, You're welcome! No worries, setting up the structure can be a bit tricky at first. Here’s a simple example to help you...
  • G
    Gina replied to the thread [Solved] Leaderboard.
    Thank you, I am still confused as I am guessing my setup is incorrect with the data. I know the functions but not how to properly use them.
  • shamimarita
    shamimarita replied to the thread [Solved] Leaderboard.
    Hello Gina, You can set up a dynamic leaderboard that pulls data from another spreadsheet and updates based on the selected month...
  • G
    Gina posted the thread [Solved] Leaderboard in Excel Formulas.
    Hello, I am trying to create a leaderboard that will use data from another spreadsheet and will be able to populate based on the month...
  • shamimarita
    Hello Isaggs, It sounds like you’ve created tabs (worksheets) using VBA/macros, but some of them stop working or become unresponsive...

Online statistics

Members online
1
Guests online
49
Total visitors
50

Forum statistics

Threads
419
Messages
1,859
Members
918
Latest member
Iconicunarp
Back
Top