When adding library dependencies, make sure they dlls are targeting the same .Net framework as the project. took me ~12 hours to figure out that i was using a dll with 4.5.2 in place of 4.5. couldnt figure out wth was going on, why the build was failing
A repo of code snippets ..
...this is a log of code snippets and useful tips I wrote/found. Should you find any mistakes or have any useful suggestions, please do not hesitate to write to me.
Wednesday, June 28, 2017
Friday, June 16, 2017
ubuntu login loop while nvidia driver update
got into a login loop, when i updated my nvidia driver. not sure what fixed the issue. But i just uninstalled and reinstalled the driver from the shell and the login loop was gone.
Monday, April 24, 2017
Filtering in excel using a list of values
https://www.extendoffice.com/documents/excel/3186-excel-filter-rows-by-list.html
Wednesday, March 8, 2017
Monday, February 6, 2017
Most frequently occuring data in a row
=INDEX(B2:D2,MODE(MATCH(B2:D2,B2:D2,0)))
can be used for example to count votes
can be used for example to count votes
Splitting a colum into multiple columns Excel
=INDIRECT("Sheet1!R" & (ROW()-1)*3+1 & "C1", FALSE)
Say you have a long oclumn of data. You want to split it into 3 columns such that, every third element goes into each column. for example youd data is: AAABBBCCCDDDEEEFFFGGGHHH
you want to split into 3 columns : ABCDEFGH, ABCDEFGH, ABCDEFGH. use the above formula
Say you have a long oclumn of data. You want to split it into 3 columns such that, every third element goes into each column. for example youd data is: AAABBBCCCDDDEEEFFFGGGHHH
you want to split into 3 columns : ABCDEFGH, ABCDEFGH, ABCDEFGH. use the above formula
Subscribe to:
Posts (Atom)