Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
I would like to make a workbook or worksheet in excel 2003 that i can enter
epd data on beef cattle. Have the sire's listed in one table and the dam's listed in another table. then in the third table be able to type in the dam's name and the sires name and it give me an estimate of the offsprings epd's which is just an aveage af the sire and the dam. When I type in the sire name and dam name i would like it to lookup the information from the first two tables and apply the aproprate formula to get the average. I know a little bit about excel and can make it do simple formulas, and make the formulas. Can excel do this or would it be better with something like access. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
I don't have excel here to test this on, but I think you want something like
this: Let's say you have the SIRE in A2:A100 and the DAM in B2:B100 and the EPD (whatever that is) in C2:C100 on Sheet1 On another sheet, you have Sire in A2, DAM in B2 and you want the average EPD in C2. Try this in C2: =average(if(Sheet1!A2:A100 = A2, if (Sheet1:B2:B100 = B2, C2:C100))) COmmit with CTRL SHIFT ENTER "Cowboy" wrote: I would like to make a workbook or worksheet in excel 2003 that i can enter epd data on beef cattle. Have the sire's listed in one table and the dam's listed in another table. then in the third table be able to type in the dam's name and the sires name and it give me an estimate of the offsprings epd's which is just an aveage af the sire and the dam. When I type in the sire name and dam name i would like it to lookup the information from the first two tables and apply the aproprate formula to get the average. I know a little bit about excel and can make it do simple formulas, and make the formulas. Can excel do this or would it be better with something like access. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |