SysBlog

=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)

Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values

1. Copy
2. Paste values

:)

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

                <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

=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

<system.webServer>

<httpRedirect enabled="true" destination="http://www.google.com/" />

</system.webServer>

Problem: Zanima nas tekst, a ne vrijednost selektirane opcije menua #pero

Rješenje:

$('#pero option:selected').html()

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