Excel Tips
November 11, 2022
Some people in my data set do not have middle initials. Flash Fill is putting periods between the first and last name for those people.
Data Cleansing with Flash Fill »
November 9, 2022
I need to join text or break apart text in Excel 2013.
Cell AutoComplete Stopped Working »
November 8, 2022
I am typing data in column A. When I type the first few letters in a cell, Excel suggests the complete entry and I only have to press Enter. Suddenly, AutoComplete is not working for one customer.
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.