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

Online Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 2171
  • Total likes: 374
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1240 on: February 13, 2019, 08:42:12 PM »
Been trying to figure out a simple way to have a variable number (1-9) as part of an IF statement. Maybe someone here can help.

Text that Iím looking for the IF to match can be XYZ1, XYZ2, XYZ3 etc. There will always be an XYZ followed by 1-9 that I need it to pick up.
Currently I have it set to IF XYZ & cell reference (where I put in the 1-9 that it is), and the rest of my formulas work off that. I want to cut out the manually updating the cell reference each time I need my logic to populate.

Use case is in google sheets if that opens up more options.
Wouldn't REGEXEXTRACT do it? (I didn't really chap the exact use...maybe it is too late in the day...)

Offline lubaby

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5386
  • Total likes: 736
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Help and Problems
« Reply #1241 on: February 13, 2019, 08:50:31 PM »
IF(Left(A2,3)="XYZ",1,2)?
Forgot to mention, the XYZ # is in middle of a variable length and variable position of a string. The only absolute to work with is the XYZ #. Have it working now with a FIND XYZ & # from cell reference.

Wouldn't REGEXEXTRACT do it? (I didn't really chap the exact use...maybe it is too late in the day...)
I'm trying to cut off everything after the XYZ # (part of a larger data parsing project).

I'm not so familiar with REGEXEXTRACT. Will take a look.


ETA: REGEXEXTRACT worked perfectly. Thanks
"XYZ"&"[0-9]"
« Last Edit: February 13, 2019, 09:36:09 PM by lubaby »

Offline upside down

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Aug 2013
  • Posts: 548
  • Total likes: 3
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Help and Problems
« Reply #1242 on: May 06, 2019, 12:11:38 PM »
I have zero previous experience with excel and want to learn the basics (and eventually more than that). What are good websites or courses to use?
Thanks

Offline CreamofSoup

  • Dansdeals Gold Elite
  • ***
  • Join Date: May 2016
  • Posts: 237
  • Total likes: 13
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Baltimore
Re: Excel Help and Problems
« Reply #1243 on: May 06, 2019, 12:21:35 PM »
I'd use this: https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&rs=en-US&ad=US

And linkedin learning if you have access. Once you have a basic idea of what can be done, start throwing together spreadsheets? Do you have a household budget? Stick it in excel and then google anything you want to do that you didn't previously learn.

Online Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 2171
  • Total likes: 374
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1244 on: May 06, 2019, 06:46:10 PM »
I'd use this: https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&rs=en-US&ad=US

And linkedin learning if you have access. Once you have a basic idea of what can be done, start throwing together spreadsheets? Do you have a household budget? Stick it in excel and then google anything you want to do that you didn't previously learn.
First thing - for basics - go through the Excel 2019 Essential Training course from Lynda/LinkedIn Learning, it will give you a good start to know the program's basics well. Once you have that you can find a lot online on specifics.

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 #1245 on: May 09, 2019, 12:32:24 AM »
I have zero previous experience with excel and want to learn the basics (and eventually more than that). What are good websites or courses to use?
Thanks
Exceljet.net

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1791
  • Total likes: 480
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1246 on: May 09, 2019, 09:55:03 PM »
Is there any ready made template for inventory management?

Need something simple. Master item list, received, shipped stuff, and current inventory.
My Tapatalk notifications don't always work.

Offline thaber

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2008
  • Posts: 3920
  • Total likes: 468
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1247 on: May 09, 2019, 11:56:03 PM »
Is there any ready made template for inventory management?

Need something simple. Master item list, received, shipped stuff, and current inventory.
Might want to use a database program instead. I had a Microsoft access database custom designed for me by some guy in the Phillipines

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1791
  • Total likes: 480
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1248 on: May 10, 2019, 02:59:04 AM »
Might want to use a database program instead. I had a Microsoft access database custom designed for me by some guy in the Phillipines
How much did it cost you?
My Tapatalk notifications don't always work.

