I have 3 column, A = Date, unsorted; B = Value, unsorted: C = Balance, calculated.
I am trying to find the smallest number in column c when the sheet is sorted by Date, (A assending), and the date associated with it.
I can get it but the process is cumbersome. (see attached sample) … I was thinking I could write a macro to do the copying, sorting and selecting but … I have no idea if a macro would accomplish what I am trying to do.
Assistance would be appreciated.
EDIT: Notes do not pertain to question. Please disregard the notes and even the question for that matter.