Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Excel Database/Criteria Spreadsheet (Windows)

Posted by Al on December 19, 2000 5:42 PM
Created mini database/criteria/table spreadsheet on a Mac platform over last 10
yrs. Now I am switching to a PC platform. The spreadsheet had the following:
A B C D
1 DATE EXPENSE AMOUNT DESCRIPTION
2 AMOUNT
3 =DSUM(DATABASE,"AMOUNT",CRITERIA) This formula in C2
4 RENT01 {=TABLE(,B2)} This in B4..B5..B6..a few more
5 MISC01
A B C D
20 DATE EXPENSE AMOUNT DESCRIPTION
21 12/12/01 RENT01 $100.00 Jan
22 12/12/01 MISC01 $100.00 Yard

Each entry from C20 down would CUM in upper section B4 etc.
Can someone help me create this in latest Excel for Windows ?
Can not locate same pieces in windows version
to recreate..
I remember highlighting the info in Row A clicking
CRITERIA then highlighting A20-D150 click DATABase
then somhow using the TABLE feature for the CUM area B2-B6 or so..

I would appreciate any help..


Re: Excel Database/Criteria Spreadsheet (Windows)

Posted by cpod on December 20, 2000 6:57 AM

Check Excel help under Advanced Filter. That should tell you what you need to know.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.