I would like to write a formula for cell P8 which equals the value of the last cell in which a value was entered in column M. Thus, if cell M1 is the only...

Hi Groupies: I posted this a couple of days ago, but I missed the functions group, no reply yet. I was asked if this was possible and I can not think of...

I'm trying to simplify a series of "If" formula's buy using a lookup table and the "&" function to provide the cell reference I'm looking for. The formula...

I want to say in a formula... If certain cell contains "DMA", then copy over a formula from a cell immediately to the left, otherwise "". Is this possible???

I have multiple spreadsheets in a workbook and each worksheet contains recorded rainfall data for each day of a month. In the column containing the recorded...

I am trying to get a function to look through a list of 200 parts to match two text strings, then return a value that corresponded to the last entry made....

If A1 has a date of 8-1-08 and B1 has a date of 8-1-09, I am trying to get a True or False answer in C1 if the month and year of A1 and B1 do not match. I...

I'm using the following code within a Worksheet_Change function to lock/clear and unlock a range of cells. There's also another bit of code in the function...

I am not an excel expert. I am trying to get a true false answer in C1 if A1 (8-1-08) and if B1 (8-1-09) month and year do not equal. I have tried...

Hi, I am having Excel data in the following format: A B C Country State City India TN ...

I'd like to automatically put the date into cell P2 whenever the data in cell N2 is changed. I'd like to do the same for P3-N3. I found the VBA code to do...

Hellow, Lets say I have a file with data in 400 rows. I do not want to allow users to delete OR INSERT rows from 1 - 200. But from row 201 on they can do...

Can I get excel to enter the date in one cell that data was entered in another, without relying on the user to input this data? I have tried the TODAY()...

I'm trying to get an averageif formula working but the criterion I'm trying to satisfy is of a number greater than that contained in a specific...

I have the following in cell: A1 "Item : ZB/B/15-2154 - ALL GOLD INDIAN TOMATOES DICED 12x410G Stock On Hand : 6" how do I combine the following 2...

Hello, I am looking for a function that counts text values. Is possible to count for example: how many times in the column A appears text value exp....

Hi I really need some help with a function that can do this: I have 5 seperate sheets in 1 workbook, each with a week of the month and a spare week. I.e....

Sorry but I couldn't find this. I need a formula that finds a date (shown as text) 08 2008 in range e.g. A1:A100 and if found, this should be placed in a new...

Hi I’m trying to count various items in a column, but not all. I can either do this by stipulating a range of items or using a wildcard. However,...

In order to retain the original data in a worksheet, I have created a second worksheet that pulls cells row by row, cell by cell to do data manipulation and...