Using Excel to create a test of random questions, pulled from a table of data

Micfish

New Member
Joined
Sep 18, 2014
Messages
4
Is this feasable? has anyone had any experience doing this?

As it says in the FAQ, im not asking someone to do my work for me, i would just like a little guidance and/or a point in the right direction.

I have a table of information that is approx. 12 columns by 90 rows of data, and I would like to organize random questions that would select a row if information, and query the user based on column headings.

So, row x column = answer, but setup so that it does this in random question format.

I dig these types of challenges, but I'm not sure how to start.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

NeonRedSharpie

Well-known Member
Joined
Jul 14, 2014
Messages
1,678
Maybe post some sample data? I'm not quite getting the layout. Are you looking for an automatic userform type interface? How are the questions being accessed?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,541
Messages
5,529,436
Members
409,877
Latest member
DDhol
Top