Need to edge out the competition for your dream job? Train for certifications today.
Open in new window
This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.
do I need the Min column, as doesnt seem to be considered in the formula? It seems to be there just to clarify to the viewer what the range is.
Function CompareRange(ByVal range1 As Range, ByVal value1 As Double, ByVal range2 As Range, ByVal value2 As Double, ByVal rangeMap As Range) As String
Dim r As Range
For Each r In range1
If r.Value >= value1 Then
If Cells(r.Row, range2.Column) >= value2 Then
CompareRange = Cells(r.Row, rangeMap.Column)
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.