SysBlog » Razno https://blog.interakt.hr ...mic po mic... Tue, 24 Mar 2026 11:53:38 +0000 en hourly 1 http://wordpress.org/?v=3.1.2 EXCEL: Use VLOOKUP to Match Data from two Different Sheets https://blog.interakt.hr/?p=906 https://blog.interakt.hr/?p=906#comments Fri, 06 Oct 2023 11:13:55 +0000 SysBlog http://blog.interakt.hr/?p=906 =VLOOKUP(A2;Sheet1!A:D;4;FALSE)

Find match of the A2 from Sheet1 in column A of Sheet2, return value of column D of Sheet2. Number 4 is index of column D in sheet2

=IF(ISERROR(VLOOKUP(A2; Sheet1!A:D; 4; FALSE)); "No Match"; D2 - VLOOKUP(A2; Sheet1!A:D; 4; FALSE))

if A2 is not in the sheet2 then “No Match”
if D2 from sheet1 = D from match in sheet2 then 0
if D2 from sheet1 <> D from match in sheet2 then display difference in values (X-Y)

]]> https://blog.interakt.hr/?feed=rss2&p=906 0 Excel: Find duplicates in column https://blog.interakt.hr/?p=880 https://blog.interakt.hr/?p=880#comments Fri, 15 Oct 2021 13:50:04 +0000 SysBlog http://blog.interakt.hr/?p=880 Conditional Formatting > Highlight Cells Rules > Duplicate Values]]> Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values

]]> https://blog.interakt.hr/?feed=rss2&p=880 0 Excel – Remove Formulas From Worksheet But Keep The Values https://blog.interakt.hr/?p=866 https://blog.interakt.hr/?p=866#comments Mon, 14 Jun 2021 04:50:17 +0000 SysBlog http://blog.interakt.hr/?p=866
  • Copy
  • Paste values

    • :)

    ]]>     https://blog.interakt.hr/?feed=rss2&p=866 0     CKEditor – FontAwesome tags removed https://blog.interakt.hr/?p=863 https://blog.interakt.hr/?p=863#comments Sun, 13 Jun 2021 12:26:00 +0000 SysBlog http://blog.interakt.hr/?p=863  

    add to config.js, upload and refresh (clear cache using ctrl+F5)

    config.protectedSource.push( /<i class[\s\S]*?\>/g );
config.protectedSource.push( /<\/i>/g );

    

    source: https://ckeditor.com/old/forums/CKEditor/FontAwesome-tags-removed-when-switching-between-Source-and-Wysiwyg

     

     

    ]]>     https://blog.interakt.hr/?feed=rss2&p=863 0     ASP: web config http to https redirection https://blog.interakt.hr/?p=857 https://blog.interakt.hr/?p=857#comments Thu, 10 Jun 2021 07:03:30 +0000 SysBlog http://blog.interakt.hr/?p=857 <clear /> <rule name="Redirect to https" stopProcessing="true"> <match url=".*" /> <conditions> <add input="{HTTPS}" pattern="off" ignoreCase="true" /> </conditions> <action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Permanent" appendQueryString="false" /> </rule>

    source: https://stackoverflow.com/questions/9823010/how-to-force-https-using-a-web-config-file

    ]]>     https://blog.interakt.hr/?feed=rss2&p=857 0     Excel – compare two or more columns https://blog.interakt.hr/?p=823 https://blog.interakt.hr/?p=823#comments Tue, 16 Jun 2020 15:45:55 +0000 SysBlog http://systasis.biz/blog/?p=823 =IF(AND(B78=P78;C78=Q78;D78=R78;E78=S78;F78=T78);"DA";"NE")

    … and dragg…

    https://www.ablebits.com/office-addins-blog/2015/08/26/excel-compare-two-columns-matches-differences/

    https://support.microsoft.com/en-us/office/using-if-with-and-or-and-not-functions-d895f58c-b36c-419e-b1f2-5c193a236d97?ui=en-us&rs=en-us&ad=us

    ]]>     https://blog.interakt.hr/?feed=rss2&p=823 0     ASP: web.config redirect https://blog.interakt.hr/?p=790 https://blog.interakt.hr/?p=790#comments Thu, 31 Oct 2019 10:53:18 +0000 SysBlog http://systasis.biz/blog/?p=790 <system.webServer> <httpRedirect enabled="true" destination="http://www.google.com/" /> </system.webServer> ]]> https://blog.interakt.hr/?feed=rss2&p=790 0 JQuery – text selektirane opcije iz liste/menua https://blog.interakt.hr/?p=430 https://blog.interakt.hr/?p=430#comments Mon, 12 Jan 2015 16:00:33 +0000 SysBlog http://systasis.biz/blog/?p=430 Problem: Zanima nas tekst, a ne vrijednost selektirane opcije menua #pero

     

    Rješenje: 

    $('#pero option:selected').html()
    ]]>     https://blog.interakt.hr/?feed=rss2&p=430 0     Classic ASP/ADO – recordcount alternativa https://blog.interakt.hr/?p=192 https://blog.interakt.hr/?p=192#comments Thu, 31 May 2012 22:39:13 +0000 SysBlog http://systasis.biz/blog/?p=192 Problem:
    kako jednostavno dobiti recordcount, a da se ne igramo sa kursorom

    Rješenje:

    
svi_redovi = Rs.GetRows()
 RecordCount= UBound(svi_redovi, 2) + 1
 Rs.movefirst
    ]]>     https://blog.interakt.hr/?feed=rss2&p=192 0