Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i setup formula in excell
i have got two sheets in sheet 1
A B C 29-Mar-05 30-May-05 7.00 31-May-05 24-Jun-05 39.00 25-Jun-05 01-Jul-05 46.00 In Sheet 2 i got... 01-Apr 7 02-Apr 7 03-Apr 7 04-Apr 7 05-Apr 7 06-Apr 7 07-Apr 7 08-Apr 7 09-Apr 7 10-Apr 7 11-Apr 7 12-Apr 7 13-Apr 7 14-Apr 7 can i put some formula to get it done automaticaly. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i setup formula in excell
Hi
can i put some formula to get it done automaticaly. not sure on what "it" is, ie the thing you want to get done automatically .... i can't see how 7 (whatever's) per day for April relate at all to A B C 29-Mar-05 30-May-05 7.00 31-May-05 24-Jun-05 39.00 25-Jun-05 01-Jul-05 46.00 if you'ld like to explain your data and what you want to achieve with a few more words i'm sure we can assist. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "darsg" wrote in message ... i have got two sheets in sheet 1 A B C 29-Mar-05 30-May-05 7.00 31-May-05 24-Jun-05 39.00 25-Jun-05 01-Jul-05 46.00 In Sheet 2 i got... 01-Apr 7 02-Apr 7 03-Apr 7 04-Apr 7 05-Apr 7 06-Apr 7 07-Apr 7 08-Apr 7 09-Apr 7 10-Apr 7 11-Apr 7 12-Apr 7 13-Apr 7 14-Apr 7 can i put some formula to get it done automaticaly. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i setup formula in excell
A guess:
Try VLOOKUP eg., =VLOOKUP(A1,Sheet1!$C$1:$A$3,3) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i setup formula in excell
If your sheet1 data are in A1:C3 and the sheet2 data start in A1:
=SUMPRODUCT((A1<=Sheet1!B1:B3)*(Sheet2!A1=Sheet1! A1:A3)*Sheet1!C1:C3) "darsg" wrote: i have got two sheets in sheet 1 A B C 29-Mar-05 30-May-05 7.00 31-May-05 24-Jun-05 39.00 25-Jun-05 01-Jul-05 46.00 In Sheet 2 i got... 01-Apr 7 02-Apr 7 03-Apr 7 04-Apr 7 05-Apr 7 06-Apr 7 07-Apr 7 08-Apr 7 09-Apr 7 10-Apr 7 11-Apr 7 12-Apr 7 13-Apr 7 14-Apr 7 can i put some formula to get it done automaticaly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell 2007 setup | Setting up and Configuration of Excel | |||
Formula setup | Excel Discussion (Misc queries) | |||
Excell Page setup | Excel Worksheet Functions | |||
How Can I setup data in csv format in Excell? | Excel Discussion (Misc queries) | |||
Excell 2003 Page Setup Slow | Excel Programming |