Search results 40

Sorted from new to old.

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

Dec4

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

Jul15

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

Feb10

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

Dynamic iframe height

Adjust iframe height to its content after loading page Needed this trick in ...

2023Apr29

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Window and screen sizes in jQuery

Get the size of the screen, current web page and browser window using jQuery ...

2021Mar18

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

1 2 3