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

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2645
  • Total likes: 48
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1305 on: September 15, 2019, 12:54:29 PM »
That's why I'm using find format from cell, shouldn't it match it exactly?
You copied it from another file, so how do you know that the color you are selecting on the find/replace is the same color as on the sheet. Maybe the sheet is a custom color etc.

Offline Therebbesbocher

  • Dansdeals Silver Elite
  • **
  • Join Date: Jun 2017
  • Posts: 62
  • Total likes: 5
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1306 on: September 15, 2019, 02:40:58 PM »
I think i got it, thanks for the help
Arguing on DDF is like getting arrested, everything you say can and will be used against you, so just remain silent!!

Online CountValentine

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2013
  • Posts: 8585
  • Total likes: 1886
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Re: Excel Help and Problems
« Reply #1307 on: September 15, 2019, 08:27:25 PM »
I have 12345 in the first cell. I want every cell under it to increment 1 each time. Easiest way to do it? I need thousands.
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11149
  • Total likes: 1212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1308 on: September 15, 2019, 08:31:25 PM »
Select A1. Click the Home tab, click Fill, click Series. Select Series In: Columns. Keep the Step Value at 1 and set the Stop Value to the number that you want to end with. Click OK.

Workflowy. You won't know what you're missing until you try it.

Online CountValentine

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2013
  • Posts: 8585
  • Total likes: 1886
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Re: Excel Help and Problems
« Reply #1309 on: September 15, 2019, 08:37:37 PM »
Love the spoon feed instructions but it is not doing anything.
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2645
  • Total likes: 48
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1310 on: September 15, 2019, 08:46:14 PM »
I have 12345 in the first cell. I want every cell under it to increment 1 each time. Easiest way to do it? I need thousands.
If the first cell is A1, then B1 would be =A1+1. Then select B1 and you'll see a tiny box in the bottom right of the cell. Drag that down as far as you want.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11149
  • Total likes: 1212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1311 on: September 15, 2019, 08:53:55 PM »
Love the spoon feed instructions but it is not doing anything.
make sure you got every step?
Workflowy. You won't know what you're missing until you try it.

Online CountValentine

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2013
  • Posts: 8585
  • Total likes: 1886
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Re: Excel Help and Problems
« Reply #1312 on: September 15, 2019, 09:00:02 PM »
If the first cell is A1, then B1 would be =A1+1. Then select B1 and you'll see a tiny box in the bottom right of the cell. Drag that down as far as you want.
That works. I am going down not across but works the same?
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11149
  • Total likes: 1212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1313 on: September 15, 2019, 09:01:13 PM »
That works. I am going down not across but works the same?
Choose either 'rows' or 'columns' until you get the result you want. Otherwise if you select just that column it should work either way.
Workflowy. You won't know what you're missing until you try it.

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2645
  • Total likes: 48
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1314 on: September 15, 2019, 09:01:35 PM »
That works. I am going down not across but works the same?
Works both ways but to go down the cell with the formula would be A2 and you would write =A1+1

Online CountValentine

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2013
  • Posts: 8585
  • Total likes: 1886
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Re: Excel Help and Problems
« Reply #1315 on: September 15, 2019, 09:04:48 PM »
make sure you got every step?
I select A1. It contains 12345
Home
Fill
Series
Columns
Enter Stop value: 100
OK
Did I miss anything?
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11149
  • Total likes: 1212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1316 on: September 15, 2019, 09:07:32 PM »
The Stop Value needs to be the max value you want. So if you want 100 numbers, your stop value is 12445.

Over here it's not running at all since the stop value is lower than your start value.

(I made this same mistake a few times)
Workflowy. You won't know what you're missing until you try it.

Online CountValentine

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2013
  • Posts: 8585
  • Total likes: 1886
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Re: Excel Help and Problems
« Reply #1317 on: September 15, 2019, 09:09:23 PM »
Thank you both. Works like a charm!!!
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11149
  • Total likes: 1212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1318 on: September 15, 2019, 09:10:31 PM »
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: 7247
  • Total likes: 282
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1319 on: October 08, 2019, 07:43:11 AM »
For a series of even 20 cash flows from a non compounding loan payments (p&I)every two weeks, xirr is giving very different results then IRR*20

Is xirr giving the effective yield which is incorrect here because it's simple interest?