So simple, yet I can not seem to get this right. I need month/year only in one cell. Thanks.

I am using the Variable validation procedure( DataValYesNoClear.xls) from: http://www.contextures.com/excelfiles.html in my workbook and it's working great....

Hi, I want to count the number of entries in column A. Formula is to count all cells that have data in them. Cells could theoretically contain a...

I have the following list (which in real terms goes to 10 variables). I have tried nested IF's but got nowhere. What is the best way of auto-completing the...

I need to write the IF function for two conditions: if a cell value is 2 but at the same time 4 (between 2 and 4) if true is equal to 4 otherwise if false is...

I have two date fields that users enter dates into. I have a field with the following formula where I want the dates to appear within a preformatted...

Can I create a macro that can automatically repeat itself depending upon the length of the file?

Can anybody help me out here ?=20 Maybe a little example to explain a bit ... Let's say I have the following data...

"Steve Lindsay" wrote: Need to create an Excel Timesheet that calculates the hours and minutes worked daily, based on the time-in/time-out. Then allow the...

We have a file which is updated monthly containing 'Vllookups' combined with 'IF, ISNA' formulae. This has worked successfully for many months but suddenly...

Hi, Can anyone explain why it is that a vlookup table automatically 'hides' itself within a worksheet that utilizes the vlookup function but the vlookup table...

How can I test only part of the text in a cell and if true return value of a different cell

I have a text and number string that I use to link my excel worksheet to a PLC for extracting values. The string is: =RSLinx|demo2!'gauge_offset_y', where 0 is...

I have a project that involves 6 worksheets all in the same workbook. What I need to do is get data from all the worksheet by a part number which is common...

I am creating an employee time sheet that the put in their starting time and ending time (From a drop down list). I would like Excel to calculate the amount of...

I want a formula that will tell me if a given cell has a number in it, so it evaluates the type of data. I looked in the help files and couldn't figure this...

I have two name and address lists. List A is the larger list (13,000 rows) and has names and telephone numbers along with other data. List B is smaller (5900...

I have been able to use the formula below to count the "unique" company names in list, but also wanted to use additional criteria such as Unique company names...

Would anyone have a macro (or suggestion) that can decipher which numbers in a list will calculate to a specified total?

I have a number/text that I want to apply a custom format to, but am not sure if it is possible. The number/text starts as 12K52E1, and I would like to apply...