“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I'D LIKE TO CREATE A RULE WHEREBY
IF THE COLUMN B DESCRIPTION SAYS SOMETHING
THEN THE COLUMN E WILL AUTOMATICALLY PUT IN A SPECIFIC LETTER
SO IF COLUMN B SAYS JCREW I WANT COLUMN E TO INSERT THE LETTER 'C'
AND I'D LIKE TO DO THIS MULTIPLE TIMES WITH DIFFERENT DESCRIPTIONS AND HAVE DIFFERENT LETTERS CORRESPOND TO THOSE DESCRIPTIONS.
DOES THAT MAKE SENSE?

Solved by K. F. in 11 mins

I have a question about how i can solve the following problem using VBA.
I have a spreadsheet with a list of values in column A and B. On a different sheet i have two cells (for example D1 and E1) that I want to update with a button press, so that they first show the two values in A1 and B1, and after the button press it goes on to show the values in A2 and B2.

Solved by I. Y. in 20 mins

So I need to group a cluster of words to be removed from excel. I was doing search and replace individually and this took quite a time. Sometimes new words will be added so I'll have to have some formula or vba where i can modify it later.. But current words that need to be removed are
ebay , paypal, free , neutral, negative, feedback, free, phone, call, froo, auctiva,
and more words as i find new ones

Solved by K. Q. in 28 mins

I want to Copy a list (1.2.3.4.... eth) to every nth cell.

Solved by E. A. in 16 mins

detect comments in a row and colour correponding row in column A in yellow if comments exist

Solved by O. F. in 11 mins

I'd like to have a formula that will subtract or add to a date a certain amount of time. for example if date between 5/1/17 and 5/10/17 I'd like the formula to return the date of 4/20/17. If the date is between 5/11/17 and 5/20/17 I'd like it to return 5/1/17. Basically I'm trying to set up a schedule for when my employees need to take some action on a specific date depending on the action date.

Solved by I. E. in 30 mins

Negative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic scale.

Solved by D. H. in 13 mins

Hi I'm looking to create a spreadsheet for my boss- and I am sooo lost. I need to create different functions for the processing of accounts to calculate their total commission rate. Is there anyway you can walk me through how to create a functional spreadsheet?

Solved by D. Y. in 17 mins

Formula needed: Process Status G6-G355 to generate from Team Info G4-G353 after data entered, combining at a 25% rate Columns G-N. Not all columns will be required but distinguish if 1 of 4 options (H-K), the calculation 25% is met

Solved by C. H. in 25 mins

I'm trying to write an If statement that does the following: if the date in Column A falls in last month of a quarter, then take that date and add 30 days in Column B; if the date in Column A falls in the first or second month of the quarter, leave the original date in Column B.

Solved by I. J. in 12 mins