Search results for query: *

Sorry I did misspeak, and the median formula listed =if(count(A2:C2)<3,min(A2:C2),median(A2:C2)) works perfectly! Thanks to all

I have a listing with three columns. i would like to select the middle value, not necessarily the median, of the three. If there are less than 3 values select the lowest value. Set up like this: Credit Scores Selection Vendor 1 Vendor 2 Vendor 3 718...

Skip, Thanks again. Works like a charm! Peter

Ok. I must be a box of rocks..., but when I inserted the open command it opens a blank .txt file. Where should I have inserted the code? Peter

Thanks to both of you for your help. I added the code changes and when I run the macro it asks which month I am looking for, but it still does not open the selected workbook. I have attached the entire code for any thoughts. Worksheets(&quot;Sheet1&quot;).Activate...

Thanks for the help, but something is not right. Could be the set up of the macro. (original below) Worksheets(&quot;Sheet1&quot;).Activate Worksheets(&quot;Sheet1&quot;).Cells.Clear ChDir &quot;H:\Treasury\Dept0034\Reporting\CMR Reports\Fy 2003&quot; Workbooks.Open...

Hello, I have a macro created that imports information into my workbook from a file whose name changes monthly. I would like to have a msg box ask the user to input the month and year needed. The file name is &quot;Amortizing Advances August 2003.xlw&quot;. I am thinking that the macro needs...