• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Getting the list of positions in an array [SOLVED]

    Thanks Debraj,NarayanK for quick reply.Members like you make this forum great... @bobhc:The question posted is little different from the one i previous one..thats way it is posted separately....
  2. K

    Getting the list of positions in an array [SOLVED]

    Here is the data i have: A1=1 A2=2 A3=1 A4=3 A5=2 C1=2 how can i get the list of positions of C1 in the column A(in this case 2 and 5)...
  3. K

    Getting lowest positions value in a list depending upon an index [SOLVED]

    thanks man...much appreciated...
  4. K

    Getting lowest positions value in a list depending upon an index [SOLVED]

    Here is the data i have: A1=1 B1=P A2=2 B2=Q A3=1 B3=R A4=3 B4=S A5=2 B5=T C1=2 Now i want to fetch 1ST record from column B based upon an index value in A depending upon value in C1. e.g. for C1=2,i should get E1=Q ,i should not get T here e.g. for...
  5. K

    Noob question Excel if query [SOLVED]

    thanks man...it helps...
  6. K

    Noob question Excel if query [SOLVED]

    In columns A of excel sheet i have values (1,1,2,2) in another cell i put up a formula : =IF(A1:A4=1,"yes","no") i'm getting : 'yes' as output,which is correct.No problems there!! in another cell i put up a formula : =IF(A1:A4=2,"yes","no") i'm getting : 'no' as output,which is clearly...
Back
Top