Sorting issue

    I was wondering how to show only cells with values in a column. for instance i have information spread throughout a column say column b with multiple rows inbetween each cell. Say B5 = r and B12=3. i want column c to return only used cells in a row. for instance column c would read C1=r,C2=3.


    thanks for your help.

    Re: Sorting issue


    Quote from ByTheCringe2

    ....could you please explain


    COUNTIF(B$1:B$12,"*?")


    I can't see what that does at all.


    First, that part should be...


    COUNTIF(B$1:B$12,"?*")


    I had the question mark and asterisk reversed. :( This counts the number of text values, excluding formula blanks.

    Re: Sorting issue


    Quote from Domenic

    First, that part should be...


    COUNTIF(B$1:B$12,"?*")


    I had the question mark and asterisk reversed. :( This counts the number of text values, excluding formula blanks.


    Is this use of "?*" documented anywhere?

    Re: Sorting issue


    Why is it that it won't work when you just hit ENTER?

    [COLOR="Red"][SIZE="3"]Semper Fi[/SIZE][/COLOR] :rambo:


    [SIZE="1"]Why programmers get Holloween and Christmas mixed up: OCT31 = DEC25[/SIZE]

    Re: Sorting issue


    Quote from NathanC

    Why is it that it won't work when you just hit ENTER?


    That's because the formula is an 'array formula'. Have a look at Excel's help file under 'array formula' for a detailed explaination...

    Re: Sorting issue


    Quote from ByTheCringe2

    Domenic, In that case, how do you come to be using it??? Do you experiment full-time, or what? I am bewildered now...


    I learn from others. There are many experienced and talented people on these Boards and Newsgroups. Everyday I learn something new...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login