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

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 17404
  • Total likes: 14342
  • DansDeals.com Hat Tips 14
    • 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.
Feelings don't care about your facts

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6738
  • Total likes: 1097
  • 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!

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12863
  • Total likes: 3321
  • 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 20K Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 23544
  • Total likes: 2427
  • DansDeals.com Hat Tips 356
  • 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?
Quote
Need your LG Exalt fixed? Cracked in half? Water damage? Or parts to repair yourself. 347.201.2501

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: 3810
  • Total likes: 826
  • 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 20K Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 23544
  • Total likes: 2427
  • DansDeals.com Hat Tips 356
  • 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.
Quote
Need your LG Exalt fixed? Cracked in half? Water damage? Or parts to repair yourself. 347.201.2501

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 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 20K Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 23544
  • Total likes: 2427
  • DansDeals.com Hat Tips 356
  • 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.
Quote
Need your LG Exalt fixed? Cracked in half? Water damage? Or parts to repair yourself. 347.201.2501

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12863
  • Total likes: 3321
  • 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: 3810
  • Total likes: 826
  • 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: 2397
  • Total likes: 154
  • DansDeals.com Hat Tips 2
    • 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: 7355
  • Total likes: 301
  • 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: 2623
  • Total likes: 52
  • 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: 1306
  • Total likes: 5
  • 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

Offline 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 Help and Problems
« Reply #1215 on: January 15, 2019, 04:36:10 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
What is the structure of these loans? Are you talking about a mortgage style loan? And if so, what is the term? Or maybe an indefinite loan term where they're paying monthly interest only payments?

ETA: Any type can be calculated pretty easily, in excel or otherwise. But it would be hard to give a specific answer without more info.
« Last Edit: January 15, 2019, 05:06:31 PM by skyguy918 »

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2623
  • Total likes: 52
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1216 on: January 15, 2019, 08:30:41 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
If I'm understanding you correctly, the math is overhead times 12 divided by the interest rate.
So 20k x12 is 240k, divided by 7% is 3,428,571 in loans needed.

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 Help and Problems
« Reply #1217 on: January 16, 2019, 09:29:17 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
Are you a bank?

You need a business plan..

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1306
  • Total likes: 5
  • 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 #1218 on: January 20, 2019, 02:56:55 PM »
Are you a bank?

You need a business plan..

Can you help if I want to create a personal "bank" type - owner funded
you can only make a first impression ONCE

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1306
  • Total likes: 5
  • 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 #1219 on: January 20, 2019, 02:57:58 PM »
What is the structure of these loans? Are you talking about a mortgage style loan? And if so, what is the term? Or maybe an indefinite loan term where they're paying monthly interest only payments?

ETA: Any type can be calculated pretty easily, in excel or otherwise. But it would be hard to give a specific answer without more info.

im looking at a 5 year loan, would love to discuss. pm?
you can only make a first impression ONCE