Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
.... This is however VERY
inefficient, and I would like to somehow get the data I want for a given month without having to change my formulas. If it's already very inefficient now.. reconsider. Redesigning HOW the data is stored can save you a lot of hassle later on. With your data in a proper 'database' structure, rewriting your formulas will be easy. and maintenance / analysis options will improve drastically. Year,Month,Dept keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "David" wrote: Hello, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MATCH/IF/OR/AND statements not what I need apparently | Excel Discussion (Misc queries) | |||
Help with INDEX and MATCH statements. | Excel Worksheet Functions | |||
Multiple match statements? | Excel Discussion (Misc queries) | |||
match statements | Excel Discussion (Misc queries) |