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 118562 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 #1395 on: April 28, 2020, 05:29:17 PM »
I was able pass through all my mquery code through VBA so I can now run everything automatically, as well as run my code across multiple files, only import specific files instead of entire folders contents, etc etc.
Awesome. Happy to hear.

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1539
  • Total likes: 54
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1396 on: May 04, 2020, 05:41:52 PM »
If I have a name and every time that name appears I want a certain email address to to appear in the cell next to it. How do I do that?

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11017
  • Total likes: 1089
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1397 on: May 04, 2020, 06:17:21 PM »
If I have a name and every time that name appears I want a certain email address to to appear in the cell next to it. How do I do that?
Do you have a whole list of names and emails that you want to use to fill in a column somewhere else? If yes, VLOOKUP.
If you just want to do this for one name, an IF formula should work.
Workflowy. You won't know what you're missing until you try it.

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1539
  • Total likes: 54
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1398 on: June 16, 2020, 05:45:06 AM »
If I have a name and every time that name appears I want a certain email address to to appear in the cell next to it. How do I do that?
Thanks Vlookup worked for me!

Offline Der Deutsche Jude

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Jan 2016
  • Posts: 851
  • Total likes: 22
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
  • Location: Brooklyn, NY
  • Programs: AA, CA, FAA, GA, NA, OA, WA
Re: Excel Help and Problems
« Reply #1399 on: June 16, 2020, 07:15:41 AM »
Thanks Vlookup worked for me!
Did it take you a month to figure out what the fourth criteria was?  ;)

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1539
  • Total likes: 54
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1400 on: June 18, 2020, 02:52:20 AM »
How do calculate a percentage.
Example if I know an airline ticket for 4 passenger  ( 2 adt, 1 child, 1 inf) cost $5000 and now I want to divide the adt by 35%, the child by 20% and the inf 10%. What would be the formula in Excel?

Online lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4729
  • Total likes: 320
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Help and Problems
« Reply #1401 on: June 18, 2020, 08:49:06 AM »
How do calculate a percentage.
Example if I know an airline ticket for 4 passenger  ( 2 adt, 1 child, 1 inf) cost $5000 and now I want to divide the adt by 35%, the child by 20% and the inf 10%. What would be the formula in Excel?
Multiply (*) by percent of 1, not divide (/).

=5000*0.35
(*0.2, *0.1 for the others)

If you have the 5000 in a cell, you can reference the cell instead of inputting the number =A1*0.35 ).
« Last Edit: June 18, 2020, 08:52:31 AM by lubaby »
Once the game is over, the king and the pawn go back in the same box.

Offline cgr

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2017
  • Posts: 1606
  • Total likes: 259
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1402 on: June 18, 2020, 10:06:15 AM »
Multiply (*) by percent of 1, not divide (/).

=5000*0.35
(*0.2, *0.1 for the others)

If you have the 5000 in a cell, you can reference the cell instead of inputting the number =A1*0.35 ).
Or =5000*35% if optics matter.

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1539
  • Total likes: 54
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1403 on: June 18, 2020, 10:15:46 AM »
Ok but how would get Excel to multiply 35% twice, 20 % once & 10% from the same number and list there values separably?

Offline cgr

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2017
  • Posts: 1606
  • Total likes: 259
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1404 on: June 18, 2020, 10:27:44 AM »
Ok but how would get Excel to multiply 35% twice, 20 % once & 10% from the same number and list there values separably?

In cell A1 enter 5000
In cell A2 enter =A1*35%
In cell A3 enter =A1*35%
In cell A4 enter =A1*20%
and so on.

If you need this on a regular basis for different ticket prices, but the Adult, Child, and Infant % stays the same I'd go with a Lookup or Vlookup table.

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1539
  • Total likes: 54
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1405 on: June 18, 2020, 11:00:03 AM »
In cell A1 enter 5000
In cell A2 enter =A1*35%
In cell A3 enter =A1*35%
In cell A4 enter =A1*20%
and so on.

If you need this on a regular basis for different ticket prices, but the Adult, Child, and Infant % stays the same I'd go with a Lookup or Vlookup table.
Once I figure everything Excel can do, 
I am actually thinking of creating a customized program with all the travel related calculations I need. 
« Last Edit: June 18, 2020, 11:03:23 AM by jose34 »

Offline cgr

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2017
  • Posts: 1606
  • Total likes: 259
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1406 on: June 18, 2020, 11:13:00 AM »
Once I figure everything Excel can do, 
I am actually thinking of creating a customized program with all the travel related calculations I need.

If you need someone to do it for you, feel free to reach out to me. I do VBA automation (along with simpler functions and formulas), as a side gig when I have too much time on my hands ::)

Offline justaregularguy

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Sep 2014
  • Posts: 754
  • Total likes: 153
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: not brooklyn
Re: Excel Help and Problems
« Reply #1407 on: June 24, 2020, 12:39:01 AM »
If you need someone to do it for you, feel free to reach out to me. I do VBA automation (along with simpler functions and formulas), as a side gig when I have too much time on my hands ::)
can you recommend a good class that teaches vba (not just watch YouTube videos etc.) ? I took Kyle pew’s class on udemy.com but the vba was less focused on vs the reg excel course.
nothings impossible- the word itself says Im possible

Offline cgr

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2017
  • Posts: 1606
  • Total likes: 259
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1408 on: June 24, 2020, 10:07:25 AM »
can you recommend a good class that teaches vba (not just watch YouTube videos etc.) ? I took Kyle pew’s class on udemy.com but the vba was less focused on vs the reg excel course.

I'm self-taught but I know there are a few VBA for Dummies books out there if that's your style.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11017
  • Total likes: 1089
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1409 on: June 24, 2020, 10:09:04 AM »
I'm self-taught but I know there are a few VBA for Dummies books out there if that's your style.
+1
Also - many years ago I took some courses from http://599cd.com/. It seems like they have VBA courses now. I don't know if they are current but if they are they are probably a good thing to try.
Workflowy. You won't know what you're missing until you try it.