Excel Tips
Use a Built-in Data Entry Form »
November 7, 2022
I need to do data entry in Excel. I have a lot of records to key or to edit. Can I easily create a dialog to help with this?
Add a Customer Number to Each Detail Record »
November 4, 2022
I’ve imported a data set where the customer information appears once in column A, followed by any number of invoice detail records. At the end of the first customer, the next customer number is in column A and then there are detail records for that customer. You can not sort this data. The customer information needs to be in its own columns on each record.
Deal with Data in Which Each Record Takes Five Physical Rows »
November 3, 2022
Sometime, back in the days of COBOL, a programmer was dealing with the constraints of the physical width of a page. The programmer built a report in which each record actually took up five lines of the report. I want to be able to analyze this data in Excel.
Add a Group Number to Each Set of Records That Has a Unique Customer Number »
November 2, 2022
I have a list of invoice data. I want to number the records in such a way that the invoices for the first customer all have a group number 1 and the invoices for the next customer all have a group number 2.
Number Each Record, Starting at 1 for a New Customer »
November 1, 2022
I have a list of invoice data. I want to number the records in such a way that the first invoice number for Ford is 1. The next Ford invoice is 2, and so on. When I get to a new customer, I want to start over at 1.
Find Differences In Two Lists »
October 31, 2022
I have two lists that should be identical. I need to highlight any cells that are different.
Protect Cells That Contain Formulas »
October 28, 2022
I have to key in data in a large number of cells in a month-end financial statement. I don’t want to accidentally key in a number in a cell that contains a formula. How can I protect just the formula cells?
Preview Remove Duplicates Without Removing Them »
October 27, 2022
I want to preview which rows will be deleted before deleting them with Remove Duplicates.
October 26, 2022
I have a data set in which I would like to find every unique combination of customer and product.