Hi guys, Need some help with a formula please. Have tried myself and know that the answer is straightforward but going through a mental block! Col Q Col...

I'm struggling to convert a sumifs line from 2007 to excel 2003. The line I have working correctly in 2007 is: =SUMIFS('Washing MC...

Hi, I'm trying to write a formula that will go down a column and count the number of one value cells that occur between those of another value. For example,...

How might I carryover/copy additional information into the newly created row that includes the subtotal and name of the subtotal? For instance, the product...

Hi, say if I had a spreadsheet as follows: A B C D 1 E 3 2 E 6 3 E 6 4 C 6 5 C 6 6 C 4 7 D 4 8 D 3

I have a workbook set up with hundreds of single row range names with the columns showing January to December. Each row is a different Chemical. What I need...

Hi, I have a small spreadsheet with 20 check boxes in Column A (A1-A20). They are all linked to corresponding cells in Column B which give TRUE or FALSE...

Hi Friends, I have taken a project using Excel. Now wt i need is that if i click a command button in excel the macro coding must open a excel file from one...

Hello, I am attempting to automatically fill a row with dates. In Cell A5, I enter the first day of the month eg 1 April 2010. I then want the adjacent...

In my spreadsheet cells in the range E1 through E80 contain total dollar calculations from each of the columns to their left. Corresponding cells in column...

I want to get a folder listing (from a specific folder) that shows sub folders in the next column (under the parent folder). How do I do that does anyone...

good day, i am working on trying to do an index/match within an array. the formula i have...

I am using Office 2003. I have a large Excel data file that I need to pull specific info from. I want to be able to have a worksheet that automatically...

Hi, I have a spreadsheet with DDE macros that draws stock quotes from my data provider. One of the fields is for the lowest price of the day. Now, I'm...

I am protecting certain cells (Locking) in a workbook that is shared with many people. I have allowed for them to be able to select locked cells, sort, use...

I have created a workbook that I use to create the team rosters for a flag football league that currently has over 1100 kids and is getting bigger. Currently,...

I have a situation that I hope you can help me with or at least point me in the right direction. I have a spread sheet where column "A" has a defind set of...

I have a formula in spreadsheet to pull data from a pivot table. Part of the formula is a Date function. I would like to copy this formula down the...

Hi Group, I'm having difficulties finding a way that will automate my calculation of Standevp as shown in image (Column AC). The variable is the starting date...

I have the equation below which tallies the number of records that meet the criteria Server Hardware, Internal Issue and Limited Functionality. This works...