How do I search a worksheet for a custom "text" max and min value

J

Joe Lewis

I've got a worksheet that is used as a practice log for musicians. There is a
column for "Dynamic Range" where they can choose from a drop-down list the
lowest (in one cell) and highest (in the next cell to the right) dynamic
(i.e. musical volume) for that excercise. The dynamics are:

pppp
ppp
pp
p
mp
mf
f
ff
fff
ffff


These are musical terms that are listed from quietest (pppp) to loudest
(ffff.)

How can I make a formula to look through the worksheet for the day (which
might contain several different excercises with different dynamic ranges
chosen) and pick out the quietest dynamic and the loudest dynamic to form a
total dynamic range for the day?

For example,

If one excercise has the dynamic range of pp-f chosen, and a second
excercise has p-f chosen, and a third excercise has mf-ff chosen, the formula
would return a total dynamic range of pp-ff.

Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic sorting (giving max and min) based on custom sorting lis 4
how do I print a named dynamic range 7
How can I test for nulls within a range without specifying each ce 2
How do I count a range of times and link it another worksheet. 3
How do I automatically generate a worksheet. 1
how can I get the worksheet with the pivottable sourcedata whenworking with a pivotchart ? 4
How do I split column? 3
how do I find a max TEXT value? 2

Top