Search : in
By :

Find Maximum Value.

Last answer on Jul 24, 2009 3:56:49 am BST Neeraj Kumar Singh, on Jul 23, 2009 1:14:34 pm BST 
 Report this message to moderators

Hello,

I want to find the maximum value from text columns i.e.

Code
N10001
N10002
N10003
N10004
N10005
N10006
N10007
N10008

I have this type of data, and i want to know find the maximum value from this code??
i.e. I want to find the data of maximum value of "N10008"

Configuration: Windows Vista Internet Explorer 7.0

Best answers for « Find Maximum Value. » in :
Find max for selected number of values Show
VB6 Finding the RGB values of a color Show VB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
Finding the same value in diffrent sheets Show
How do I find Word's keyboard shortcuts? ShowHow do I find Word's keyboard shortcuts? To deal with shotcuts you have several possibilities. 1- Some keyboard shortcuts are listed next to the items in the main menu (just open menu list and check out). 2- You can also find...
Introduction to MTU ShowIntroduction to MTU What is MTU Calculate the MTU Find the value of the MTU on Windows Changing the MTU on Windows Find the value of the MTU on Linux What is MTU The Maximum Transmission Unit (MTU) (maximum size of transfer...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
HTML forms ShowForms Interactive forms let web page authors give their pages interactive elements, such as for receiving messages from their readers, much like the reply cards found in some magazines. The reader enters information by filling in fields or clicking...
Environment variables ShowEnvironment variables An environment variable is a dynamic value loaded into the memory that can be used by several processes operating simultaneously. On most operating systems, the location of some libraries or of the main system executables may...
Control - control.exe Showcontrol - control.exe control.exe (control stands for Control Panel) is a Windows NT/2000/XP generic process which corresponds to the control panel. The file that corresponds to this process is normally found in the directory...
Ask your question Reply

1

 Excelguru, on Jul 24, 2009 3:56:49 am BST

Hello Neeraj

Get the number part by using the formula =RIGHT(A1,4)*1
I hope the rest you can do Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

   
Reply to Excelguru
Ask your question Reply
They need your help