Exel calculation

  Quickbeam 06:12 28 Jan 10

How do I go about writing a formula to help me learn the various note positions on a guitar fret board.

ie, I want to put the note values A B C D E F G A into a line of cells, and then have a button that randomly re-orders them. The idea being that I then have to play the random notes as an exercise in finding them naturally on the fret board.

Usually when I think Excel can do something, it can, but I just don't know how to make it:(

Thanks QB

  VoG II 07:39 28 Jan 10

Put those letters into one column. In the next column enter


and copy down to the last cell with your letters. Select both columns and sort by the RAND column to randomise the letters.

  Quickbeam 08:18 28 Jan 10

I thought that it was going to be incredibly complicated. What is they say about what's under your nose...

Thanks, QB

  Quickbeam 08:48 28 Jan 10

I've assigned a macro key to it, and I then just have to play the note sequence as fluidly as I can on the fret board when I hit the key.

Thanks again, QB.

  Quickbeam 10:48 28 Jan 10

I've done MK11 now, with high, low & open string notes.

Used in conjunction with webmetronome.com it's quite an exercise to keep up fluidly.

This thread is now locked and can not be replied to.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…