Multiple lines of criteria without repeating header

  • Thread starter Thread starter fbj
  • Start date Start date
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
 
Hi
AFAIK there's no chance to prevent the 'clumsy' solution in using DMAX
(that is repeating the heading row).
 
Back
Top