Automatically fill in a column based on information in other colums
This is what I'm trying to do automatically as I have tens of thousands of lines (using an example to make it simple):
I have a download of order history that contains one line for each SKU on the order. I want to be able to catorgorize them based on the SKU. In this example, Apples are on special. I need to know the total number of orders, the number of orders where
only the apples were bought and finally the total number of orders where apples plus an additional product was bought. What can I do to automatically assign a type (column C) to the row based on the above scenarios?
Keys to the Problem Automatically fill in a column based on information in other colums
Try this formula in cell D2 and copy down
=IF(COUNTIF($A$2:$A$14,A2)>1,IF(COUNTIFS($A$2:$A$14,A2,$B$2:$B$14,"apple")>=1,"Special Plus","No Special"),IF(B2="apple","Special","No Special"))
Given 65000 rows of data, there will be performance issues, so please copy and paste in chunks.
Hope this helps.
- Go to the Start button.
- In the Search box, type "regedit" (without quotes) and press Enter.
- Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
- On the right window pane, delete the subkey: "Machine Throttling".
- Reboot your system.
Another Safe way to Fix the Problem: Automatically fill in a column based on information in other colums:
How to Fix Automatically fill in a column based on information in other colums with SmartPCFixer?
1. Download Error Fixer. Install it on your system.
2. After the scan is finished, you can see the errors and problems which need to be repaired.
3. The Repair part is finished, 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: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: [Solved] attach dates in excel to a stock programe,Fast Solution to Error: Back up fails log shows corrupted files but diagnostics show nothing,Troubleshooter of Error: Backup to network drive asking for password,Solution to Problem: Automatic log in through Wireless Network Bridge,Fast Solution to Error: Backcolor of a button in Excel2007,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?