Answered step by step
Verified Expert Solution
Question
1 Approved Answer
NUMERICAL METHODS Determine the 2nd Lowest value and 2nd Highest value and their specific row and column from the table by using VBA Excel. The
NUMERICAL METHODS
Determine the 2nd Lowest value and 2nd Highest value and their specific row and column from the table by using VBA Excel. The program should be in Option Explicit and code will be limited in using (Do until, If Else Then) and other codes are prohibited like (For, Msgbox, Select etc.). Please help me how to do it and send excel macro enabled file.
Insert Page Layout Data Search Share Comments File Home Formulas Review View Developer Help Lo Record Macro EYE Properties Map Properties al Import Visual Macros Use Relative References View Code to Expansion Packs Ley Export Add- Excel COM Insert Design Source Basic Macro Security ins Add-ins Add-ins Mode ! Run Dialog al Refresh Data Code Add-ins Controls XML K15 X V fc B C D E F G H J K L M N O P Q R A 0.200 500.000 0.002 0.008 0.040 20.000 100.000 0.080 0.160 2nd Minimum 0.500 00.000 0.063 0.125 .250 175.000 350.000 0.938 21.875 Row 3.000 1000.000 81.000 27.000 9.000 9000.000 3000.000 121500.000 243000.000 Column 7.000 1200.000 2401.000 343.000 19.000 58800.000 8400.000 10084200.000 20168400.000 .70 2200.000 3.352 4.913 .890 -221492550.000 3740.000 15618.427 -31236.854 2nd Maximum 4.600 2650.000 447.746 97.336 21.160 56074.000 12190.000 2729009.432 5458018.864 Row 3750.000 27.984 5.290 19837.500 3625.000 120681.431 241362.863 Column 2.300 12.16 9.000 3750.00 6561.000 729.000 81.000 303750.000 33750.000 110716875.000 -221433750.0 10 19.300 12000.000 2966.146 484.549 87.630 -221348643.500 $6405.000 343479695.220 -26142040.616 11 Microsoft Visual Basic for Applications - X 12 File Edit View Insert Format Debug Run Tools Add-Ins Window Help -OX 13 14 Project - VBAProject X (General) (Declarations) 16 . VBAProject (Num Sol_M Microsoft Excel Objects Sheet1 (Raw Data) This Workbook Properties - Sheet1 X Sheet1 Worksheet Alphabetic Categorized (Name) Sheet1 DisplayPageBreak False DisplayRightToLef False EnableAutoFilter False EnableCalculation True EnableFormatCon True EnableOutlining False EnablePivotTable False 33 EnableSelection 0 - xINoRestricti 34 Name Raw Data 35 ScrollArea StandardWidth 8.43 Raw Data + Visible -1 - x/SheetVisib " -- 110%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started