excel-2016-CodePudding

Tags > excel-2016

09-07NetSorting comma-delimited string alphabetically in a smart way
09-06databaseMap excel values by category
08-20OSExcel VBA: UDF to check if a 2nd Excel workbook, open in another instance/application of excel, with
08-19MobileExcel VBA: UDF results in #NAME? error when called from cell
08-12OSFill the blank rows of sheet1 with the rows in sheet2
08-09Software engineeringHow to retrieve the last value of a column and print it in the same column in Excel
07-22EnterpriseTrying to SaveAs excel workbook using VBA and specific network path
07-20OSCan't export report to .xls anymore in MS Access?
07-17OSHow to ignore the invalid data when using =rank() function
07-05otherMapping two columns based on common/key column
06-08MobileExcel - how to check if Sheet1 includes only allowed characters defined in Sheet2
05-18BlockchainUse VLOOKUP as criteria inside COUNTIFS
04-19OSIs there an excel formula that looks at a column of duplicates and returns the value next to the low
04-05databaseHow to read/set Excel Textbox property from MS-Access VBA
04-05NetFind all code combinations using text string in Power Query
02-24Software designGetting HTML formatted text from VBA to the Outlook appointment body
12-13databaseAvoid Excel Chart streching line till end after series flattens
12-13Software engineeringExcel Chart is streaching line till end
12-05BlockchainEXCEL If cell in sheet1 equals specified value, populate the members name in sheet2
11-23Software engineeringHow to save as a excel file using AppleScript
11-20OShow to add border to a range of cell using AppleScript
11-18OSHow to extract multiple numerical values in the middle of a text in excel?
11-16otherIs there a way to have use v lookup or a different formula with duplicate lookup but different row v
11-05OSHow to highlight row in excel when no specific texts are on specific columns
10-27databaseExcel Finding matching values in a column and comparing the values in another column to one another
10-24Software engineering'Text to column' delimit function but for multiple cells
10-20NetVBA-Open a specific file when the file name keeps changing with the date
10-14Software engineeringSum values using lookup table, where lookup values are a list of values with comma delimiter
10-13NetExcel transform data