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

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12110
  • Total likes: 2164
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1460 on: March 10, 2021, 08:14:03 PM »
GIYF, my friend.
Quote
Lambda is the 11th letter of the Greek alphabet, representing the sound /l/.
Workflowy. You won't know what you're missing until you try it.

Online Yo ssi

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2019
  • Posts: 3891
  • Total likes: 1230
  • DansDeals.com Hat Tips 38
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1461 on: March 10, 2021, 08:15:23 PM »

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5063
  • Total likes: 19
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Excel Help and Problems
« Reply #1462 on: March 10, 2021, 11:31:20 PM »
what the heck is that ? Does it come w office 365?

As an aside does anyone know what LAMBDA is?
Yes. Basically you can use LAMBDA to create a reusable custom formula written with standard excel formulas (not vba)

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12697
  • Total likes: 7377
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12110
  • Total likes: 2164
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Workflowy. You won't know what you're missing until you try it.

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3308
  • Total likes: 519
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1465 on: March 11, 2021, 01:08:49 PM »
looks like it's not available in Office 2019
More specifically:
Quote
Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12110
  • Total likes: 2164
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1466 on: March 11, 2021, 01:14:34 PM »
Workflowy. You won't know what you're missing until you try it.

Offline justaregularguy

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Sep 2014
  • Posts: 1031
  • Total likes: 440
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: not brooklyn
Re: Excel Help and Problems
« Reply #1467 on: March 12, 2021, 12:57:17 AM »
Check out the new xlookup. Takes care of all the issues with vlookup and much more straightforward than index match
thanks for this! This helps a lot!
nothings impossible- the word itself says Im possible

Offline Am

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Nov 2011
  • Posts: 960
  • Total likes: 2
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Help and Problems
« Reply #1468 on: March 18, 2021, 10:26:21 AM »
I have a column with a a thousand numbers. I need to increase all of them by 15%. Without doing it manually, how do increase all the cells in that column by 15% all at once?

Offline cgr

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2017
  • Posts: 3244
  • Total likes: 747
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1469 on: March 18, 2021, 10:28:44 AM »
I have a column with a a thousand numbers. I need to increase all of them by 15%. Without doing it manually, how do increase all the cells in that column by 15% all at once?
Type .15 into any cell, and do ctrl+c.
Then, select the data you want to multiply, right click, do paste special, and select multiply.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12110
  • Total likes: 2164
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1470 on: March 18, 2021, 10:29:24 AM »
Type .15 into any cell, and do ctrl+c.
Then, select the data you want to multiply, right click, do paste special, and select multiply.
might want 1.15 in that cell
Workflowy. You won't know what you're missing until you try it.

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 25551
  • Total likes: 2976
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: Excel Help and Problems
« Reply #1471 on: March 18, 2021, 11:31:03 AM »
Type .15 into any cell, and do ctrl+c.
Then, select the data you want to multiply, right click, do paste special, and select multiply.

I do it the long and ignorant way:
- add column
- =[cell from previous column] * 1.15
- auto fill the formula above to all rows
- copy the added column
- Paste special the added column over the original one, pasting values
- Delete the added column

Cool shortcut to do it simpler, thanks!

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12110
  • Total likes: 2164
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1472 on: March 18, 2021, 11:32:55 AM »
I do it the long and ignorant way:
- add column
- =[cell from previous column] * 1.15
- auto fill the formula above to all rows
- copy the added column
- Paste special the added column over the original one, pasting values
- Delete the added column

Cool shortcut to do it simpler, thanks!
+1
Workflowy. You won't know what you're missing until you try it.

Online Yo ssi

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2019
  • Posts: 3891
  • Total likes: 1230
  • DansDeals.com Hat Tips 38
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1473 on: March 18, 2021, 05:02:45 PM »
I do it the long and ignorant way:
- add column
- =[cell from previous column] * 1.15
- auto fill the formula above to all rows
- copy the added column
- Paste special the added column over the original one, pasting values
- Delete the added column

Cool shortcut to do it simpler, thanks!
I was going to say to use a script 😜

Offline Lurker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2019
  • Posts: 4466
  • Total likes: 4860
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: As always, silence is NOT an admission of agreement on DDF. It just means that people lack the stamina to keep on arguing with made up "facts", illogical arguments, deceiving statements, nasty and degrading comments, and fuzzy math. - @yelped
Re: Excel Help and Problems
« Reply #1474 on: June 16, 2021, 11:04:19 AM »
I had a multi-tab workbook I was working on. Hit save religiously. I moved it from a folder to my desktop, and now only the last sheet is there. How do I get the other sheets back?

ETA: Google tells me I can't save multiple sheets in a csv file, which would explain why the other sheets are gone. Is there any way to get them back, or am I wasting my time?
« Last Edit: June 16, 2021, 11:11:51 AM by Lurker »
Failing at maintaining Lurker status.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12697
  • Total likes: 7377
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1475 on: June 16, 2021, 11:48:24 AM »
I had a multi-tab workbook I was working on. Hit save religiously. I moved it from a folder to my desktop, and now only the last sheet is there. How do I get the other sheets back?

ETA: Google tells me I can't save multiple sheets in a csv file, which would explain why the other sheets are gone. Is there any way to get them back, or am I wasting my time?
If it is in onedrive you may have "previous versions"
Feelings don't care about your facts

Offline Lurker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2019
  • Posts: 4466
  • Total likes: 4860
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: As always, silence is NOT an admission of agreement on DDF. It just means that people lack the stamina to keep on arguing with made up "facts", illogical arguments, deceiving statements, nasty and degrading comments, and fuzzy math. - @yelped
Re: Excel Help and Problems
« Reply #1476 on: June 16, 2021, 12:23:26 PM »
If it is in onedrive you may have "previous versions"

Unfortunately, it wasn't. Google says I'm out of luck. Just gotta keep on saying gam zu l'tovah....
Failing at maintaining Lurker status.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12110
  • Total likes: 2164
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1477 on: June 16, 2021, 12:25:07 PM »
Unfortunately, it wasn't. Google says I'm out of luck. Just gotta keep on saying gam zu l'tovah....
Did you check the original folder in case the other sheets got left behind somehow?
Workflowy. You won't know what you're missing until you try it.

Offline Lurker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2019
  • Posts: 4466
  • Total likes: 4860
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: As always, silence is NOT an admission of agreement on DDF. It just means that people lack the stamina to keep on arguing with made up "facts", illogical arguments, deceiving statements, nasty and degrading comments, and fuzzy math. - @yelped
Re: Excel Help and Problems
« Reply #1478 on: June 16, 2021, 12:39:05 PM »
Did you check the original folder in case the other sheets got left behind somehow?

Yea... I just dragged it from Downloads to the desktop. Poof.
Failing at maintaining Lurker status.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12110
  • Total likes: 2164
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1479 on: June 16, 2021, 12:40:17 PM »
Yea... I just dragged it from Downloads to the desktop. Poof.
ouch
Workflowy. You won't know what you're missing until you try it.