What is the easiest way to convert three values - Month, Week, Year to a date? Date would be the Monday of the week specified. Pete

Using a vlookup, but getting a #n/a only on a few items. I concantenate two cells, then look for the same concatenate in a table. Out of 276 items, only 10...

Hi, I wish to create a roster tool for managers (who are very basic Excel users) to plan the shifts of workers. There are a selection of standard shifts but...

Hello I understand what the above function does, however I would like to know how it works, in obtaining the first available cell with data in the range from...

Can you tell me how to find the position number of the third space in a string of varying length and text. e.g., 123 456 789 111 222 need to find position...

When I e-mail someone a worksheet which contains drop down lists, they only get the arrow, they can not see what is in the drop down list in order to choose....

I have a list of 4 numbers with a sum at the bottom. One of the 4 numbers is a calculation, the others are direct entry. The calculated number cannot be...

Hi, I have 2 work books. One is weekly schedule and other one is yearly vacation schedule. I would like to link both books matching names and dates....

hi all i am new to excel,i was making some sheet and when i type number 5 or any number it show.005,please let me know what to do

What's going on with the Day formula for 2010? I am working in Excel 2003 and the formula that I always use to pull the day of the week isn't working. I...

I'm using vlookup to populate sheet 2 from sheet1. This is working for part of the spreadsheet, stops for 8 rows then continues working. According to the...

I tried posting this question earlier and received an error message, so I apologize if this question shows up twice. I'm trying to insert a bottom border on...

i all I am having a strange issue with my excell file since a while. This is the second year I am using it without problem. I start a workday with a new sheet...

I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS Cell Q73 reads...

I need some help. How to choose amount appear at first coloums for each rows? Lets say I have coloum A-Z and row 1-1000. Each coloums has amount and its appear...

Hi all i using following formula and description for the dynamic chart. Please do the needful In B1 = Project start date , C1= Mar-10 In B2= Project duration...

Problem is that you can't simply filter out some data field because in some row fields they have values and at some they don't. So what I essentialy need is...

Hi i am having a SUMPRODUCT COUNTIF problem. Previously the formula was missing a single quotation mark between the double quotation marks. Once this was...

Hi, my question is..I want to use an If formula based on the Grp colomn value BU (see formula below), but it doesnt recognise the value as "BU", it just...