Search results 59

  2. Search results
  3. excel formula
Sorted from new to old.
Card image
ANmaRemoveDuplicates2

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

2024Dec4
Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10
Card image
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10
Card image
Excel clipboard bug

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

2023Dec27
Card image
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20
Card image
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25
Card image
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10
Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11
Card image
ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2
Card image
Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7
Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18
Card image
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12
Card image
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1
Card image
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24
Card image
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6
Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4
1234