Is there a function that returns the row, column or address of the active cell? I'd like to build a formula in a column that displays a character if the...

I have 5 plus variables. See below for types of criteria. If the criteria meet certain conditions then it needs to sum all the appropriate values for that...

Hi all, I've been wrestling with a problem for some time now and I think it's time to ask for some professional help :( I've got a column from J3:J1000 that...

I have a hyper link in cell b4 in worksheet 1 which links to another file. How can I link that hyperlink to cell b4 in worksheet 2 so that when I update the...

I want excel to automatically add the current date in a cell.

Hello, im working on xl sheet which contain 12 months information. i need to highlight the next column to the date according to the month. If the date in cell...

Hi, XL2003 I have many named ranges in my workbook. Relevent ones a "Components" "ResTH" (without the quotes). On my worksheet: Cell A2, Data Validation...

I have two different datasets. Each with a common identifier. I need a formula that will reference the identifiers in both datasets and count the number of...

Hi Guys, Thanks for all the previous helps and guidance on excel sheet and im looking forward for new assistants. i've various dates in column A and values in...

Does anyone have any idea how to accomplish the following using a macro? The first sheet has 'n' number of rows. I want to automatically create a seaparate...

I copied and pasted data into a current Pivot Table data Sheet. I reviewed the wizard to be sure that my rows and column lengths were correct. I refreshed...

How do I create the formula that will add a range of cells with a certain text letter? Ex. A1 =NCW A2 =NCFY A3= NCWF A4=NCFP I want A5 to contain the number...

Hi all, I've got a bit of a problem involving VLOOKUP on a spreadsheet I'm designing. I have a VLOOKUP formula in a particular cell (which works) that I...

Hi all, I've been trying to achieve the above now for a couple of weeks and I've got nowhere. Please could someone help me? I have a list of transactions in...

Hi I have a column of dates covering several years. I want to total the dates as # of events per month per year. Example date range my result...

I have a huge excel master workbook with 30 worksheets to report data from 50 other workbooks... to add a single workbook to the master file is a huge...

I copies the same file to 2 different computers Computer 1, I can tab to cell and enter information Computer 2, I have to double click on cell to enter...

I have an Excel Pivot Table that I want structured like: State - City - Last Name - Product - Sum of Sales I want the end result to Group (sort by) State,...

This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make...

Hi, Looking at an answer from Teethless Mama to someone else's question, raised yet another question. (what a surprise) The formula was:...