Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I'm currently using page 1 of a work book as a data base. Not certain thats the best idea because opening, saving and calculating have become slower as the information expands. This is not my real question, but any feed back will be welcome. So page 1 is the database, on page 2 some calculations. Would like to include matching cells from column H that meet criterian held in columns W, X, Y and Z (1 each). then I would need to add and average these cells. Is this possible to do in one step? Should I use a Index Match or would a filter be the way. Thanks, as always for the help! M.A.Tyler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |