Comparing excel lists
Use following formula to determine whether a value in one column is in another column and if not then return 1
=IF(IFERROR(MATCH(A2,B$2:B$4117,0),-1)=-1,1,”")
Archive for October 2008
Removing tabs in excel cells
Sometimes when you are preparing your internet marketing data for upload to your site you need to remove tabs from you site so your database etc does not get confused
use the excel clean() function
Excel write limit
This is a useful macro but be aware that the field limit is 1028 characters!
Excel reversing digits
Sometimes when you are using internet marketing you need to understand difficult functions in excel to keep you one step ahead of the competition. This one entered as an array reverses the digits in a number.
=SUM(VALUE(MID(A1,ROW(INDIRECT(”1:”&LEN(A1))),1))*10^(ROW(INDIRECT(”1:”&LEN(A1)))-1))
Generally this works fine except for when number ends withn zero