Notepad row column jobs

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...

I'm currently in need of a skilled engineer with experience in structural analysis, particularly with steel structures, to help optimize the design of my project. Project involves suggesting furnace column, beams , plates etc sizes as per Australian standard, and material sizes available in Australian market. Key Responsibilities: - Conduct a comprehensive structural analysis of the steel structure - Analyze and interpret the results for optimization recommendations - Make design suggestions based on the analysis - Ensure the structural integrity of the steel structure Ideal Skills: - Proficiency in AutoCAD - Previous experience in structural analysis and design - Knowledge of steel structures - Ability to provide actionable design suggestions based on analysis - Strong anal...

I'm in need of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bearing support structures, and experience in designing and impleme...

...necessary, but ensure a master sheet includes all fixtures. 3. **Time Conversion:** - Convert match start times to both UK and New Zealand time zones. 4. **Stadium Information:** - Include the stadium name and city where each match is being played. - Use the provided Google Maps link to determine the distance from Sidcup, UK, to each stadium. - Include this distance in the relevant column. 5. **Google Sheets Setup:** - Create a well-structured and easy-to-navigate Google Sheets document. - Ensure all columns are labeled clearly and the data is sorted correctly. - Share the final document with [Your Email Address]. **Deliverables:** - A Google Sheets document containing the complete cricket schedule. - The sheet must be shared with edit access to [Your Ema...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

I have an excel file, need add product categorie on a column - budget 100€

...task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential for automation: I'm not entirely sure if I want the macro to automaticall...

I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images....will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on ...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. ...wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

...for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One...

...exist in Excel, create it 2. When a record exist in Excel and Access (based on field: EL_NO, UPDATED ALL FIELDS FROM EXCEL AND OVERWRITE ACCESS FIELDS except THOSE FIELDS IN Access starting with FINAL_ and user data entries. 3. In excel files there it is possible to exist duplicate entries (based on field EL_NO). In that case remove duplicated and leave the record which has a value (<>NULL) in column TEL1. If none has, then leave any of those. In Microsoft Access will exist the following tables: 1. Voters (the subscribers – this will be the main database) (ID is autonumber, EL_NO is unique – no duplicates. See access file attached). 2. User (usernames and passwords, for the users to be able to login locally) 3. User_data (the data that each user will enter for ...

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

...to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking

I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed by 5/23/24.

Looking for a graphic des...modern and minimalist branding graphics for my product. Photos shows the fruit packer robot in place over a conveyor with multiple units next to each other. Logo, branding colors and photos of machines in a factory are in the data set. Machine currently have a blue logo sticker. This will be removed and replaced with new branding. Orange should be used sparingly as there are lots of machines in a row next to each other and don't want the branding to be over powering. The front an rear needs a location for an ID numbers (shown in the photos) Clear windows can have some branding but it needs to be subtle and not obscure the view too much. The top of the machine is not visible so does not need branding or minimal branding depending how it wraps o...

...(Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslation) !!! Please: present clearly your offer better; ...how many days do you need ? ...what kind of trace/flow do you think ? *all my easy action, now start from === old asset - new asset; Aruba / Italia ...next to Hostinger / Lituania .

...will also lead to other jobs, such as ranking our website, high DR backlinks, blogging, creating pages to rank for easy keywords, running keyword reports, etc. I will only respond to offers that have confirmed they have watched the video. I will not answer bot responses. Key responsibilities include: - Utilizing SemRush to identify toxic backlinks - Compiling the list of toxic backlinks in a notepad for Google Disavow backlinks tool - Ensuring that the backlinks are safely removed from our website The ideal candidate should have: - Prior experience in using SemRush for backlink analysis - Proficiency in compiling and managing backlink lists for Google Disavow tool - A solid understanding of SEO best practices and the impact of toxic backlinks on website ranking Access to the ...

Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency bands, co...

Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a vehicle control system designed to enable specific operations on a vehicle. Traditionally, there has been a smart system utilizing electronically authenticated keys through wireless communication with the vehicle. However, a new method using sound authentication with a device worn on the user's ear has been proposed. While this device offers a novel way to authenticate with the vehicle, using standard communication protocols allows authen...

I need to create alternating colors for rows 19 to 28 and specifically for cells F29, F30, F31, and F32 using fill colors #F2F2F2 which is light gray and #F2F2F2 which is white. There will be a lot of hiding and unhiding of rows for this rang...specifically for cells F29, F30, F31, and F32 using fill colors #F2F2F2 which is light gray and #F2F2F2 which is white. There will be a lot of hiding and unhiding of rows for this range and I need a solution that always displays alternating colors despite frequent hiding and unhiding of rows. Can anyone help me with setting up a conditional formatting rule that automatically alternates the row colors, regardless of row insertion, deletion, or hiding? https://docs.google.com/spreadsheets/d/1SwqtiYIrZdO8p6YOxKsOx5MTgE3qQwAajTKIImYWHmE/ed...

Hello, I need mapping a CSV that contains many information and put all words in each column

...for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR. The data is sorted using the “Mode of delivery” information, which allows deliveries to be grouped by truck. During the day&#...

I'm currently using a Python scraping bot for my project, but I need to make some adjustments. Key Requirements: - The primary modification involves segmenting the scraped data by day. To achieve this, I would like to have a timestamp column added that differentiates data on a daily basis. This will allow me to have a better understanding of the data collected each day. Your Proposal: In your application, please provide a detailed project proposal. I'm interested in freelancers who can clearly articulate how they will approach this task and ensure its successful implementation. Ideal Skills and Experience: - Proven experience in Python scraping bot modification - Familiarity with data segmentation and timestamping

Need to convert text file to a clean page and remove the colums showing passwords.

I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that co...

I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.

...focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the Expenses column wasn't provided. If interested, please provide a portfolio showcasing your past work relating to Excel and financial data management. Your ability to deliver quality and accurate work will b...

Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.

...doing each gesture, put your hands down -if you mess up, that is OK, but then you must edit the video. (there is no negative to a video with many edits/cuts) If you rehearse it 2X and then record, it takes about 11 minutes. Total time to perform is approximately 35 minutes... So less than 1 hour Here is the google sheet that is a "conceptual guide". For each row, it tells you how many signs are needed for that row (See” count" column).... (many are done with LEFT and RIGHT hand). In some cases signs are moving vs static and it shows you the "States" of the specific sign. Again, this is a conceptual guide but the example video is what you want to use as a reference. https://docs.google.com/spreadsheets/d/14PJe9FmxsQXvaq-Rm7r1...

The main goal of this project is to improve our React application so it looks professional and has a better overall UX. Everything below should work on Chrome, Edge, Firefox and Safari of windows desktop, iPhone and android. Milestones will be created. Results card layout improvements: a) Currently, for layout with multiple laptops per row, it shows specs only on mouse-over, lets remove that and show that in the card itself, between the laptop image and the hyperlink of the laptop title. Lower the font a little bit and add a special css class to control the style of the specs. b) The cards need a bit more padding/margin so they dont look too crowded with information. Show Details popup: c) Show details popup needs to occupy 90% of the screen width showing the specs in two columns ...

...and converting it into JSON format. The PDFs, such as the example provided here, vary in format and column structure based on their categories. The solution should not require downloading the PDFs manually. Sample URLs Requirements: - Develop a tool or API endpoint for extracting data from PDF files located at given extracted PDF table data into JSON format. - Handle various PDF formats with different column structures. - Preferred tech stack: PHP (Laravel), Node.js, or Python. - Ensure robust error handling

Fix related issue in the module. Authentication, column view issue. Able to follow to fix one by one and with ftp

I'm seeking a proficient scriptwriter to design an Airtable script that can effectively combine data from a single table that consists of parent-child relationships. The main task for this script will be to focus on combining data from the parent-child and combining it onto 1 row each. Specifically, the required updates will involve: - Combining Parent and all children data onto same row - Taking DOB field and splitting into a Month field and a Year field - The end result should be a base where I can upload a new CSV and it outputs the desired result into a new table that I can download a csv from The ideal candidate for this role is someone well-versed with airtable scripting and data management, specifically having a strong knowledge of number fields. Your experien...

...website template, row to row: 1. Head: our logo It is ok. 2. Blog with 3 news 2.1 Titles of the news has to be changed in lowercase (only first letter uppercase) 2.2 The text of the news have to wrap at the end of the word, not interrupting the word 3. Field of actions (aree di intervento) 3.1 The the written texts (Empowerment delle Persone, Empowerment delle Aziende, Empowerment delle Comunità Locali) have to be centred in the middle (horizontal direction) of 3 columns of news 4. Events 4.1 The width of the "Event" box have to be the same as the width of the "News" box (row n. 2) 4.2 The description of the events have to appear and the countdown of the missing days have to be removed 4.3 Insert purple lines after this "Events&qu...

...people drive past, which means the perspective of the images needs to match the size of our truck. The back of the truck measures approximately 2.2m High, 5.5m Long and 2.5m Wide. Require 3 different images, 1 rear (2.2m x 2.5m) 2 sides (2.2m x 5.5m) ideas are: - Rear truck image shows a wedding aisle, have managed to create so many images on AI that do the job but I can't seem to get the back row of chairs showing... I want it to look like the back doors of the truck are open and it looks like a wedding aisle including Tiffany Chairs, Flowers, Fairy lights, Wedding Arbour are inside. do not want people, just wanting furniture and staging items. - Side Image 1 is to be a stage with lighting, speakers, band etc - Side Image 2 is to be a buffet food display Furniture &...

I'm looking for a HubSpot consultant to help me with migtation and mapping from pipe drive, i could use the inetgration to map but emal not showing up and i also need them to map/migrate the special column/field from pipedrive to hubspot, IF YOUR NOT A PRO DONT CONTACT ME . I NEED DONE TONIGHT

...url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel file for the sample of what I need For end solution, i should be abl...

Hi, I am new to react. If I click open panel a panel opens. if I drag the item from the panel to column2 it should add to the table and simulataneously it should add to column 1. same way if I add to column 1 it should add to column 2 table two. I am able to achieve for column 1 but not inside column 2 table. can you lee me know how to fix it. Providing my code and fiddle link below. ,src%,src%2FApp.jsx&terminal=dev import { useState } from 'react'; import reactLogo from './assets/'; import viteLogo from '/'; import './'; import { DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false); const [columns, setColumns]

...google spreadsheet and scrutinize incoming leads based on their EPC status. The main functionalities required are: - Retrieving Contact Details and EPC Status: The BOT should be able to fetch the contact details of leads and simultaneously check their EPC statuses. - Highlighting Matches: In case a lead matches the EPC status I am in search for, the BOT should distinctly highlight the respective row in the spreadsheet. - Segregating Non-Matches: The BOT should be capable of moving the leads that do not match the desired EPC status to a separate section in the spreadsheet. Ideal skills for this job would be advanced Python or Java programming capabilities, extensive experience with google spreadsheets, and familiarity with EPC checks. A structured and methodical approach to ...

...code, Emails, Websites, Social Media Links, Address, City, Country ,PO Box, category of company 2. AND Any other available information on the cards === Requirements: * High accuracy is crucial; entries will be checked for spelling and number accuracy. * The partner needs to speak English fluently and in writing as well. * Images will need to be renamed at the end of the project to match the row of the card on the sheet * The project will not be considered delivered if there are inaccuracies, hence you need to double check all numbers and words. * Note that 99% of the cards are in English. For cards with multiple languages, if the information is also in English, only the English data is required. * The partner needs to report on the progress of the data entry * Sample of t...

...Registration form with a. **Capture Basic Information:** - Name - Email - Phone - Occupancy type (Single or Double) b. **Capture Detailed Guest Information:** - Guest Names - Date of Birth - Nationality - Shooting Activity Participation (Yes/No) c. **Instructions Based on Occupancy:** - **Single Occupancy:** - Provide two rows in the form. - Indicate that the second row is for a non-shooting guest, who can be added for free. - Display message: "You can add a non-shooting guest for free to the accommodation." - **Double Occupancy:** - Provide two rows in the form, one for each participant. d. **Final Steps Upon Form Submission:** - Save the completed form. - Send an email confirmation to the provided email addres...

I am looking for an expe...central point of the project is database management. • The main responsibility of the developer will be to create a database, and a form page in HTML • and link the form to the database Experience in the field of database and Mysql is necessary. , the form must be elegant and well displayed on laptop and tablet screens. the objective is when entering a reference in the form all the data in the row of the database table will be displayed in the form. if the reference number does not appear in the database the web page generates a message. The successful candidates will illustrate these skills throughout their portfolio in relation to previous projects. If you are self-starter and have a penchant for database management, I look forward to recei...

...formwork plan over the ground floor • Plate reinforcement plan over the ground floor • Formwork plan and beam reinforcement over the ground floor • Formwork plan and ground floor pillar reinforcement • Formwork plan and ladder reinforcement • Plate formwork plan over the floor • Plate reinforcement plan over the floor • Formwork plan and beam reinforcement above the floor • Formwork plan and floor column reinforcement • wood Frame/ roof plan • wood Frame / roof details - **Sanitary and Thermal Installations Design**: In addition, I require a dedicated engineer with expertise in sanitary and thermal installations. This professional will be responsible for creating the necessary technical designs and providing detailed installatio...

I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.

I am new to Power Automate. I have already built several relatively complex Flows, but I am facing a few issues related to dynamic UI elements and how to stop a loop. I am looking for someone with a strong grasp of Power Automate to help me solve these issues. 1. How to stop a loop based on a Python GUI counter. 2. How to pick a link in a table based on the right column (in Salesforce). 3. How to click a download link that always has a different CSS identifier. 4. ...might be an additional question that arises. Note that autodesk is not allowed on my work computer but I can provide very detailed information with screenshot from Power Automate to help you understand the issues.

...excel file Pictures must be saved with their code. f.e. (code is in column A). If in Column F there are more than 1 pictures, then save 2nd, 3rd etc. pictures like: , adiddv0318_4.jpg... Always in Column F (URL's for download), pictures without _a, _b... are the main picture (therefore must be saved like ). Pictures with _a, b.. etc. must be save as 2nd, 3rd ... (, ). If in Column F there is no picture without _a, then use the picture with _a as main picture and save it as ; If in Column A there are not valid characters (like / ), replace them with _ Tackle4Allitems excel

I am new to react I need to move the item from the column 3 to column 1. Initially I developed static code. then I used react-beautiful-dnd and splice logic to move item from source to destination I even debugged by putting console.log. console not printing, Providing my code below. Can you let me know how to fix it, even needed to be added to table rows when added and integrate in my codebase later can you fix the code in my stackblitz ,src%,src%2FApp.jsx&terminal=dev

I need assistance transferring data between Excel sheets Key requirements: - Data transfer: I'm unsure if this needs to be a manual or automatic process. I'm open to suggestions that will make the process efficient and error-free. - Randomising 'Task Types': This column needs to be randomized each time data is transferred. The 'Task Types' should be selected from a specific range of values. Ideal skills for this job: - Proficiency in Excel )

I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data sets a...

We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for cl...