Search results

Hi Bob, :DD Its very confusing. Would you have an excel file already has all the items I had listed. This I can work on it backwards and change the coding. Thank you for your time , Jenn :awesome::)

Hi Everyone :):) I'm very confused. I'm looking to send an email using VBA. How can do all the below steps using VBA please. Paste from Excel into email body Paste subject line from excel paste email from excel attached file from directory Thank you Jenn ;);)

Thank you John and Grah. this is perfect.

@JohnJairoV @GraH-Guido is it possible to change the formula so it won't go over 90 days?

Thank you, both Gran and John.

Hi @JohnJairoV You are the best!!!!!!!!!! Thank you.

Hi!. My excel file has a unique name in Column A. Column D has the number of days. How can I write a formula in column E to give me the closest number to 90 depending on what is in column A. I would like the formula to say True for the closest number to 90 depending on what is in column A...

Hi, Im soooo stuck on this excel formula. I would like to place a formula in Column C doing the below conditions. A combined formula for the 2 conditions. IF A is not 0 or "Blank" Return cell in A or IF A is 0 or "Blank" return cell in B Thank you. Jenn:)

Hi Bosco, What if I added another column. for example, if A is N or D is blank. Don't concate that row.

This is great Bosco. Thank you.

Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N". For example, Below I would like to skip row 4 and 5 because column A has "N". (Highlighted in yellow) Thanks, Jenny

Hi S DAS, im consufed. im currently using a pc. Are these instructions for a mac?

thank you.

its screws up all my excel files that I have open that are from a excel pc.

i tried everything in the ink but still didn't work.

Hi S Das, My system Mode is Latitude 7480 and system type is x64 based pc.

Hi S Das, My system Mode is Latitude 7480 and system type is x64 based pc.

Hi!! Im Jenn. I received an Excel file from a Mac user and every time I open the file on my pc it's very slow calculating formulas. The file only has 100 rows. In the right bottom corner, it says 4 processors and the percent complete.It takes 30 minutes to reach 100%. I tried everything. Even...

thank you. you are so smart.

Hi Nebu, what if I wanted to say instead of Inserting the word rain I would like to insert the word "best". for Storm, I would like to insert the word "better". I have the screen shot below and added it also to the excel file.

Thank you Nebu. you are the best.

Hi AliG, Both formulas are doing the same thing. But this is not what im trying to do. Please the image below of what im trying to do. Im trying to write a formula that will look in Column C for certain words. For example, If column C has the work Kick. Have the word kick in Column A. or If...

Hi Everyone, I am so stuck. Im trying to write a formula that will look in Column C for certain words. For example, If column C has the work Kick. Have the word kick in Column A. or If Column C has the word rain, Have the word rain in Column A. or If Column C has the word storm, Have the word...

Hi Everyone, I have Excel 2013 and im missing PowerPivot. I tried looking at the Ribbon. I also search in all the add ons. I also tried to install it. I tried everything. Please let me know what I should do? Thank you so much Jenn:)

Hi I have 16 rams of memory. Chrome is close. I have a solid state drive. I keep getting this error when I refresh my pivot table. i tried everything. excel cannot complete this task with available resources choose less data or close other application.