Skip to content

XL n CAD

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

INDEX Function

Pick a random value from a list in Excel

April 7, 2021 by Ajay Anand

In this blog post, I will explain two Excel formulas that can be used to pick a random value from a List. Following is a list of 6 contestants for a particular game. For each round of the game, a player should be randomly selected from this list. Let’s see how to pick a random … Read more

Categories Excel Formula, Excel Tips and Tricks, MS Excel Tags CHOOSE Function, Excel Formula, INDEX Function, RANDBETWEEN Function

Recent Posts

  • Python Program to Edit Excel Files
  • Python Program to Read Excel Files
  • VLOOKUP from Two or more Tables

Archives

  • March 2023
  • May 2022
  • April 2022
  • March 2022
  • November 2021
  • May 2021
  • April 2021
  • February 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • April 2019

Fly to

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

Top 25 MS Word Tips & Tricks

https://youtu.be/l25Evu4ohKg

Course on Scripting in AutoCAD

© 2026 XL n CAD • Built with GeneratePress