Forum Discussion
Formula Challenge: Create a guitar fretboard diagram
This exercise has helped in my ongoing studies of Excel and learning acoustic guitar. The challenge is to produce the standard tuning (E-A-D-G-B-E) diagram: [This diagram lists 'natural' n...
Patrick2788 OK I have 2 more variations:
=IFERROR(INDEX(strSeq,,SEQUENCE(,12)+XMATCH(Strings,strSeq)),"")
=IF(Strings<>"",INDEX(strSeq,,SEQUENCE(,12)+XMATCH(Strings,strSeq)),"")I'm betting on the 1st ...
Timings: .00087 and .00084
I re-ran the calc timings removing the IFERROR and IF, respectively and the timings were about the same.
I re-ran the calc timings removing the IFERROR and IF, respectively and the timings were about the same.