Wednesday, April 27, 2016

Bernie or Bust

This primary is absolute proof of how money corrupts politics. It shows how even a system rigged for the GOP can help corporate democratic puppets like Hillary Clinton win the nomination, even when it is painfully obvious that Americans are sick and tired of the system. Clinton says she has the majority of the votes, but does she really? When she has a historic unfavorable rating, where GOP voter ID laws deny millions of Americans their vote, in states where polling places are cut to less than half of what is needed, where independents are being denied to vote in closed primaries because of computer errors. She's winning because of a system the GOP built to keep progressive like Bernie Sanders out. She winning because mainstream media would rather show empty podiums instead of Bernie Sanders speeches. She winning because money corrupts and the system is rigged. If Trump wins it will be a disaster, but if Clinton wins nothing will change and progress will be denied yet again. I'm tired of voting for the lesser of two evils, it does not work. Which is why if it comes to Clinton or Trump, I will not be voting for either. Instead I will write-in Bernie Sanders, because this is my vote and I will vote for who I believe deserves my vote.

Saturday, December 10, 2011

Auto-fill forms from data in Excel - Challenge Accepted!

Recently a co-worker asked me if it was possible to have cells in Excel auto-fill from data records on another excel sheet without programming. Similar to the auto-fill forms you see in your browser, where you enter your name and the browser automatically fills the rest of your information, like address or phone number.

So you'll go from this:






To this with just a click:






I had no idea if this was possible, I don't exactly remember being taught this at school. So I figured I look into it. Challenge Accepted! After many a Google search I found nothing on this. So if there is a function for it, I haven't found it. So after about an hour of playing around with Excel functions, I came up with this:

=IF(ISERROR(INDIRECT(ADDRESS(MATCH(A,B,0),C,4,TRUE,"SHEET"))),"",INDIRECT(ADDRESS(MATCH(A,B,0),C,4,TRUE,"SHEET")))

SHEET = Name of the sheet containing the data
A = Cell containing data to compare to SHEET. (A1, B2, etc.)
B = Name of array holding the data on SHEET.
C = Column holding Data.

Here a sample if you want to see it work. temp.xlsx It simply looks at the Name column cell and compares it to a list in a already filled out table on SHEET, and prints out whatever is in C. The IF and ISERROR function are used to keep the cell clear in case of an error, makes it look prettier. Since leaving the Name cell empty would return an error.




Subscribe
Google Reader or Homepage Subscribe