Search results

As Marc Said + I am not expert in Access.

Mathematical formula for the SUM ((upper+1-lower)*(upper+lower))/2

What i suggest! Copy-paste or import data in excel & then use formula in layout to grab the values!! =IFERROR(VLOOKUP($A3,OFFSET($F$1,LOOKUP(,-1/($F$2:F3="rid"),ROW($D$2:$D3))-1,,5,4),COLUMN(),0),0)

Two alternatives! First : - Copy paste the formula & select Link Cells Second :- VBA

http://www.k2e.com/tech-update/tips/431-tip-fuzzy-lookups-in-excel

Ya! Pls compare the outputs.

Pls check

A comprehensive list of Excel 4 macro syntax and examples - in a free eBook. https://www.myonlinetraininghub.com/excel-4-macro-functions

Check it. Sub Json_Data() Dim http As New XMLHTTP60, html As New HTMLDocument Dim Argstring As String, str As Variant Dim N As Long, P As Long, vault As Variant, converted As String Dim p_val As Object, post As Object, posts As Object, elem As Object Dim source As Object...

I didn't find any country name in col C. Are u looking for VBA approach or formula!

Expected out is missing in xl buddy.

If your "Failing Values" will be like as below then it will ease else seems :p Failing Values -20, -21, -22, -23, 20 -22, -23, 22 - -22, -23, 22, 23 -20, -22, 20, 22 -22, -23, -24 - -20, -22, 20, 22 -21, -24, 21, 24 -22, 22 -22, -23, 22, 23 -23, 23

Expected output pls! Pls upload xl file with explanation!

A 2 Z Guide for date & time. https://www.myonlinetraininghub.com/excel-date-and-time Download files!! https://d13ot9o61jdzpp.cloudfront.net/files/excel_date_time.zip

I don't understand the issue behind the two words.Pls share a sample file.

Do you want to import all the rows to xl as same is not designed to store such large database. My recommendations- Either use Access or other software to filter the data in small parts.

I didn't understand the query but this might help. =MIN(C13,E13,G13,I13,K13)

Do you think we have direct access to your pc to open that link. Pls share a open link so that we can visualize it.

Sometimes collection objects are known by a extras 's' depending how same is written in coding language. Worksheet for a single sheet but worksheets for collection/array of sheets. Workbook for a single xl but workbooks for collection/array of xls. But range is not to be written as ranges...

Pls check it.

Check it.

Pls don't Duplicate the query but you can share the link. https://chandoo.org/forum/threads/userform-login-for-multiple-level-user-customized-spreadsheet.24485/#post-213987

Few more enhancement...

Sorry! There was typo error! Change it. For Each rng In Sheets(userDB).Range(SheetRange).Resize(1).Offset(myFind.Row - 2) If rng.Value <> "" Then If Evaluate("ISREF('" & rng.Value & "'!A1)") Then If Sheets(rng.Value).Visible <> -1 Then Sheets(rng.Value).Visible = -1...

Check it.