|
Subject:
|
creating formula for date
|
|
Posted By:
|
ct
|
Post Date:
|
10/4/2005 3:47:31 AM
|
i have a problem to create a formula...for example in sheet 'A' in 'column A' I have list three different date..for example:
A2: 1\1\2005 where B1: tshirt
A3: 2\1\2005 where B2: jean
A4: 3\1\2005 where B3: tshirt
then i want to capture the date in sheet 'B' in column A1..here i just want to capture output 'tshirt' only for certain date but in different sheet...how i want to create the formula..can u help me...
|
|
Reply By:
|
maxpotters
|
Reply Date:
|
10/6/2005 5:16:15 AM
|
Hi,
Im not sure I understand this correctly but let me have a try.
In sheet "B", in cell A1 type:
=IF(Sheet1!B1="tshirt",Sheet1!A2,"")
What this formula does is that it checks cell B1 in Sheet1 on the word tshirt. If B1 = tshirt, then the cell where you type this formula in, gets the value of Sheet1!A2, thus the according date. Copy down this formula to the rest of the cells, and you are done
Hope I understood this correctly
Max
|
