Hi, My name is Anand Varma. I am Chartered Accountant by Profession. Working for Multidisciplinary Civil Engineering Consultancy Company in Hyderabad, India.

I am interested in Google Docs Spread Sheets, Indian Taxation

Top Contributor in Google Docs

You can contact me at anandexcels@gmail.com

4 Responses to About

  1. lloyd says:

    You seem to have errors in your formulas:
    =sumif(a1:a10,’pencil’,c1:c10) returns a syntax error.
    Need to separate the parts with ; not ,


  2. Robbe says:

    Hi Anand,

    Do you have any idea how to make a unique team column (team exist out of 2 persons)with all possible combinations from 1 column with person names?

    So if you have 4 persons

    You will have 6 unique teams:
    Pol & Alex
    Pol & Bart
    Pol & Mark
    Alex & Bart
    Alex & Mark
    Bart & Mark

    I know I probably will have to use your formula explained here


    But can you point me in the right direction ?

    Thanks in advance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: