I need to enter a text in A1 if i enter text in B1. In other words, if I enter any text in B2 I want A1 to display "OPEN" Thank you for your help.

Even by puttting the simplest = in the destination workbook cell then tabbing over to the source workbook, i can not create the link. When in the source...

I'm looking to send out a mass email to separate individuals. This email will include: cover sheet, sheet with Excel row of data per client I have all my...

Can someone explain to me why when i got to save a worksheet/workbook that is say this format is not compatable and some data will be lost. My options are...

I have a sheet with rows of data. I have named ranges for different rows and columns within that sheet. How can I view the each named range on a second...

HI, when using a vlookup from a table that might have some blank cells in it, The returning refrences are showing "0%" when I want them just to appear as a...

I have a large spreadsheet and in some cells I have numbers and text. I have set up conditional formatting to show the cell as a different colour when the...

Can someone help me figure out why my Excel crashes when I go to convert the workbook as a pdf?

Hi I wanted to display the formulas permanently besides a calculated value. When I go to ToolsOptionsview, click on the window options Formulas, I achieve...

Hello, i am hoping someone can help, these forums are awesome for solving problems! To avoid anyone getting the worng idea, or having to ask a million...

Afternoon, Is it possible some-one could help with a formula to look inside a text string mixed of letters, numbers and symbols to return a number that...

HI, How do I countif a range where I want it to include more than 1 item. I`m usng the formula : =COUNTIF(AN10:AN89,{"W","SA+","ST","SA"}) This isn`t...

Hi, for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very...

I have numbers in column E8:F65500 which I named RANGE1, N8:O65500 which I named RANGE2. Column A is numbered 1 to 65500 referencing RANGE1, Column J...

I'm trying to count columns in a second worksheet. 1) If column A is = apple, then I want to count the entries in column B which are greater than "0" sheet...

I have two colums of data, the first is a time date stamp (mm/dd/yyy hh:mm) and the second is a rainfall total for each entry (0.00). I need to get a daily...

I am doing a macro and I would like for it to automatically go to the cell below last entry in a column and total. (row count will be different each time I...

In the EXCEL curve fit function for a single dependant variable should the coefficient of determination be upper case R-squared or lower case r-squared?

I'm logging data into a spreadsheet daily and keeping track of a rolling 30 days average and 1 std dev above the average. How do I easily create a way to...

-- I have a spread sheet as follows: In Column B1 thru B8, I have listed names of workers. In Column C1 thru C8 are cells to hold total hours work. In...