if column A1 has any value and column A3 has any value and column A7 has any value , so can i short these value with excel formula.....

Hello to all!! I have one question if anybody can help me, in range I have to calculate how many filled cell is they are one ater the oher. Example: A AE ...

Hi guys, I have a worksheet with a running history of yearly data that is added to each week. I want to set up a count for the most frequent round number that...

I have dates in one column to show the due date of an action item. In the "status" column to the right, I have whether or not that action item is "closed",...

Imagine that I've got a column of 100 numbers. First, I want to find the maximum value (MAX function). Let's say that turns out to be in the 80th row. Now I...

As a self taught Excel user I appear to have developed a personal style that differs from most examples of spreadsheets that I see. One issue is the use of...

I frequently use Autofilter to count the number of instances in a column of data. Usually, when I apply the autofilter to the column heading and execute a...

I have an application where I need to update cell B5 in Sheet 1 with a cell value from a specific cell (C4) on Sheet 2. The issue is that in this instance, I...

Would love some assistance with the following: If I have a start date in a cell (A1), I am hoping to enter a number of additional workdays into another cell...

How do you take Last,First and change it to First Last? Ex: Joe,John needs to be rewritten to John Doe. Using Excel 2003 and having the formula be in a...

I have used a spreadsheet for years (not created by me) that figures dates for leases. I enter the starting date at the top, then in a column the number of...

Using Excel 2007, I have a two column list with over 100,000 rows. Example: Jane Doe U Jane Doe John Doe John Doe U John Doe Jack Doe

Using MS 2007, I have a column that has 40 sets of three rows; the rows are for three seperate years for 40 different schools that are included in the chart....

I have two different columns which should contain the same contents but there are diffences. Each column should have 194 entries (cells) but one has only 150....

I have a column of data which is not consistent. Examples of the data in the column: C- Name, CO- Name, CN- Name, Name, etc. I want to write a...

Hi All As part of a macro , I use this command : ActiveWindow.SelectedSheets.Delete On each occasion I run it , I get a popup which ask me if I really want...

we have an excel sheet with multiple workbooks in it i.e.tabs.Now we want to create a new excel sheet which has only 1 workbook from the actual excel...

I make weekly payments for my son's school, every week is the same amount but the total per month may be different since some months have more weeks than...

Can someone help with this formula, or perhaps come up with a simpler version? =IF(E2="Startup","Yes",IF(E2="Enrollment Open","Yes",IF(E2="Enrollment...

I having difficulty with unigue filtering. Probably because it's too close to tommorrow. I have a range of numbers in a column. There may be up to a hundred...