![]() |
function question
fDate fa fb fDat1 fDat2 fStock
2006-05-07 kk a 10 0 0 2006-05-18 kk G283 6 0 6 2006-05-14 kk a 9 0 9 2006-05-18 mm G274 9 1 8 2006-05-18 kk a 1 0 1 2006-05-18 hh G278 1 0 1 2006-05-18 pp m 2 0 2 2006-05-18 aa x 5 2 3 2006-05-19 mm G274 9 7 2 i want to make fStock field using excel worksheet function in the upper data *** Sent via Developersdex http://www.developersdex.com *** |
function question
One way:
Assuming fStock is column F: F1: =D1-E1 copy down. In article , x taol wrote: fDate fa fb fDat1 fDat2 fStock 2006-05-07 kk a 10 0 0 2006-05-18 kk G283 6 0 6 2006-05-14 kk a 9 0 9 2006-05-18 mm G274 9 1 8 2006-05-18 kk a 1 0 1 2006-05-18 hh G278 1 0 1 2006-05-18 pp m 2 0 2 2006-05-18 aa x 5 2 3 2006-05-19 mm G274 9 7 2 i want to make fStock field using excel worksheet function in the upper data *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 10:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com