Hi All,
A small sumproduct question.
Can sumproduct be used to look up text data?
I have a fictitious data with names in column A, subject 1, subject 2 etc in column B onwards and Grades in column H.( Grades are A, B etc.)
Using sumproduct I can find the marks obtained by a person in any...
Hi All,
I have learned a lot of good things in Excel from this site.
Now I am planning to learn VBA.
Can you guide me to some good resources available on the net for learning VBA?
Thanks in advance!!
Jai