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 94538 times)

Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 7088
  • Total likes: 1670
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1200 on: September 12, 2018, 11:54:16 AM »
How do I copy a sheet (tab on the bottom) from one file to another?
Open the file you want to copy it to, Right click on the tab you want to copy and click move or copy. To copy make sure to check that option otherwise it will move.
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6669
  • Total likes: 1059
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Excel Help and Problems
« Reply #1201 on: September 12, 2018, 12:05:00 PM »
OK, need both files open.  :-[
I just found a new supply of forks!

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9452
  • Total likes: 332
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1202 on: September 12, 2018, 12:11:06 PM »
Workflowy. You won't know what you're missing until you try it.

Offline myi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Feb 2015
  • Posts: 16731
  • Total likes: 1056
  • DansDeals.com Hat Tips 285
  • Gender: Male
    • View Profile
  • Location: InMyPants! 🙈
  • Programs: 2Many2List!
Re: Excel Help and Problems
« Reply #1203 on: October 11, 2018, 02:16:01 AM »
Is there any way to split one cell in two, meaning a line in the middle?
Aside for putting a shape or drawing with art.
Any standard button to split one cell?
Don't try to be someone else , be who you are because everyone else is taken.

Offline Zubda

  • DansDeals Copper Elite
  • *
  • Join Date: Apr 2018
  • Posts: 19
  • Total likes: 4
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1204 on: October 11, 2018, 07:49:30 AM »
Merge the cells above and below it

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2810
  • Total likes: 153
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1205 on: October 11, 2018, 10:43:42 AM »


Is there any way to split one cell in two, meaning a line in the middle?
Aside for putting a shape or drawing with art.
Any standard button to split one cell?

You just want the line to show up, or you want to be able to split the cell for all purposes?

Offline myi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Feb 2015
  • Posts: 16731
  • Total likes: 1056
  • DansDeals.com Hat Tips 285
  • Gender: Male
    • View Profile
  • Location: InMyPants! 🙈
  • Programs: 2Many2List!
Re: Excel Help and Problems
« Reply #1206 on: October 12, 2018, 03:20:17 PM »

You just want the line to show up, or you want to be able to split the cell for all purposes?
Just a line, nothing to do with the text, as a graph want another line in-between.
Don't try to be someone else , be who you are because everyone else is taken.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7185
  • Total likes: 272
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1207 on: October 12, 2018, 05:26:31 PM »
Just a line, nothing to do with the text, as a graph want another line in-between.
Do a left border

Offline myi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Feb 2015
  • Posts: 16731
  • Total likes: 1056
  • DansDeals.com Hat Tips 285
  • Gender: Male
    • View Profile
  • Location: InMyPants! 🙈
  • Programs: 2Many2List!
Re: Excel Help and Problems
« Reply #1208 on: October 12, 2018, 05:29:27 PM »
Do a left border
Will try after and report back. Thanks.
Don't try to be someone else , be who you are because everyone else is taken.

Online etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9452
  • Total likes: 332
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1209 on: October 15, 2018, 04:57:33 PM »
You should be able to do a middle "border" too, if that's what you need
Workflowy. You won't know what you're missing until you try it.

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2810
  • Total likes: 153
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1210 on: October 17, 2018, 04:15:15 PM »
Came across something interesting that I had never used before, thought it might be interesting to some here.

My brother asked for help with a data set. There are 50 columns representing the last 50 years. For each row, there may be data in each row for some, all, or none of the 50 years. What's more, the data is not necessarily continuous (ie it can skip years). The ask was to do conditional formatting on the data set to color each row based on the number of years that have data - easy enough. But a secondary goal was to format based on the largest number of years with continuous data in each row. I ended up coming up with various relatively messy solutions, but my brother-in-law found this, which worked beautifully:

https://exceljet.net/formula/count-consecutive-monthly-orders
Code: [Select]
{=MAX(FREQUENCY(IF(rng>0,COLUMN(rng)),IF(rng=0,COLUMN(rng))))}
Gorgeous bit of code, using the FREQUENCY function, which I had never used before.

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1243
  • Total likes: 32
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1211 on: November 10, 2018, 04:39:01 PM »
Can anyone recommend a quality free course that teaches how to do basic accounting using Excel?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7185
  • Total likes: 272
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1212 on: November 10, 2018, 09:11:42 PM »
Can anyone recommend a quality free course that teaches how to do basic accounting using Excel?
Like running a gl ? Try you tube.. it's not conventional

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2592
  • Total likes: 29
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1213 on: November 11, 2018, 10:08:26 AM »
Can anyone recommend a quality free course that teaches how to do basic accounting using Excel?
The excelisfun YouTube channel should have an accounting playlist, but it's focused more on Excel than accounting.

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1312
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Help and Problems
« Reply #1214 on: January 15, 2019, 12:30:36 PM »
I can use help figuring out how much money in mortgage loans we need to cover our overhead.
how many months and how many dollars needed to cover ourselves

when will the payments be able to match the loans we give out to be self sustained

i.e. if we give out 1m in loans @7%  we would only make x per year /12 is y per month
if our overhead is 20k a month - how many loans need to be out etc.

willing to pay - feel free to dm


you can only make a first impression ONCE