I would like to find a way to find the names from LIST 2 in LIST 1 (see lists below), mark them in some color, and pull any additional information in the next column. IS that a difficult formula?
Please note that the names from LIST 1 are mixed with other words or are low caps, yet are still...
Hello, I am confronted with a file with over 1000 records of invoice numbers and customer numbers, I would like to find out if there is a formula that could detect the missing invoice numbers or the missing customer numbers. Please note that these numbers are all system generated and are...
Hi Everyone,
Can you help me define a formula that will check the contents of 3 or 4 cells from different columns to see if the data in that raw repeats (duplicates) anywhere else in the file (3 or 4 columns)? For instance:
Columns A Column B Column C Column D...
Hi folks,
For a long time I have been using a simple formula that helps me detect and filter out duplicate records as in a accounts payable (duplicate invoices or payments) or an accounts receivable file with duplicate invoices or amounts, etc. The formula I have been using is...
Hi Chandoo, hope my note finds you well.
My question today has to do with something I have tried but can not find a way to resolve. I want to extract digits from a set of numbers (both negative or positive). For instance, take as an example the below set of amounts:
A) $12,340.67
B)...
Hi Chandoo,
I am curious if it would be possible to create a chart that would display a picture, symbols, or numbers instead of the numbers? I was trying to figure a way to display numbers rather than the usual bars on a graph as is shown on the following site...