Excel Exercise
RSS
  • Learning Excel
    • 1-Excel Keywords
    • 2-First Calculation
    • 3-Number Format
    • 4-Formula with cell reference
    • 5-Function SUM
    • 6-Copy Paste
    • 7-Reference with Dollar
    • 8-Fill Series
    • 9-Quiz for beginner
  • Quizzes
    • Quiz Excel for Beginners
    • Quiz Excel for Advanced Users
    • Quiz Excel for Expert Users
    • Quiz Excel Keywords
    • Quiz Excel Shortcuts
  • Exercises
  • Functions
  • Tips and Tricks
  • Pivot Table
  • Contact
  • French

Most Viewed Posts

  • Displaying Negative Numbers in Parentheses – Excel (261,140)
  • How to make automatic calendar in Excel (161,540)
  • Dash for 0 in Excel (133,285)
  • Convert YYYYMMDD to DD/MM/YYYY (117,406)
  • Date Format in Excel (113,335)
  • Excel Split Date and Time (91,495)
  • How to calculate VAT in Excel? (89,070)
  • Exchange rate in Excel (81,152)
  • UNIQUE Function – Remove duplicates with formulas (67,916)
  • Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde (63,917)
  • Add Emojis to your charts, formulas (60,192)
  • Comma or Semicolon in an Excel formula (59,714)
  • Compare 2 Columns (56,958)
  • Change the default Date format in Excel (51,907)
  • Dynamic SUM in Excel (44,973)

Random

Extract Sample with Excel

Extract sample randomly in Excel

How to extract a sample of data random data? A combination of a random number and the function INDIRECT will return the result expected.
How to use the cell's contain in a reference

Function INDIRECT

The INDIRECT function provides you to create dynamique references by using the cells' contain as part of your references.
Extract sample randomly in Excel

Recent Posts

  • Calculate Quarter with Excel
  • Move a cell with the mouse in Excel
  • Change the language of Excel
  • Excercise for beginners: Create a drop-down menu
  • Excercise for beginner: Create an Invoice with Excel
  • Exercise for beginners: functions SUM, MIN, MAX Excel
  • Exercise for beginners: Dollars in Excel Formula
  • Exercise for beginners: Use the cells in your calculation
  • Power Query Split Date and Time
  • Excel negative hours

Random

Extract Sample with Excel

Extract sample randomly in Excel

How to use the cell's contain in a reference

Function INDIRECT

Contact us
About me 
Private Policy

@2023 – www.excel-exercise.com. All Right Reserved.
Excel Exercise is managed by majordome du net

Contact us
About me 
Private Policy

@2023 – www.excel-exercise.com. All Right Reserved.
Excel Exercise is managed by majordome du net