I have a data sheet similar to this. I would like to know what I need to do to create formulas/functions that allow this to happen while running an advanced filter.
<tbody>
</tbody>
I have 3 sheets as follows, "Data",FilterData", "Lists"
Data has data obviously
Filter data has input area(3 data validation drop boxes here), *criteria area(missing formula to make it true to the conditions)*, and extract area(well extract not yet set up due to missing formulas)
Lists has the 3 criteria listed and dynamically named ranges
I have tried looking this up and none of the examples deal with mostly text strings but numbers instead. Am I able to assign an integer to a text string or what is the best way to go about it?
I was able to retain some of what I saw in the manys videos/ tutorials as far as getting to this point( and even after, meaning I am able to set up recorded macro) I just cant seem to grasp what I need to do for the worksheet code.
Any help would be greatly appreciated.
Thanks in advance,
LTSSB
| Rank(5 Star Rating System | Name(Multiple duplicate names) | Tier(Typical letter grade scale) |
| 1 | Name1 | A |
| 1 | Name2 | B |
| 2 | Name1 | F |
| 3 | Name1 | C |
<tbody>
</tbody>
I have 3 sheets as follows, "Data",FilterData", "Lists"
Data has data obviously
Filter data has input area(3 data validation drop boxes here), *criteria area(missing formula to make it true to the conditions)*, and extract area(well extract not yet set up due to missing formulas)
Lists has the 3 criteria listed and dynamically named ranges
I have tried looking this up and none of the examples deal with mostly text strings but numbers instead. Am I able to assign an integer to a text string or what is the best way to go about it?
I was able to retain some of what I saw in the manys videos/ tutorials as far as getting to this point( and even after, meaning I am able to set up recorded macro) I just cant seem to grasp what I need to do for the worksheet code.
Any help would be greatly appreciated.
Thanks in advance,
LTSSB
