Hi people!
This is probably so easy for most of you and I imagine you could do it in your sleep, however after fiddling around I've still gotten no where.
I have an excel sheet, with around 30,000 columns and quite a lot of rows about Pro Cycling and how I rate their performances. Column one has an ID, then the other columns lots of data about the cyclist (not private, just how good they do in my opinion aka in mountains/sprints etc).
Basically I want a seperate sheet where I can type in the Cyclist name/ID and it comes up with the Cyclist and their stats. Obviously this can be done via formulas I think?
As I said, you'll probably be laughing at how easy this is but I'm such a novice and completely stuck, any help/advice appreciated.
This is probably so easy for most of you and I imagine you could do it in your sleep, however after fiddling around I've still gotten no where.
I have an excel sheet, with around 30,000 columns and quite a lot of rows about Pro Cycling and how I rate their performances. Column one has an ID, then the other columns lots of data about the cyclist (not private, just how good they do in my opinion aka in mountains/sprints etc).
Basically I want a seperate sheet where I can type in the Cyclist name/ID and it comes up with the Cyclist and their stats. Obviously this can be done via formulas I think?
As I said, you'll probably be laughing at how easy this is but I'm such a novice and completely stuck, any help/advice appreciated.