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
Microsoft Excel course by Ajay Anand

Featured course

Excel: Beginner to Confident User

The complete step-by-step course — taught the same way as my videos, at your own pace.

  • Formulas, functions & clean data
  • Charts & PivotTables
  • Shortcuts & efficient habits
Enroll on Udemy

Taught by Ajay Anand · 7× Microsoft Excel MVP

Lifetime access · 30-day guarantee

Microsoft Excel course by Ajay Anand

Featured course

Microsoft Excel Beginner to Professional (Malayalam)

The complete step-by-step course — taught the same way as my videos, at your own pace.

  • Formulas, functions & clean data
  • Charts & PivotTables
  • Shortcuts & efficient habits
Enroll on Udemy

Taught by Ajay Anand · 7× Excel MVP

Lifetime access · 30-day guarantee

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

Archives

  • September 2026
  • 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
© 2026 XL n CAD • Built with GeneratePress