Delete duplicate records in sql server 2008 jobs

...experience in Power Apps and Power Automate • Experience in developing Canvas and Model-driven Power App applications • Experience in developing the applications connecting to SharePoint, SQL, Oracle and external APIs • Experience in building automation workflows using Power Automate Development 1. Hands-on Expertise in Power Platform • Expertise in design and develop custom business apps (Canvas Apps, SharePoint Form Apps, Model Driven Apps, Portals) • Expertise in implementing Power Automate Flows (Automated, Instant, Business Process Flow and UI Flows) • Expertise in DataVerse and Azure Databricks and MuleSoft 2. Experience implementing Collaboration Portals, Enterp...

I'm looking for a skilled developer to implement DTLS in C for secure communication within a tight deadline of two weeks. Key project requirements: - Implement DTLS in C: The primary goal of this project is to introduce DTLS to an existing system for secure communication. - Tight deadline: This project needs to be completed within two weeks. Timeliness and reliability are crucial. I need the data coming from the server to the client over UDP socket to be encrypted with DTLS, and it should appear as DTLS in the protocol section of Wireshark. In addition, the code should be able to handle streaming video or live feed over the socket accordingly. This code should work in linux and windows. Ideal Skills and Experience: - Proficiency in...

I am in search of a skilled developer to create a web dashboard using Python with Django framework. The purpose of the dashboard is to monitor a specific service. Admin can create new services or update / delete Ability to add commands to start a service if it crashes by using the commands and notify on successful execution. As well as provide web dashboard for visibility . If this service crashes, the dashboard should send notifications via email and then restart the service. Key Requirements: - Develop a Python-based web dashboard using the Django framework. - Implement a monitor for a specific service. - Configure email notifications to be sent out to a designated email address upon service crash. - Enable the dashboard to automatically restart the service upon crash...

I am looking for an expert who can help me set up a SIP trunk server using Twilio as the SIP provider. This server will be used for both voice calling and SMS messaging. Key Responsibilities: - Establishing a SIP trunk server with configurations optimized for Twilio - Implementing call management features like Call Recording, Call Forwarding, and Interactive Voice Response (IVR) - Ensuring seamless integration of both voice and SMS capabilities - Providing recommendations for server security and performance optimization Ideal Candidate: - Extensive experience with SIP trunking, particularly with Twilio - Proficiency in configuring and customizing SIP trunk servers - Proven track record in implementing call management features such as Call Record...

I'm in need of a virtual assistant to help manage my daily inventory data updates and email handling tasks. Responsibilities: - Daily Inventory Data Updating: You'll be responsible for keeping our inventory records up-to-date. This will include tracking stock levels, monitoring product movements, and ensuring all changes are accurately reflected in our system. - Email Handling: I need someone to manage my email correspondence. This will involve: - Responding to Customer Inquiries: You'll be required to engage with customers who reach out via email, answering their questions, and addressing any concerns they may have. - Managing & Organizing Emails: Your role will also involve organizing my inbox, ensuring nothing gets missed and that I'm ab...

I'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database management and SQL will be considered a plus.

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

I'm looking for a skilled Python developer with experience in web scraping and Selenium. Your task is to extract a domain list from a given URL (). The data extracted should be cross-referenced for each domain with the following fields: name, full address, email, and phone. Key Requirements: - Extract domain list from a specific website () - Implement cross-referencing for each domain with name, full address, email, and phone - Proficiency in Python and Selenium for web scraping - Ideally, experience with data cleaning and manipulation Please note that the number of records on the dealer locator is unknown. Your ability to handle large data sets will be crucial for the successful completion of this project.

NextGen is seeking an experienced IT professional or team to deploy a private email server on our internal infrastructure. The goal is to enhance security, ensure data privacy, reduce dependency on third-party email services, and customize the email system to meet our specific needs. The project will involve setting up the server, configuring DNS records, installing and configuring necessary software, securing the server, and ensuring seamless email access for all users. Key Deliverables: Infrastructure Setup: Set up a dedicated server or VPS with a static IP address. Configure necessary storage and network resources. DNS Configuration: Configure MX, SPF, DKIM, and DMARC records to direct email traffic to the server. Software Installatio...

