How to Separate Text and Numbers Using Formulas?...

Compare a number array with existing records in Excel or VBA...

Excel Pivot Table - Turn two columns with same values into a matrix pivot table with column names as...

How to copy merged cells with VBA...

"Autocorrect format" for all values in a column (instead of line by line)...

Excel calculating different dates using same formula, between server and local installation...

How to create a table that gets data from multiple tables in separate worksheets and consolidate the...

How can I get today's date in a cell in dd/mm/yyyy format?...

How to check if the first 3 cells are greater than the other first 3 cells in two tables...

How do I Put in a pass through Table name so the Macro isn't bounded to the one worksheet?...

How can I control column number in Excel INDEX function based on criteria?...

How to remove duplicates that are case SENSITIVE in Excel (for 100k records or more)?...

How to filter only first row in sets of data on Excel 2016...

Excel column A same value and column B value combine in Column D...

removing invisible character in excel...

User prompt to select a specific workbook and specific sheet within that workbook to cut and paste i...

Adding Horizontal and/or Vertical borders with VBA...

MS excel 2016 formula for booking calendar...

Compare two columns in excel with different lengths...

Excel determine previous Month and Year from an existing date...

FullCategoryCollection works only on first chart...

Problems with Index Match Array returning duplicates...

Power Querying numerous tables to combine all information into 1 table, then combine duplicate text ...

Conditional Formatting Formula to highlight all matching values found in another table...

Removing thick border when activex checkbox is not checked...

Setting the font size in a shape...

Trying to SaveAs excel workbook using VBA and specific network path...

If/or not returning true...

Remove duplicates with exception...

How to Update GUI/UserForm elements with Application Level Events?...