Search:

Type: Posts; User: genetist; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: maintaining pattern while dragging down the column in excel

    Dear Norie and Scott T
    thanks lot for your help and time spent to help your formula working perfectly as per my needs
    once again thanks lot
  2. maintaining pattern while dragging down the column in excel

    hi to all
    Good Evening

    I have values 1, 2, 3 in column A and then i want to copy them in column B like
    1
    2
    3
    1
    2
    3
  3. Re: Matching one row with another row of same column iteratively and getting sum at bottom of the column?

    Dear Peter_SSs
    sorry for my late reply. your formula worked perfectly on my data. Thanks lot for your help and time spent on this
    Regards
  4. Re: Matching one row with another row of same column iteratively and getting sum at bottom of the column?

    sorry for that please find here. i do not know why it went wrong and showing that error
    https://www.dropbox.com/s/iq7m5a2e4ekt35x/SNP%20PIC.xlsx?dl=0
    regards,
    Genetist
  5. Matching one row with another row of same column iteratively and getting sum at bottom of the column?

    Dear All
    good morning

    I have data like this
    IND M1 M2 M3 M4 M5
    1 A/A G/G C/C T/T T/T
    2 T/T C/C C/C G/G G/G
    3 C/C T/T C/C C/C C/C
    4 G/G T/T T/T G/C A/A
    5 G/G T/T G/G C/T A/A
  6. macro to convert data matrix to two way table and ranking individuals

    Hi to all
    Good Afternoon

    I got genetic distance matrix based snp genotyping data of 10 individuals in matrix format and now I want convert it into data frame format like genotype1 in columnA and...
  7. Re: formula to repeat column A text after every 3 rows of columnB?

    Dear Rick
    Good Evening

    Thanks lot for your help and your code worked like charm
    Thanks lot for your help
    Genetist
    Regards,
  8. Re: formula to repeat column A text after every 3 rows of columnB?

    Dear Rick
    Good Afternoon

    Thanks lot for your help and your macro code is working like charm. I want to know little bit more, is it if want to add my column A values twice like this

    <tbody>...
  9. Re: formula to repeat column A text after every 3 rows of columnB?

    Dear Rick

    Thank you for your reply on my question. Yes I have data in column B and I want to insert my column A text after every 3 rows in column B and no problem if my output is there in any...
  10. formula to repeat column A text after every 3 rows of columnB?

    <tbody>

    <tbody>
    red
    1


    green
    2
  11. how to count * stars in column range in excel?

    Hi to all
    I would like to count number of * stars between words in a range in a column. I used this formula
    =COUNTIF(rng,"*"&b1&"*"),but no success, I think excel considering * as wildcard and...
  12. deleting all hidden or document properties of all documents from folder with macro

    Hi
    I have some excel files in a folder but they contained some hidden information like author name, last modified etc now I want to remove all this information from all the files in a folder at a...
  13. macro to merge excel files into single master files based on column heading

    Hi to all VBA programmers,

    I have so many excel files in my folder with 20 columns. Now i want to copy copy column B from all these excel files into one single master file because i need only...
  14. Re: picking column A values based on differences between members in column C

    Hi Excel Tactics,
    Thank you very much for your help towards my problem,
    my data looks like this

    <COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
    Member
    chr
    location
  15. picking column A values based on differences between members in column C

    Hi to all,
    I have data like this,

    <COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
    Member
    chr
    location


    web
  16. Macro for columns data validation and percentage calculations

    Hi to all,
    I have data like this
    pop A B C D E
    P1 T/T C/C C/C T/T C/C
    P2 A/A G/G C/C T/T C/C
    1 A/A G/G C/C T/T C/C
    2 A/A G/G C/C T/T C/C
    3 A/T A/C A/G A/T A/C
    4 T/A T/G T/C T/A T/G
    5 G/A G/T...
  17. Re: how to write dynamic SUMIF formula across all the rows in a coulmn

    Dear Andrew and Markmzz,
    Thank you very much for your replies to my querie.
    Andrew i tried your formula in F4 and i am getting all zero even though i have 1 in NE column.

    Markmazz i tried your...
  18. Re: how to write dynamic SUMIF formula across all the rows in a coulmn

    Dear Andrew,

    Thank you very much for your reply, here in my sample data the entries are same but this is not the case for remaining rows there may be diferrences. i want to use one SUMIF formula...
  19. how to write dynamic SUMIF formula across all the rows in a coulmn

    hi to all,
    i have data like this,

    <TBODY>
    AB1</SPAN>
    AB2</SPAN>
    AB3</SPAN>
    AB4</SPAN>
    AB5</SPAN>
    Sum of NE</SPAN>
  20. VBA code needed to compare rows in excel 2010

    hi to all VBA programmers,
    I have data like this with 6 columns</SPAN>

    <TBODY>
    LINES</SPAN></SPAN>

    AB1</SPAN></SPAN>

    AB2</SPAN></SPAN>
  21. Re: macro to paste text for desired number of times in a cloumns

    Thank you very much Dear Andrew poulsom for helping me in solving this problem and spending your valueable time for me.
    with kind regards,
    Genetist
  22. macro to paste text for desired number of times in a cloumns

    Hi to all,
    i have data like this
    A B
    MB1 MB1-1
    MB2
    MB3
    MB4
    MB5

    i want to paste text for MB1 in column B like from MB1-1 to MB1-20 and MB 2-1 to MB 2-20. for MB2 in cloumn B like MB2...
  23. how to make column number movable in vlookup formula

    Hi to all,
    I have data in two sheets, both sheets contains 253 columns data
    for example sheet1
    A B C D E F
    AA BB CC DD EE FF

    Sheet2 contains
    A B C D E F
    BB FF CC DD EE AA
    Now i want to get...
  24. how to get common value in two row comparision

    hi to all,
    i have data like this
    sx1 sx2 sx3 sx4 sx5
    p1 -/- ZZ AA TT ZZ
    p2 AA TT AA TT CC
    and i am expecting data like this
    sx1 sx2 sx3 sx4 sx5
    p1 -/- ZZ AA TT ZZ
    p2 AA TT AA TT CC...
  25. Re: how to get Hlookup value only in specified cell

    Dear kevataravind,
    Thank you very much for your formula and its working. i want to know how to use this formula A2 itself instead of in column G?
    anyway thanks lot for your help
Results 1 to 25 of 66
Page 1 of 3 1 2 3