Generating Lottery Numbers In Excel

Generating Lottery Numbers In Excel

The chance of winning a lottery is usually infinitesimal but the magnitude of the rewards tends to over shadow it. This is why millions of people play or fantasize about winning the lottery daily. Since most Lottery use pseudo-random numbers to pick a winner, I will...
Sumproduct with Wild Cards

Sumproduct with Wild Cards

The 3 wildcard characters (?*~) used in other excel formulas do not work with sumproduct. However, SUMPRODUCT utilizes other functions (LEFT, RIGHT, FIND and MID) to give you the same results. Using below example  showing  Cost Codes and Total Cost, ►Find the Sum of...
How to Update Date or Time in EXCEL

How to Update Date or Time in EXCEL

To update/extract the date or Time part separately in a DateTime Value is a lot easier  if you understand that excel stores dates as sequential serial numbers and time as a fractional portion of a 24 hour day. With the above understanding, you can combine INT and MOD...

Pin It on Pinterest