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.

• Re: Sorting issue

Have a look at the attached file and see if this is what you're looking for...

Hope this helps!

Files

• Re: Sorting issue

Domenic, I don't know how you do it! At least could you please explain

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

I can't see what that does at all.

• Re: Sorting issue

Quote from ByTheCringe2

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 ByTheCringe2

Is this use of "?*" documented anywhere?

Not to my knowledge...

• 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 Domenic

Not to my knowledge...

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

• 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...

• Re: Sorting issue

Quote from ByTheCringe2

So they must experiment full-time, LOL. Thanks.

Maybe, who knows...?

Participate now!

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