Basic Excel Formulas 2 ShowBasic Excel Formulas 2
We saw the SI function
Function and is also interesting. Combined with SI, this gives:
= IF (AND (condition1; condition2 ;....... conditionZ) true false)
displays on the various conditions to be verified (eg...
How to compare 2 excel sheet and combine uniq data? ShowHow to compare 2 excel sheet and combine uniq data?
Issue
Solution
Note
Issue
I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq.
All i want is to combine both with no redundant records. (A+B...
Burn an ISO image on two DVD of 4.7 Gb ShowBurn an ISO image on two DVD of 4.7 Gb
Issue
If you have an iso file or any type of files larger than 4.7GB and you want to burn it onto two DVD-ROM 4.7 GB
Solution
It can be done by creating an archive with 7zip and separate it into 2...
Cryptography - Enigma Show"Never blindly trust a cryptography system" - Gilles Dubertret
The history of Enigma
The need to encrypt messages appeared at the end of World War I (although encryption techniques had already existed for a long time).
It was a Dutchman living in...
PS/2 connector ShowPS/2 connector
The PS/2 connector (mini-DIN6 format) is mainly used to connect computers to keyboards and mice.
Pins
Pin number
Function
1
Clock
2
Ground
3
Data
4
Ground (or not...
Web - Introduction to the World Wide Web ShowIntroduction to the World Wide Web
The "Web", short for "World Wide Web" (which gives us the acronym www), is the name for one of the ways that the Internet lets people browse documents connected by hypertext links. The concept of the Web was...