Data Analysis Tab

  • Thread starter Thread starter Tom
  • Start date Start date
Missed to mention that this is part of Analysis toolPAK. On the Tools menu,
click Add-Ins. In the Add-Ins available box, select the check box next to
Analysis Toolpak, and then click OK. Now check out the tools Tab the last
command button would be 'Data Analaysis'

If this post helps click Yes
 
I tried that before coming here and it didn't change anything. I don't have
the Analysis tab to begin with.
 
--From excel Options>AddIns> bottom for 'Manage' make sure the selection is
'Excel Add-Ins' and click 'Go'.
--Now from the list select Anallysis ToolPak. If Analysis ToolPak is not
listed in the Add-Ins available box, click Browse to locate it (analys32.dll)
--You will be prompted to installed on your computer, click Yes to install it.

If this post helps click Yes
 
Thank you!

Jacob Skaria said:
--From excel Options>AddIns> bottom for 'Manage' make sure the selection is
'Excel Add-Ins' and click 'Go'.
--Now from the list select Anallysis ToolPak. If Analysis ToolPak is not
listed in the Add-Ins available box, click Browse to locate it (analys32.dll)
--You will be prompted to installed on your computer, click Yes to install it.

If this post helps click Yes
Click to expand...
 
Try the below and once you get it how to work combine it to a single formula

Col A Col B Col C
Feet Inches In inches
2 3 =A2*12+B2
4 3 =A3*12+B3
=C2+C3
In cell C4 =c2+c3
=INT(C4/144) & " sq feet " & MOD(C4,144) & " inches"

PS: Also take a look at CONVERT() Converts a number from one measurement
system to another.. part of Analysis ToolPak add-in.

If this post helps click Yes
 
Back
Top