I'm in need of a logo for my upcoming record label, 9 Acres Records. It's a small project, but I'm looking for a high-quality, professional design that captures the essence of my label. Here are the key requirements for the logo design: - Name: 9 Acres Records - Color: Green Grass - Style: *Sketchs & examples attached* Font MUST be in OLD English font Ideal Skills and Experience: - Experience in logo design, particularly for the music industry - Ability to deliver a professional, eye-catching design - Creativity and willingness to collaborate on ideas - Excellent understanding of color theory - Strong communication skills to ensure we're aligned on the design I want this logo to be the face of 9 Acres Records, so I'...

I'm seeking a skilled developer to make specific im...syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience working with PHP, particularly in customizing and enhancing applications. - A solid understanding of Qui...

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two plat...

...Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you to do) 6. Using the accounting system "Odoo" for better recording process A. The Ideal scenario is keeping all the records at the Odoo. 7. Advise and enhance better workflow in accounting with our colleagues. 8. Translation from the Chinese to English from both. “Advance Scope” (I hope you to do) 9. Recording in manner of Managerial Accounting (costing schedule by projects) 10. Communication with clients or vendors regarding accounting matters 11. Assisting the external Auditor, tax representative, and valuation 12. Analyzed the business trend an...

1. Issue Rural commodity growers face challenges in accessing markets due to high air and sea freight costs. To support these farmers and producer groups, our organization provides upfront funding for freight expenses. However, the existing process lacks a robust database system with simple bookkeeping features. We need a comprehensive solution that streamlines the entire process, ensures transparency, and automates accounting and reporting tasks. 2. Solution: Commodity Transportation and Funding App Key Features: User Registration and Application: Commodity growers, shipping companies, and airline carriers register through a user-friendly web interface. User details, including CRM data, are captured during registration. Freight Tracking and Reimbursement: Record transportation det...

I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

I'm in search of a professional and dexterous home assistant and sitter who can competently handle a number of responsibilities. It’ll be 6 days a week. And 3-5 hours per day. Tasks and Responsibilities: - Able to follow instructions. - Computer literacy. - Manage home. Home Management: In addition to the above, the successful candidate will assist with household inventory management, maintaining comprehensive records and ensuring that everything is in its rightful place. Ideal Skills and Experience: - Demonstrated experience in home sitting and assistance. - Exceptional organizational and management skills. - An eye for detail, especially when dealing with inventories. - Good communication skills. - Ability to follo...

...landing page From custom wording to a handcrafted cover, the Personalized High School Diploma for Homeschools is an official document to honor your grad! Homeschool Diploma The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. If you could duplicate the product on this page exactly as it is, I would be very happy. I do not need the review section on the bottom of page, only the product. Key Requirements: - Ensure the page is easy for me to update and maintain Please let me know if you've had experience with similar projects and how you plan to ensure that...

...data must be verified using third-party tools before submission. Only verified records will be accepted, and payment will only be issued for data that is verified to be accurate. Verification Process: After you have submitted the verified data, we will also be verifying the data ourselves to ensure the accuracy of the data. We will verify the email addresses through Zero Bounce, the phone numbers through Tele sign, the addresses through USPS Address Lookup, and will test all URLs and links to ensure they are accurate as well. Payment / Replacement Data: Once the data is verified, we will then release final payment, and if any of the contact details come back as invalid, we will request replacement data records. If this project is successful, we will have many more proj...

I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Yo...

I need a skilled professional to install Mail-in-a-Box on my RackNerd server. You should set up all the necessary DNS records and ensure the installation is fully secured by implementing a Secure Connection SSL / STARTTLS. Key Requirements: - Installation of Mail-in-a-Box on RackNerd server - Setting up all necessary DNS records - Implementing Secure Connection SSL / STARTTLS Ideal Skills and Experience: - Proven experience with Mail-in-a-Box installations - Strong understanding of DNS management - Expertise in SSL/TLS configuration - Prior experience with RackNerd servers The primary purpose of this project is for educational/nonprofit use, so your help in ensuring the security and functionality of this setup is crucial. Pl...

... employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides for the system architecture, API interfaces, and operational procedures. Provide ongoing support and troubleshooting to ensure system stability and user satisfaction. Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Abili...

I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and React - on the server. Additionally, you'll need to install Flutter and React Native apps. The ideal candidate should have advanced understanding and practical experience in Linux system administration, server administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. ---------------------------------------------------...

...although users should have the option to buy tickets without logging in. Admin Panel: - Should have access to make new lottery , modify lottery details (commissions, rewards, lottery time, how lottery will finish, payment address, which payment network) - Logs (payment success fail, hack tries) - See Lottary Pools and Modify results, - See Payments and Delete / Modify results Ideal skills and experience for this project include: - Proficiency in web development with a focus on cryptocurrency-based platforms. - Previous experience in creating raffle/lottery systems. - Strong knowledge of integrating external APIs, particularly with crypto payment gateways. - Understanding of user experience and security concerns in crypto transactions. - Fami...

I'm in need of a talented developer who can help me with implementing server-side rendering for my website. Website not rendering html right now so need to do server-side rendering. You are good if you can do that through anydesk or teamviewer. Yes, i can work with new freelancers, Just send me github profile so i can check what you've done. Start your application with "SSR", all other will be ignored.

...focused exclusively on houses and rooms for rent. The website should be responsive and user-friendly Key Features: User Account Creation: Users should be able to create personal accounts and log in securely. Account registration form should capture essential information (name, contact details, preferences, etc.). Property Listings: A comprehensive listings page displaying available houses and rooms for rent. Each listing should include detailed information (photos, descriptions, amenities, rental terms, etc.). Interactive Listings: A "React" button under each listing allowing users to express interest in a property. Upon clicking the "React" button, the user's interest should be sent directly to our email, including details about the specific ...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

...checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The system should generate reports in two ways: - **Downloadable PDF Reports**: The system should be able to generate downloadable PDF reports. - **Dashboard View**: There should be a dashboard within the system where the verification results can be viewed. Ideal Skills: - Experience in developing similar employee pre-verification systems. - Proficien...

...experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years be...

I need a CRM solution designed around the latest version of Odoo, Odoo 13 or Zoho. I'm looking for developers with specific skills and experience customizing Od...specific skills and experience customizing Odoo CRM or Zoho Creator (CRM). Key features I need to integrate: - Contact management - Management of the Contracted Services pipeline - Customer support tickets - Agenda management with confirmations via automation via email and Whatsapp - Patient Medical Records - Integration and Management of WhatsApp messages - Built-in video calling appointments Additionally, the project requires specific design and branding elements that will be explained in more detail during the selection process. An eye for detail and a creative mindset are required to meet the spec...

...designer will be responsible for: Creating an interactive and user-friendly design in Figma Developing wireframes and prototypes based on provided sketches and descriptions Suggesting and implementing improvements to enhance usability and aesthetics Ensuring responsive design for both web and mobile views Pages to Design: Home Page: Displays an overview of tasks, notifications, and key metrics for the day. Contents: Summary of check-ins/check-outs, ongoing tasks, alerts, and quick links to other sections. Property Listings Page: Allows property managers to view (individual and all listings), add, and edit property listings. Contents: List of properties with details like name, location, status, and actions (edit/delete). Task Page: Shows all tasks for the day, assigned t...

...target group. Medical Staffing Agency primarily located in the Midwest current Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in the CMS system. Google Analytics Setup: Integration of Google Analytics for tracking website traffic. Security Plugins: Installation of security plugins to help protect the website from common threats. The following pages are included in the base design package. • Home &bu...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precisio...

I'm on the lookout for an experienced GDPR solicitor who can pro...My organization routinely deals with a considerable volume of potentially sensitive phone call records. Here are the main tasks that the right candidate should be prepared to handle: * Legal Guidance: I need expert advice on how to navigate legal disputes related to potential data breaches involving phone call records. * Legal Representation: The ideal candidate must be well-versed in representing an organization during any potential legal dispute, with an emphasis on data breaches. If you have a thorough understanding of GDPR compliance, with a particular emphasis on data breach protocols - I would like to hear from you. Is there a demonstrated record of successful GDPR legal representation i...

