asked
I have a large Excel spreadsheet with over 500,000 rows and 17 columns of data. Each row represents a different instance of an individual with a different job function code in column D. I want to sort and filter individuals based on specific job function codes, including those who have a certain code and exclude those who have another. For example, I want to pick out individuals with a job function code 'AH' in column D but exclude those who also have 'LI'. How can I achieve this using a conditional formula or another method in Excel?
November 26th, 2023
My computer with Windows 2000 is not displaying backgrounds, including website backgrounds and desktop wallpapers. The display settings show that all wallpapers are locked, and I cannot select new ones. Additionally, the text is displayed in giant letters, and some text appears scrambled and overlapped. I have a malware alert mentioning 'antivermins.' What software should I use to resolve this issue?
September 5th, 2024
Error: Unexpected error occurred
July 5th, 2024
What is the difference between computerized accounting and manual accounting?
July 10th, 2023
I need help with installing computer printers and other equipment in my new flat in Petersfield, Hants. Is there anyone interested in coming to my flat to connect everything for me?
August 27th, 2023
I have a Toshiba Satellite Pro 425CDT laptop that allows swapping the 3-1/2 floppy drive with a CD drive. After replacing the floppy drive with a CD drive, the computer did not recognize the CD drive and continued to show the no longer present floppy drive in My Computer. I ensured the connections were solid. What's wrong, and how do I fix it?
June 4th, 2024