Excel Help and Problems

[skyguy918]

To get the row #s automatically, put this in cell A1 (or any column), and then copy down.

Code: [Select]

=ROW(A1)Then, select the column, do copy, and paste special - values.

or just type 1 and 2 in the first 2 rows, select them, then double click the fill handle (which is the corner of the selection box) and it'll fill the series down to the end of your data set.

[etech0]

or just type 1 and 2 in the first 2 rows, select them, then double click the fill handle (which is the corner of the selection box) and it'll fill the series down to the end of your data set.

True!

[churnbabychurn]

Make a column and label it 1,2,3 etc.
when you want to revert back to unsorted state sort by that new 1 2 3 column.

To get the row #s automatically, put this in cell A1 (or any column), and then copy down.

Code: [Select]

=ROW(A1)Then, select the column, do copy, and paste special - values.

or just type 1 and 2 in the first 2 rows, select them, then double click the fill handle (which is the corner of the selection box) and it'll fill the series down to the end of your data set.

True!

Thanks!


I wasted much time playing with mental formulas...

[etech0]

Thanks!


I wasted much time playing with mental formulas...

exercise for the brain

[churnbabychurn]

exercise for the brain

Nah, billed a client

[etech0]

Nah, billed a client

You get paid to exercise? COOL!

[Ephcc90]

Anybody know how I can pull data just from the subtotals? There are about 7000 rows and about 350 are totals. I just want the rows with the totals. How can I easily get that data? Is there a way to hide the other data and just highlight the ones I need?

[Dr Moose]

I hate cross posting, but I posted in the other excel thread. and apparently this is the active thread, so:

I need to create a goal chart, like this one here: http://www.exceldashboardtemplates.com/how-to-make-a-beer-mug-goal-chart-as-an-excel-dashboard-component/

does anyone know of an easier way to make it than the link I posted? or maybe someone else who explains it differently?

[WQ]

Anybody know how I can pull data just from the subtotals? There are about 7000 rows and about 350 are totals. I just want the rows with the totals. How can I easily get that data? Is there a way to hide the other data and just highlight the ones I need?

if using the subtotal function it should automatically hide the 6650 rows.
Are you using subtitle function or was it manually subtotalled?

[Ephcc90]

if using the subtotal function it should automatically hide the 6650 rows.
Are you using subtitle function or was it manually subtotalled?

It is hidden with the plus sign on the left side. However, I can't highlight them all because it includes the hidden rows...

[WQ]

It is hidden with the plus sign on the left side. However, I can't highlight them all because it includes the hidden rows...

easy, select "go to special" then "visible only"

[Ephcc90]

easy, select "go to special" then "visible only"

Thanks!!! 

[skyguy918]

I hate cross posting, but I posted in the other excel thread. and apparently this is the active thread, so:

What exactly are you trying to do? Specifically a goal chart with a nice customized graphic, like the beer mug? Or any functional progress chart would do?

[Dr Moose]

What exactly are you trying to do? Specifically a goal chart with a nice customized graphic, like the beer mug? Or any functional progress chart would do?

I originally wanted something nice like the beer mug, but it seems to difficult. so I'll settle for a regular functional progress chart

[WQ]

I hate cross posting, but I posted in the other excel thread. and apparently this is the active thread, so:

yeah, I rtm'd to merge these two threads ages ago...