Topic Wiki

Rule 1: Did you try A.I? Right before you click post, give it a quick run. Most excel questions can be answered very quickly, thoroughly, and clearly via chatgpt. Wrong answer, or having trouble with the correct wording of the prompt? Post for help

=================
For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by Jojo202 on March 01, 2024, 12:09:44 AM »

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

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2181
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #220 on: September 18, 2014, 06:05:16 PM »
Don't want this to come across as if I think excel is simple or easy to learn. Where can I learn basic excel either online or perhaps a good book etc. I use it a bit for simple stuff and I think know I am not taking advantage of what it has to offer properly.

Thank you
http://excelexposure.com/lesson-guide/
For tech help feel free to Telegram me @DanTechSupp

Offline Fan of Dan

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2011
  • Posts: 3029
  • Total likes: 8
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #221 on: September 18, 2014, 07:20:17 PM »

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #222 on: November 12, 2014, 02:49:23 PM »
I have a table to unsorted data. Is there a way to sort it alphabetically, then change some values, and then revert it back to its unsorted state?

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3761
  • Total likes: 70
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #223 on: November 12, 2014, 02:52:32 PM »
I have a table to unsorted data. Is there a way to sort it alphabetically, then change some values, and then revert it back to its unsorted state?
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.

Online etech0

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

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3810
  • Total likes: 826
  • 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.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12861
  • Total likes: 3316
  • 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: 7355
  • Total likes: 301
  • 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...:-[

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12861
  • Total likes: 3316
  • 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: 7355
  • Total likes: 301
  • 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 ;)

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12861
  • Total likes: 3316
  • 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: 565
  • Total likes: 20
  • 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: 4195
  • Total likes: 180
  • DansDeals.com Hat Tips 3
    • 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: 565
  • Total likes: 20
  • 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: 565
  • Total likes: 20
  • 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!!! 

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3810
  • Total likes: 826
  • 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: 4195
  • Total likes: 180
  • DansDeals.com Hat Tips 3
    • 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...