COUNT cells in MS Excel

Here I have described all the types of COUNT formulas in MS Excel.......

COUNT(range):

    This function is used to count the number of cells in the given range which contain numbers in it.

COUNT(A1:A10) = 5

COUNTA(range):

    This function is used to count the number of cells in the given range that are not empty.

COUNTA(A1:A10) = 8

COUNTBLANK(range):

    This function is used to count the number of cells in the given range that are empty.

COUNTBLANK(A1:A10) = 2

COUNTIF(range, criteria):

    This function is used to count the number of cells in the given range that match the given condition or criteria.

1)

COUNTIF(A1:A10,"") = 2

 2)

COUNTIF(A1:A10,"=D") = 1

 3)

COUNTIF(A1:A10,"<>D") = 9

 4)

COUNTIF(A1:A10,"<3") = 2

COUNTIFS(range1, criteria1, range2, criteria2,.....):

    This function is used to count the number of cells in the given ranges that match the given conditions.

Note: In all the given ranges & conditions, the minimum count will be taken.....

COUNTIFS(A1:A5, "<3", A6:A10, "<>") = minimum(2,4) = 2

Extras:

"" - blank

"<>" - not equal to blank

" " - contains 'single space'

Thanks for visiting.......!

If u r in need of any projects, you can contact me via gopi21uk@gmail.com
Areas: DOT NET, SQL, HTML, Data Entry, Excel, etc

VBA module (Macro or Function) for MS Excel to display numbers in words

Here is the simple VBA code for MS Excel to convert numbers into words....

e.g.:   ‘23’ -----> “TWO THREE”     &    ‘140’ ----->  “ONE FOUR ZERO”

Steps to add VBA module in MS Excel:

1) Open Excel.

2) Press Alt + F11 to get a window to insert VBA code.

3) Press Insert menu + Module or Right Click on Module tab + Insert + Module to insert new module.

4) Copy and Paste the following code and save it.

Public Function WORD(ByVal num As Double) As String

Dim digits()

digits() = Array("ZERO", "ONE", "TWO", "THREE", "FOUR", "FIVE", "SIX", "SEVEN", "EIGHT", "NINE")

If num <> 0 Then

Do While Val(num) <> 0

WORD = digits(Right(num, 1)) & " " & WORD

num = (num - Right(num, 1)) / 10

Loop

Else

WORD = "ZERO"

End If 

End Function

5) Now Use the function we defined in our module in ur Excel as shown below:

6) Save it in as .xlsm (Excel Macro-Enabled Workbook) file.

Note: When you open the Excel file again, the function will work only if macro is enabled.

By default, when you open MS Excel, macro might not be enabled. It will show warning message that macro has been disabled, when you open it.

You have to enable the macro every time by clicking Options wherever the system you open it as shown below:

Thanks for visiting.......!

If u r in need of any projects, you can contact me via gopi21uk@gmail.com
Areas: DOT NET, SQL, HTML, Data Entry, Excel, etc

Data Storage Security in Cloud Computing using DOT NET

Cloud Computing

• Cloud computing means using multiple server computers via a digital network, as though they were one computer.
• Cloud computing works on a client-server basis, using web browser protocols. The cloud provides server-based applications and all data services to the user, with output displayed on the client device.
• It is significant to address the security problems such as insider attacks and identity thefts in network computing systems.                                                            more>>

Algorithm using Cryptography

Here I have implemented a secure lightweight cryptography algorithm, which combines the strong and highly secure asymmetric cryptography technique with the symmetric cryptography to store data across network-distributed systems in a secure way and with acceptable performance. This algorithm implementation covering the authentication procedure, encryption and decryption of files and other generic interface operations are implemented using .NET and are tested initially in the local environment. Further, to ensure the algorithm performance in the cloud storage environment, the Box.net suite and all phases of the algorithm has been tested. Hence this work opens gate for safe, secure and easy data access and management in the cloud.

If you need

Ø  Details and Report of my project, Click here.

Ø  This project or any other projects in .NET, contact me.

Awards & Nominations of Kamal Hassan

Plenty of Nominations & plenty of Awards; We can proudly say that he is an icon of our Indian Cinema and he is damn good at what he is doing!

He's got Padma Shri award which is 4th highest civilian award given by Indian Government and Kalaimamani Award from TamilNadu Government.

Total awards won and nominated are 56 & 65 respectively.....!

Name of the Awards	Total won
National Awards	4
Filmfare Awards	2
Filmfare Awards South	17

7 of the films that he has been featured were submitted by India to the Academy Awards for Best Foreign Language Film, the most films ever submitted for any actor in India.

All his Awards in detail