Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 80658 times)

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2750
  • Total likes: 126
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #225 on: November 12, 2014, 03:08:18 PM »
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.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9264
  • Total likes: 284
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #226 on: November 12, 2014, 03:09:26 PM »
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!
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7114
  • Total likes: 253
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #227 on: November 12, 2014, 05:11:13 PM »
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...:-[

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9264
  • Total likes: 284
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #228 on: November 12, 2014, 08:28:52 PM »


Thanks! :)


I wasted much time playing with mental formulas...:-[
exercise for the brain :)
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7114
  • Total likes: 253
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #229 on: November 12, 2014, 09:41:20 PM »
exercise for the brain :)
Nah, billed a client ;)

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9264
  • Total likes: 284
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #230 on: November 12, 2014, 11:14:42 PM »
Nah, billed a client ;)
You get paid to exercise? COOL!
Workflowy. You won't know what you're missing until you try it.

Offline Ephcc90

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 505
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Far Rockaway
Re: Excel Problem
« Reply #231 on: November 18, 2014, 07:43:53 PM »
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?

Offline Dr Moose

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Nov 2013
  • Posts: 3958
  • Total likes: 85
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #232 on: November 18, 2014, 08:11:49 PM »
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?

Hey there! I am using DansDeals Forums.

Offline WQ

  • DansDeals Copper Elite
  • *
  • Join Date: Nov 2014
  • Posts: 11
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #233 on: November 18, 2014, 08:12:42 PM »
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?

Offline Ephcc90

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 505
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Far Rockaway
Re: Excel Problem
« Reply #234 on: November 18, 2014, 08:14:34 PM »
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...

Offline WQ

  • DansDeals Copper Elite
  • *
  • Join Date: Nov 2014
  • Posts: 11
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #235 on: November 18, 2014, 08:19:58 PM »
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"

Offline Ephcc90

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 505
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Far Rockaway
Re: Excel Problem
« Reply #236 on: November 18, 2014, 08:28:09 PM »
easy, select "go to special" then "visible only"
Thanks!!! 

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2750
  • Total likes: 126
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #237 on: November 19, 2014, 10:03:54 AM »
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?

Offline Dr Moose

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Nov 2013
  • Posts: 3958
  • Total likes: 85
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #238 on: November 19, 2014, 10:05:13 AM »


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
Hey there! I am using DansDeals Forums.

Offline WQ

  • DansDeals Copper Elite
  • *
  • Join Date: Nov 2014
  • Posts: 11
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #239 on: November 19, 2014, 10:10:59 AM »
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...