Offline Luvisrael

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Apr 2016
  • Posts: 2895
  • Total likes: 366
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1249 on: May 14, 2019, 07:13:46 PM »
Any way to send a mass email to multiple email addresses on Spreadsheet to outlook?

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13013
  • Total likes: 3484
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1250 on: May 14, 2019, 08:03:59 PM »
Any way to send a mass email to multiple email addresses on Spreadsheet to outlook?
I'm pretty sure you can do a mailmerge to email.

https://support.office.com/en-us/article/use-mail-merge-to-send-bulk-email-messages-0f123521-20ce-4aa8-8b62-ac211dedefa4
Workflowy. You won't know what you're missing until you try it.

Offline Luvisrael

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Apr 2016
  • Posts: 2895
  • Total likes: 366
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1251 on: May 14, 2019, 08:21:40 PM »
I'm pretty sure you can do a mailmerge to email.

https://support.office.com/en-us/article/use-mail-merge-to-send-bulk-email-messages-0f123521-20ce-4aa8-8b62-ac211dedefa4
ok thanx. is there a simpler way to do it (e.g.) cut and paste email addresses

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13013
  • Total likes: 3484
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1252 on: May 14, 2019, 08:24:29 PM »
ok thanx. is there a simpler way to do it (e.g.) cut and paste email addresses
If you want to send the same message to all of them in BCC, you should be able to select the whole column of addresses, copy, and then paste them into the BCC box of an email
Workflowy. You won't know what you're missing until you try it.

Offline Luvisrael

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Apr 2016
  • Posts: 2895
  • Total likes: 366
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1253 on: May 14, 2019, 08:32:31 PM »
If you want to send the same message to all of them in BCC, you should be able to select the whole column of addresses, copy, and then paste them into the BCC box of an email
thats what i am looking to do thanx!

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 546
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1254 on: May 17, 2019, 12:04:41 PM »
hi
i have a price list for a bunch of items

under them a subtotal

now i want to add 20% fee, but only to certain items
then another fee 5% to other items 

something like this;


food    20
drink    10
ice cream 10

subtotal  40

20% fee  ??     what if only want the fee to be added to drinks
10 % fee  ??                   to others

Total     this i can do

thanks for your help

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2634
  • Total likes: 53
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1255 on: May 20, 2019, 08:56:42 PM »
hi
i have a price list for a bunch of items

under them a subtotal

now i want to add 20% fee, but only to certain items
then another fee 5% to other items 

something like this;


food    20
drink    10
ice cream 10

subtotal  40

20% fee  ??     what if only want the fee to be added to drinks
10 % fee  ??                   to others

Total     this i can do

thanks for your help
Make some type of indicator in the next column. So for example next to the drinks you would enter A and next to the others you would enter B. Then after the subtotal use a sumif to add the A items and multiply that by 20%, then sumif the B items and multiply by 5%.

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 546
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1256 on: May 23, 2019, 05:38:00 PM »
Make some type of indicator in the next column. So for example next to the drinks you would enter A and next to the others you would enter B. Then after the subtotal use a sumif to add the A items and multiply that by 20%, then sumif the B items and multiply by 5%.

thanks

this is the formula i wrote
=SUMIF(I5:I34,4,D5:D34*x.2)

it works without the *x.2, but then it gives me the total of the 'foods'.

with the *x.2 I get an error message

how can get it to calculate only 20%



Offline lubaby

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5386
  • Total likes: 736
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Help and Problems
« Reply #1257 on: May 23, 2019, 05:51:06 PM »
thanks

this is the formula i wrote
=SUMIF(I5:I34,4,D5:D34*x.2)

it works without the *x.2, but then it gives me the total of the 'foods'.

with the *x.2 I get an error message

how can get it to calculate only 20%
*.2

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 546
  • Total likes: 20
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1258 on: May 23, 2019, 05:53:53 PM »

=SUMIF(I5:I34,4,D5:D34*.2)

doesnt allow me.

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2634
  • Total likes: 53
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1259 on: May 23, 2019, 06:08:07 PM »
=SUMIF(I5:I34,4,D5:D34*.2)

doesnt allow me.
The *.2 needs to be outside their parentheses