excel-formula 219

  1. How to create strings containing double quotes in Excel formulas?
  2. Shortcut to Apply a Formula to an Entire Column in Excel
  3. Check whether a cell contains a substring
  4. Return empty cell from formula in Excel
  5. How to keep one variable constant with other one changing with row in excel
  6. How can I perform a reverse string search in Excel without using VBA?
  7. Error in finding last used cell in VBA
  8. Remove leading or trailing spaces in an entire column of data
  9. Excel Date to String conversion
  10. Simple Pivot Table to Count Unique Values
  11. Excel formula to reference 'CELL TO THE LEFT'
  12. How do I recognize “#VALUE!” in Excel spreadsheets?
  13. How can I color dots in a xy scatterplot according to column value?
  14. Convert date field into text in Excel
  15. How do I combine the first character of a cell with another cell in Excel?
  16. In excel how do I reference the current row but a specific column?
  17. In Excel, how do I extract last four letters of a ten letter string?
  18. Split Uppercase words in Excel
  19. SUMIF with OR criteria
  20. How to get unique values in a column using excel formula
  21. Coloring complete Row based on values from Columns
  22. Excel - Match substring from list of choices - INDEX, MATCH, and FIND used together
  23. Getting the last non-empty cell in a row
  24. How to make a reference to a cell of another sheet, when the sheet name is the value of a cell?
  25. In Excel how to get the left 5 characters of each cell in a specified column and put them into a new column
  26. Dot product between row vectors by MMULT not working in Excel
  27. How do I get my formula to always reference to the last sheet?
  28. Excel SUMIF when another cell contains text
  29. Return the row number if value is between two values in excel
  30. Can I make a structured reference absolute in excel 07?
  31. Can I use COUNTIF on two columns to compare values?
  32. Change background color of the row or range if a particular cell value is equal to some text
  33. referencing sheets by number instead of name in cells
  34. determine the cell holding the longest string with excel
  35. Automatically increment sheet reference when dragging formula
  36. Excel: Leading Zeros on Dates.. Formula to do it for me?
  37. Excel MAXIF function or emulation?
  38. Transposing data from column to row using references
  39. Shorter version of IF(ISERROR(…))
  40. Unable to assign formula to cell range in Excel
  41. How do get the index of a table's column by using a structured reference in excel?
  42. Look up a value in a table based on two input values
  43. Retrieving Values From Excel Merged Columns
  44. Using Cubeset To Create Top 10 Items List For a Specified Time Period
  45. How to recursively append cells?
  46. How to trace indirect precedents in Excel?
  47. Excel - Create dynamic sum formula range
  48. Is it possible to do a Levenshtein distance in Excel without having to resort to Macros?
  49. Excel VBA Function update only on change
  50. Refer to Excel workbook by path, based on cell value data