...original* designs that you yourself have created should be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Designs with contrasting elements which lead the eye toward the center of the icon are preferred. > The core design should be in vector f...

I need a tech-savvy professional with vast experience in social media account recovery. I lost control of my old Instagram account but I have the username. My main goal is to regain access and permanently delete the account. Key Responsibilities: - Recover lost Instagram account using the provided username - Delete the account upon recovery Essential Skills: - Knowledge and expertise in Instagram account recovery - Experience in similar projects - Understanding of privacy and data security protocols I can provide a driver's license as proof of identity. Confidentiality and transparency during this process are paramount, and I look forward to a successful collaboration.

I am looking for a freelancer who can help me set up iRedMail on my Linux server. - My server is running on Linux. - I have less than 10 email accounts that need to be set up. Due to my lack of technical expertise, I need someone who is familiar with iRedMail and Linux server administration. The ideal candidate should have experience in configuring mail servers and be able to provide a smooth and efficient setup.

I'm looking for a skilled professional who can help me secure my Linux server and SMTP setup. Key Requirements: - Deep experience with Linux server security measures and best practices. - Proficient in securing SMTP servers and ensuring authentication is managed effectively. - Capability to implement SSL/TLS encryption for enhanced security. Your application should focus on detailing your experience in this field. Please provide relevant examples of previous projects where you've successfully secured similar systems.

I'm in need of a skilled UI/UX designer for a medical app I'm developing. The app will be available on both iOS and Android platforms, and is designed to provide users with medical opinions using AI. Key features to be included in the app are: - Diagnosis Suggestions: The app should provide users with accurate diagnosis suggestions based on their reported symptoms. - Symptom Checker: A symptom checker that helps users identify the possible medical conditions related to their symptoms. - Medical Records Storage: A secure and easy-to-use medical records storage system, allowing users to keep track of their health history. Ideal candidates for this project should have: - Proven experience in designing UI/UX for mobile applications, particularly ...

I am in need of an experienced Linux developer for a project that involves server configuration and also have knowledge of apache logs as well to fix some apache issue. Important : Job have to done Remotly.

I am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I need an experienced app developer to update my iPad app to fix a server connection issue. The app is currently unable to connect to the server, and this problem needs to be resolved. Once the update is complete, the app should be submitted to the Apple Store, and I require it to be compatible with iOS 12 and earlier. Key Requirements: - Fix the server connection issue preventing the app from connecting - Update the app to be compatible latest ios firmware - Submit the updated app to the Apple Store You should have: - Prior experience in iOS app development, particularly with server connection issues - Ability to navigate Apple's submission process and ensure the app meets their requirements - Proficiency in iOS 12 and earlier, and the ab...

I urgently need an expert in C# to integrate my Point of Sale/Enterprise Resource Planning (POS/ERP) system with QuickBooks Online. The goal is seamless syncing of different modules, including, but not limited to: - Customer Information - Inventory Status - Purchase History - Sales Records - Products, Categories, etc... Familiarity with QuickBooks Online APIs and proficiency in C# .net Core is imperative for this role. Past experience with similar projects will be highly valued. The timeline is urgent; I need this integration done ASAP. we already have a code we made integration with SAP Business One, we can share this code to have the fastest development, and also we have the code of a previous developer who made of Quickbooks so it would help to see how to integ...

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the abilit...

the project is about to create a Minecraft map that faithfully replicates a GTA RP server. GTA RP (Grand Theft Auto Roleplay) is a unique gaming style where players embody a character and immerse themselves in its persona, acting as if they were that character. Key Features of GTA RP: 1. **Roleplay Dynamics**: - Players assume the identity of a self-created character and live out their life within a fictional context alongside other players. - Interaction can be via text or, preferably, voice chat for enhanced realism. - Characters can be anything from a prominent businessperson to a foreigner unfamiliar with the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their o...

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed