list.
Highlighting Duplicate Entries
Functions For Duplicates
Counting Distinct Entries In A Range
Extracting Unique Entries In A List
nice resource
http://www.cpearson.com/excel/Duplicates.aspx
Latest Macromedia News
Monday, October 26, 2009
Excel : Various Methosd to find Duplicate Data In Lists
Excel's Conditional Formatting tool to highlight duplicate entries in a
list.
list.
Saturday, October 24, 2009
Randomly Reordering an Array
Randomly Reordering an Array,One quick and dirty way to do this is to
step through the array one element at a time, randomly picking a
number betweenthe upper and lower bounds of the array, and swap the
value of the element of the array at the current position with the
element of the array at the position of the randomly selected number.
step through the array one element at a time, randomly picking a
number betweenthe upper and lower bounds of the array, and swap the
value of the element of the array at the current position with the
element of the array at the position of the randomly selected number.
<%
'****************************************
' This function randomly reorders the
' array aArray using a quick and dirty
' approach... It's fast!
'****************************************
Function ReOrderArrayQuickNDirty(ByVal aArray)
Dim iUpper, iLower, iLoop, iSwapPos, varTmp
iUpper = UBound(aArray)
iLower = LBound(aArray)
Randomize Timer
'Loop through the array, randomly swapping values
For iLoop = iLower to iUpper
'Get an array index to swap
iSwapPos = Int(Rnd * (iUpper + 1))
'Swap the current element with the element at iSwapPos
varTmp = aArray(iLoop)
aArray(iLoop) = aArray(iSwapPos)
aArray(iSwapPos) = varTmp
Next
ReOrderArrayQuickNDirty = aArray 'Return the jumbled array
End Function
Dim aSites
ReDim aSites(2)
aSites(0) = "4GuysFromRolla.com"
aSites(1) = "ASPMessageboard.com"
aSites(2) = "ASPFAQs.com"
'Display the array in-order
Dim iLoop
For iLoop = LBound(aSites) to UBound(aSites)
Response.Write aSites(iLoop) & "<BR>"
Next
response.write "<P>"
'Jumble up the array and display the new, random order!
aSites = ReOrderArrayQuickNDirty(aSites)
For iLoop = LBound(aSites) to UBound(aSites)
Response.Write aSites(iLoop) & "<BR>"
Next
%>
Monday, October 19, 2009
Free font download site with preview of your own text
Free font download site with preview of your own text
Tuesday, October 13, 2009
Wednesday, September 30, 2009
MySQL Realtime Replication - how to replicate mysql in realtime
BlankUseful link when i dig in research of database.
http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html
http://www.megalinux.net/archives/000170.html
ref: http://www.astahost.com/info.php/Mysql-Realtime-Replication_t2094.html
Monday, September 21, 2009
Javascript code for opening the popup and close the parent window without confirm prompt menu in html
BlankJavascript code for opening the popup and close the parent window
without confirm prompt menu in html
without confirm prompt menu in html
-------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script>
function openWindow(){
var browser=navigator.appName;
if (browser=="Microsoft Internet Explorer"){
window.opener=self;
}
window.open('popup.html', 'null',
'width=900,height=750,toolbar=no,scrollbars=no,location=no,resizable =yes');
window.moveTo(0,0);
window.resizeTo(screen.width,screen.height-100);
//parent.close(); //Closing on the child
}
</script>
</head>
<body onload="window.open('','_parent','');openWindow()">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td>If the window does not open, please turn off the pop-up blocker for this
site and <a href="#"
onClick="window.open('','_parent','');openWindow()"><u>click
here</u></a></td>
</tr>
</table>
</body>
</html>
---------
Saturday, September 19, 2009
Dhtml Code for IE browser, to popup or new window with Fullscreen after 5 seconds on page load.
Dhtml Code for IE browser, to popup or new window with Fullscreen
after 5 seconds on page load.
after 5 seconds on page load.
<html><head>
<script type="text/javascript" language="JavaScript">
function timedMsg()
{
//var t=setTimeout("alert('5 seconds!')",5000);
var t=setTimeout(EvenFullerScreen,5000);
}
function EvenFullerScreen(){
window.open("http://www.google.com","Aaarrgh","fullscreen ");
}
</script>
<title>FullScreen</title>
</head>
<body onLoad="javascript: timedMsg();">
Dhtml Code for IE browser, to popup or new window with Fullscreen
after 5 seconds on page load.</body></html>
Subscribe to:
Posts (Atom)
Adobe News
