I have values (Digits) in excell columns like A & B , i need to display the sum of each digits (A+B) in column C.
i dont want to display the formula in column c. could anyone help me in dis .
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...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell
The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content.
The example given below will help you to find out if the cell was changed,...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel
Below is a tips of how to connect an Access database (MDB) in an application excel
Add reference
Microsoft DAO object librairy X.X
In a general module (eg Module1) paste the code below...
Download Codejay - Code Generator ShowCodejay - Code Generator allows you to administer the database of a website. It also allows to create reports for the website and produce several types of source codes: ASP, ASP.NET, COLDFUSION and PHP without writing a single line of code.
Codejay...
Download K-Lite Codec Pack Full ShowK-Lite Codec Pack is a collection of VFW/ACM codecs, DirectShow filters and tools. Codecs and DirectShow filters are needed for encoding and decoding (playing) audio and video formats.
Contents of version 4.7.0 :
Player:
Media Player...
Spreadsheet - Formulas ShowIntroduction to Formulas
The main use of a spreadsheet is to automate
calculations, which means using cells to perform operations based on
values in other cells. The spreadsheet recalculates all the values each
time a change is made to the value of...
ASCII Code ShowData coding
Morse code was the first code used for long-distance communication. Samuel F.B. Morse invented it in 1844. This code is made up of dots and dashes (a sort of binary code). It was used to carry out communication much faster than could...
Video compression (codecs) ShowThe concept of codec
A non-compressed video image occupies approximately 1 MB. In order to obtain a fluid video, it is necessary to have a frequency of at least 25 or 30 images per second, which produces a data flow of approximately 30 MB/s, that...