excel-formula 55

  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. Excel: last character/string match in a string
  7. Error in finding last used cell in VBA
  8. How can I perform a reverse string search in Excel without using VBA?
  9. Remove leading or trailing spaces in an entire column of data
  10. Simple Pivot Table to Count Unique Values
  11. Excel Date to String conversion
  12. Get content of a cell given the row and column numbers
  13. Getting unique values in Excel by using formulas only
  14. Ignore Duplicates and Create New List of Unique Values in Excel
  15. How does one sum only those rows in excel not filtered out?
  16. How do I recognize “#VALUE!” in Excel spreadsheets?
  17. Declaring variables in Excel Cells
  18. Using “If cell contains #N/A” as a formula condition.
  19. Excel how to find values in 1 column exist in the range of values in another
  20. Pass row number as variable in excel sheet
  21. How do I convert a Unix epoch timestamp into a human readable date/time in Excel?
  22. In Excel, sum all values in one column in each row where another column is a specific value
  23. How can I color dots in a xy scatterplot according to column value?


  24. Count if two criteria match - EXCEL formula
  25. Converting time stamps in excel to dates
  26. Convert date field into text in Excel
  27. Using the value in a cell as a cell reference in a formula?
  28. How do I combine the first character of a cell with another cell in Excel?
  29. How to loop in excel without VBA or macros?
  30. Return values from the row above to the current row
  31. Batch string concatenation in Excel
  32. Sum up a column from a specific row down
  33. Simulate string split function in Excel formula
  34. Format numbers in thousands (K) in Excel
  35. Refer to a cell in another worksheet by referencing the current worksheet's name?
  36. Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
  37. Excel issue “excel 4.0 function stored in defined names”
  38. Sum where value is x
  39. Three Dimensional Lookup Using INDEX/MATCH
  40. Count Unique values with a condition
  41. Excel formula to remove space between words in a cell
  42. Padding a word with spaces to fill a cell
  43. How to create running total using Excel table structured references?
  44. Excel Macro, inserting internationally valid formula during run-time
  45. Formula in Excel to count occurrences of substrings within strings
  46. What algorithm does Excel use to recalculate formulas?
  47. Filling any empty cells with the value above
  48. How to make a reference to a cell of another sheet, when the sheet name is the value of a cell?
  49. Excel: Perform a SUMIF where the criteria is a comma-delimited list
  50. Excel date format - quarter & year