Dmitry Pavliv questions

Dmitry Pavliv answers

• How to find the maximum value in entire Excel workbook
• Use comma instead of dot for decimals when saving as text
• Determining median values with nested IF and AND array formulas
• Excel Pick random value in range that is between dates
• Excel formula to check if a range of data are all exactly same
• Searching over multiple columns in excel vba
• Excel VBA wildcard search
• ByRef Argument type mismatch with Boolean
• Excel VBA: Copying multiple sheets into new workbook
• Can you use a variable for the Field name when using AddNew to a record set?