Quote:
|
Originally Posted by Bill_Hancoc
This is really great, could you please explain to me how you do things like this?
I would like to make a few team related updates for scouting purposes.
|
I should let Karthik answer, but here is my take on how to make Excel sing.
One of the most under utilized functions... ...function pairs actually are MATCH and OFFSET.
Basically, you use MATCH to find what row a something is in then use the OFFSET function to return the contents of a cell that is near that cell (perhap in the same row only in another column).
IF is another very powerful function that lets you pick the right value or dislay errors etc.
OFFSET, MATCH and IF are pretty clunky to use due to their syntax, but once you get the zen of Excel syntax, you can make very powerful spreedsheets.
Joe J.