Counting Unique Values And Displaying Text
In column A, rows 1 to 500 I have a list of Customer names.
The Customer names can be repeated.
In column B I would like a formula that would cause the text "Initial Order" to be printed if this was the first time that customers name appeared in the list
and if it appeared thereafter the text "Reorder" would be printed.
To clarify, cell A7 contains the name "John Smith".
That name does not appear in calls A1 to A6.
IN that case I would like the text "Initial Order" to appear in cell B7.
Assuming the name "John Smith" appears in cell A72 then I would want the text "Reorder"
to appear in cell B72.
I plan to keep adding values to column A so this spreadsheet will continue to grow over time.
Anwsers to the Problem Counting Unique Values And Displaying Text
Assuming that you have header labels in row 1, put this formula into B2,
=IF(COUNTIF(A$2:A2,A2)=1,"Initial Order", "Reorder")
and fill down as far as necessary.
If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.
Recommended Method to Fix the Problem: Counting Unique Values And Displaying Text:
How to Fix Counting Unique Values And Displaying Text with SmartPCFixer?
1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will scan your system. The errors will be shown in the list.
2. After the scan is finished, you can see the errors and problems which need to be repaired.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.
Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.22.214.171.12486,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.126.96.36.1990,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.188.8.131.529,Method to Update & Download ASUS K41VD Intel INF Update Driver v.184.108.40.2065,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Fast Solution to Problem: Count # of Dates between a Range,Corrupt user account not allowing access to Excel 2013? Tech Support,Tech Support: Ctrl C & Ctrl V not working on Windows 7 using Office2010,How to Fix Problem - COUNTIF multiple criteria, but do not count twice?,Troubleshoot:Corrupted Download of Windows 7 RC Error,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly