I have an open window on my desktop that I need to make a snapshot of and put in an excel worksheet. I did this by accident once and I can't duplicate it.

Experts: I can't figure this out... I need to add another array to this formula. =SUMPRODUCT(--(A3:A236="John...

Hi everyone, I'm using the following sumproduct formula =SUMPRODUCT(--(NoPass="W"),--(NoPass="N"),--(NoPass="D")) where NoPass is a named dynamic range in...

I need to add a new column based on an existing column of data. The existing data is in the format below: ID67 ID6802 ID6802 ID61 IA91 IA92

Hello, How can I add a date and name to update in a cell? Currently I have =NOW() within the same cell I want to add a name (probably from a list).

I am trying to add a prompt for a date to make my external data pull from a certain date only does anybody know how to do this. I am pulling from a SQL...

I need to know if there is a simple formula to add the current (static) date into the adjacent cell by entering a specific # into another cell. Example: by...

How do you add a date into an Excel calender and have it automatically generate a later date in the calender year automatically.

Is there a way to have excel add the date that some data was entered inton a row. I was wanting it to go at the end of the info that has been entered....

Hi I would like to add a drop down list for the all the names of CDs that i have. Does anyone know how to do this? Thanks in advance.

Hello! Can anyone tell me how to add a drop down list to a specific column? I need to have only two options in the list, and the people using the...

How or can I add a drop down list to an if statement. I have added all 50 states to cell A1 as a drop down choice. I want the statement to be if cell A1...

Hi, I want to add the actual date in cell A1 when B1 is populated for the first time, A2 when B2 etc... I have tried the formula =today(), but the result is...

using the formula, =CONCATENATE("Text = ",58.5," + ",F33,) everything is perfect except the F33 cell is reading with many decimal points. i have formatted...

I am trying to create an invoice so when I put qty in cell A1 and the $ value in cell B1, cell C1 has formula =B1*A1, thats fine, but having that...

I am using the following formula: =VLOOKUP(ROW()-1,Formulas!$D$2:$BK$501,51,FALSE) I'm trying to figure out a way to not hardcode the column letters and...

I am trying to add a function to a cell that would be in a new line that I am adding from a macro. See My macro (below). The marco is connected to a button in...

I want to add a red frown face (as a picture or ClipArt) if a value is less than x, yellow no-smile-or-frown if greater than x but less than y, and green...

Hi I have a series of numbers in column A. I need to add the letter B to the beginning of each. Can someone suggest some code to achieve this? Grateful...

If I add a new sheet that is formatted just like the other sheets in the workbook will my totals formula add the new sheet?