Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finite Math And Applied Calculus

Authors: Stefan Waner, Steven Costenoble

6th Edition

1285415132, 9781285415130

More Books

Students also viewed these Mathematics questions

Question

Describe Balor method and give the chemical reaction.

Answered: 1 week ago

Question

How to prepare washing soda from common salt?

Answered: 1 week ago