How to obtain a true or false statement if a customer is a repeat customer
Requirement:
The user wants to obtain a True or false statement if a customer is a repeat customer over 2 other sheets. e.g below:
| Sheet 1 Column A | Sheet 2 Column A |
| [email protected] | [email protected] |
| [email protected] | [email protected] |
| [email protected] | [email protected] |
| [email protected] | [email protected] |
| [email protected] | [email protected] |
Current sheet
| A | B |
| [email protected] | True |
| [email protected] | True |
| [email protected] | True |
| [email protected] | False |
Solution:
=COUNTIF('Sheet1'A:A,A2)+COUNTIF('Sheet2'!A:A,A2)>0
Copied down
Where first entry in current sheet is in A2
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to obtain True/False statement if times are within x minutes of each other |
| How to use COUNTIF to see if a customer is a repeat customer |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Intellectus nuotoliniai anglų kalbos kursai internetuGallery
