F
fbj
Hi
I'm using the database functions DMAX etc and want to have a variety o
criteria in a column. However I believe the "criteria" range has to b
a minimum of 2 rows with the top row containing headers. If I want t
reference a row of the range of criteria, I am then lacking th
headers. Including the headers would then include all rows of criteri
in between too - creating an undesirable OR condition.
Eg:
----B--------C--------D
2--Angle--Angle---Max
3-->=1----<3-----=DMAX(dbase,2,B2:C3)
4-->=3----<5-----=DMAX(dbase,2,B2:C4)
5-->=5----<6-----=DMAX(dbase,2,B2:C5)
6-->=7----<8-----=DMAX(dbase,2,B2:C6)
etc
The range "dbase" looks like, e.g:
Angle---column2
0.5------103
8.3------422
6.2------500
1.6------143
7.0------650
etc
I would like to avoid the simple but clumsy solution of putting th
header on each criteria:
----B--------C--------D
2--Angle--Angle---Max
3-->=1----<3-----=DMAX(dbase,2,B2:C3)
4--Angle--Angle
5-->=3----<5-----=DMAX(dbase,2,B4:C5)
6--Angle--Angle
7-->=5----<6-----=DMAX(dbase,2,B6:C7)
etc
I've tried a few things, including splitting the criteria range, e.g
B2:C2:B6:C7 but that doesn't cut it.
Is there a way to split the range or identify the column of th
criteria (not the database - found plenty of support about that
without needing the header row, such that I could simply reference
single row criteria range?
Any ideas would be much appreciated
With thanks
FB
I'm using the database functions DMAX etc and want to have a variety o
criteria in a column. However I believe the "criteria" range has to b
a minimum of 2 rows with the top row containing headers. If I want t
reference a row of the range of criteria, I am then lacking th
headers. Including the headers would then include all rows of criteri
in between too - creating an undesirable OR condition.
Eg:
----B--------C--------D
2--Angle--Angle---Max
3-->=1----<3-----=DMAX(dbase,2,B2:C3)
4-->=3----<5-----=DMAX(dbase,2,B2:C4)
5-->=5----<6-----=DMAX(dbase,2,B2:C5)
6-->=7----<8-----=DMAX(dbase,2,B2:C6)
etc
The range "dbase" looks like, e.g:
Angle---column2
0.5------103
8.3------422
6.2------500
1.6------143
7.0------650
etc
I would like to avoid the simple but clumsy solution of putting th
header on each criteria:
----B--------C--------D
2--Angle--Angle---Max
3-->=1----<3-----=DMAX(dbase,2,B2:C3)
4--Angle--Angle
5-->=3----<5-----=DMAX(dbase,2,B4:C5)
6--Angle--Angle
7-->=5----<6-----=DMAX(dbase,2,B6:C7)
etc
I've tried a few things, including splitting the criteria range, e.g
B2:C2:B6:C7 but that doesn't cut it.
Is there a way to split the range or identify the column of th
criteria (not the database - found plenty of support about that
without needing the header row, such that I could simply reference
single row criteria range?
Any ideas would be much appreciated
With thanks
FB