Posts by fizza94

  • Add/Delete Extra Spaces Per Cell

    Re: Add/Delete Extra Spaces Per Cell


    I still want one space between each column header, not eliminate all spaces. Trim allows to delete spaces before and after the text ends but I still might have 2 or 3 spaces between each column header.


    For example, if only A2 and D2 are yes, I would have 3 spaces between the column headers.

  • Add/Delete Extra Spaces Per Cell

    Hi,


    Attached is a sample of the data I have created. For the 6th column, I have concatenated the appropriate column headers I need, except I want a space in the middle of each of them, if they are put in the system. I have used the simple method of adding a space between each column header, however, i need the space ONLY between 2 column headers, if and when they are added the 6th column. This is what the formula in the 6th column currently says:


    =CONCATENATE(IF(A2="YES",$A$1,""), " ",IF(B2="YES",$B$1,"")," ",IF(C2="YES",$C$1,"")," ",IF(D2="YES",$D$1,""))


    However, there are multiple problems with the spacing. I have attached a sample table for an example.


    Please let me know how i can remove any spaces in front of the very first column header (text) or more than one spaces between 2 column headers (text). thank you!


    forum.ozgrid.com/index.php?attachment/68418/

  • Display A,B,C and/or D based on rows in front

    Re: Display A,B,C and/or D based on rows in front


    That is exactly what I was looking for! Thank you for the easy fix!


    Quote from mohammedismail;766104

    From what I have understood, I believe this is what you are looking for ! Please respond if not !


    [BFN]=CONCATENATE(IF(A2="Yes","A",""),IF(B2="Yes","B",""),IF(C2="Yes","C",""),IF(D2="Yes","D",""))[/BFN]

  • Display A,B,C and/or D based on rows in front

    Hi,


    I have 4 columns with different combinations of yes or no in each row. For the 5th column, I need it to display A,B,C or D, depending on what column has 'Yes' in it. I can construct a long IF function but there are ~16 or so combinations. What is the best method to this? Attached is a sample excel file of the sample of the data.


    Thank you!
    Fiza


    forum.ozgrid.com/index.php?attachment/68387/

  • VBA Code/ Combincation of Excel functions to Tranpose Unique Value data

    Hi,


    I have a 800 page long table that needs to be transposed from rows to columns. For easiness, I assigned a unique number to each person's assigned information, however, I cannot find a simple solution to my problem still, for easily moving each person's information from rows to columns.


    Currently my excel data looks like this:
    1
    A B
    1 tim
    1 300 ave
    1 woodland hills, CA
    1 (123) 456-7890
    2 tam
    2 400 ave
    2 stockton, CA
    2 (123) 456-7890
    2 (123) 456-7890
    3 bob
    3 bobi ave
    3 hills, CA
    3 (321) 654- 9870


    and I need the data to look like this:
    A B c D E F
    1 tim 300 ave woodland hills, CA (123) 456-7890
    2 tam 400 ave stockton, CA (123) 456-7890 (123) 456-7890
    3 bob 500 ave hills, CA (321) 654- 9870


    Please help! I have been stuck on this problem for 3 weeks now and can't seem to find a simple solution :(


    Thank you!