Excel Question: print the current time in Excel Cell?

 

Select a cell and hold the CONTROL + SHIFT keys and press colon to insert time.

Use CONTROL + semicolon to insert the date.
--------------------

(If you use the =now() formula in a cell, the present date and time will be inserted - but it will update to the present date/time every time the sheet is recalculated.)

Check whether some number exist in the column ... T? F?

Check whether some number exist in the column ... T? F?

A1 = 5
A2 = 3
A3 = 1

Check for number 7 answer False
Check for number 1 answer True

Icing on the cake .... how many times does it exist?

6 hours ago

by garbo744...

Member since: May 27, 2008

 

Best Answer - Chosen by Asker

To check if the numbers 7 or 1 appear in A1:A50:

=IF(COUNTIF(A1:A50,7)>0, "True", "False")
=IF(COUNTIF(A1:A50,1)>0, "True", "False")

Otherwise, just to count the occurrences:

=COUNTIF(A1:A50,7)
=COUNTIF(A1:A50,1)