M
MikeB
Thanks for the answers on my previous question. I ended up not using
them (those formulas are far too complex for a dabbler like me). I
created two columns to find the origin of either "http://" or "http://
www." (always "1" if found), multiplied that by either 7 or 11 to get
the starting position and then had a columsn for Max() of the previous
two columns. Then I did another column to find the trailing "/" and
then a Mid() with the values obtained in the preceding columns.
Not I have the domain names, and I can sort the table to get
Subtotals. What I'd like to do is to again sort the table after I have
subtotals, so I can get the domain with the higest count at the top of
the list.
How do I do this?
Thanks
them (those formulas are far too complex for a dabbler like me). I
created two columns to find the origin of either "http://" or "http://
www." (always "1" if found), multiplied that by either 7 or 11 to get
the starting position and then had a columsn for Max() of the previous
two columns. Then I did another column to find the trailing "/" and
then a Mid() with the values obtained in the preceding columns.
Not I have the domain names, and I can sort the table to get
Subtotals. What I'd like to do is to again sort the table after I have
subtotals, so I can get the domain with the higest count at the top of
the list.
How do I do this?
Thanks