Learn Microsoft Excel Online FreeThis post will guide you how to separate negative numbers and positive numbers from a column into two columns with a formula in Excel. How do I split numbers into two columns with negative and positive numbers in Excel. Splitting Columns to Separated Positive and Negative Numbers Assuming that you have a list of data… read more »
This post will guide you how to transpose data from rows to column with a formula in Excel. How do I transpose every N rows from one column to multiple columns in Excel. Assuming that you have a list of data in range A1:A10 in column A, and you want to transpose every 2 rows… read more »
This post will guide you how to get row number from a Vlookup in Excel. How do I return a row number from a Vlookup with a formula in Excel. Assuming that you have a list of data in range A1:B5, you can use the VLOOKUP function to lookup a value in the first column… read more »
This post will guide you how to count the number of checked checkboxes in your worksheet in Excel. How do I Count or sum all cells with checked boxes with a formula in Excel. Count or Sum Cells with Checked Box Assuming that you have a list of data in range A1:C5, in which contain… read more »
This post will guide you how to find the first value greater than a specified value in a range of cells in Excel. How do I find the last value greater that a given value in a row with a formula in Excel. Find the Last Value Greater Than X Find the First Value Greater… read more »
This post will guide you how to move every other row to a new column in Excel. How do I move every odd row to another column with formula in Excel 2013/2016. How to move every even row to other column in Excel with VBA Macro in Excel. Move Every Other Row to New Column… read more »
This post will guide you how to extract time portion from a date and time in Excel. How do I remove date on Date/Time Stamp with a formula in Excel. How to remove date from a date and time value with find and replace feature in Excel 2013/2016. Extract Time from a Date and Time… read more »
This post will guide you how to transpose horizontal list to vertical list in your current worksheet in Excel. How do I convert horizontal rows to vertical columns with a formula in Excel 2013/2016. Convert Horizontal List to Vertical with a Formula Convert Horizontal List to Vertical using Paste Special Feature Assuming that you have… read more »
This post will guide you how to filter values starts with number or letter in one single cell in Excel. How do I filter in a list those that begin with number or letter using a formula in Excel. Filter Cells Starts with Number or Letter Assuming that you have a list of data in… read more »
This post will guide you how to count values in a single cell separated by commas with a formula in Excel. How do I count comma separated values in one cell in Excel 2013/2016. Is it possible to have a formula that can count the amount of values separated by commas in a single cells… read more »
