Placing the Previous Payment Date beside Each Pay Date in a List

Problem: Columns A & B contain Client ID's and their recent payment dates. We want to add the date of the previous payment from the same clien...

Repeat entries in a column

If you have entries like these in a column which need to be repeated a certain number of times (for e.g. 4 times), try the formula given below the tab...

Rounding Numbers that Meet Specified Criteria

Problem: Rounding all the numbers in column A to zero decimal places, except for those that have "5" in the first decimal place. Solution: Us...

Forecasting Daily Budget

Tip submitted by: Matt, San Diego, CA Place todays date in cell A1, press Ctrl+; Example: 3/9/2005 Place a dollar amount in cell A2: 500.00...

Finding the Largest Number among Those Meeting Specified Criteria

Problem: Column A contains 5-digit numbers. We want to find the largest number from the list whose first two digits are "11". Solution: Use ...

Counting values meeting multiple criteria in different columns

Problem: Counting the number of "red" items which cost less than $1000. Solution: Using the SUMPRODUCT function to count the number of items ...

Copying a Formula from a Cell While Keeping the Reference in Excel 2007

Avoid the nightmare of toggling through the combinations of the F4 key when coping and pasting formulas. To copy/paste a Formula without keeping th...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube