Match data in an Excel spreadsheet
- or -
Post a project like this4163
$$
- Posted:
- Proposals: 3
- Remote
- #188050
- Completed
Description
Experience Level: Intermediate
I have an Excel spread sheet with 3 tabs of data. The 1st and 2nd tab both have 2 columns – Magazine Title and Magazine description.
I need rows matching between those 2 tabs and entered into the 3 tab.
So for example, tab 1 contains the following 4 magazines: -
Architectural Design (AD) - Bi-monthly magazine reporting on the architectural community
Architectural Profiles Magazine - Quarterly architect journal for Canada
Architectural Review Asia Pacific - Australia's architectural magazine
Architecture 256 Magazine - Africa's premier architectural magazine
And in tab 2, I find: -
Architecture Today - Aimed at the practicing architect; features new and refurbished buildings in Britain and Europe, plus articles of a technical and practical nature.
Because these magazines are all of a very similar topic, they are put side by side in the 3rd tab.
Final task is to highlight in red all those magazines that have been matched in tab 1 and 2 and highlight in green those that there is no match for.
Example spread sheet attached.
Full spread sheet will contain: -
Tab 1 – 140 Titles
Tab 2 – 327 Titles
I need rows matching between those 2 tabs and entered into the 3 tab.
So for example, tab 1 contains the following 4 magazines: -
Architectural Design (AD) - Bi-monthly magazine reporting on the architectural community
Architectural Profiles Magazine - Quarterly architect journal for Canada
Architectural Review Asia Pacific - Australia's architectural magazine
Architecture 256 Magazine - Africa's premier architectural magazine
And in tab 2, I find: -
Architecture Today - Aimed at the practicing architect; features new and refurbished buildings in Britain and Europe, plus articles of a technical and practical nature.
Because these magazines are all of a very similar topic, they are put side by side in the 3rd tab.
Final task is to highlight in red all those magazines that have been matched in tab 1 and 2 and highlight in green those that there is no match for.
Example spread sheet attached.
Full spread sheet will contain: -
Tab 1 – 140 Titles
Tab 2 – 327 Titles
Callaghan Software Ltd
100% (515)Projects Completed
331
Freelancers worked with
238
Projects awarded
81%
Last project
12 Sep 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies