Excel formula work
- or -
Post a project like this199
$10
- Posted:
- Proposals: 5
- Remote
- #4070600
- Awarded
Description
Experience Level: Entry
I have an excel 2016 file (called Tabella CHAOSALL) and i need an useful function for me that i'm going to explain.
When i write 2 numbers belonging to ROW 1 (that goes from 1 to 36) under cell "LAST NUMB" & "NEXT TO LAST" (placed under the database) i need to find equal values in 2 different columns written under the cell called "RESULTS" (placed under the database). Also those values have to be highlited in the respective columns.
Example in column B i have the numbers: 6,8,10,15,21,23,25,27,30,31,32 while in column D i have the numbers: 5,6,10,13,17,19,21,23,27,34. I would like to be able to find the numbers in common in the 2 columns ( in this case B and D) which are:6,10,21,23,27,. It's logic that i will provide the excel file to work on it.
I hope I've been able to make it clear. Please let me know if you aare available now so I can send you the file. Need to be completed asap prolly (4 to 5 hours)
Thanks
Hina
When i write 2 numbers belonging to ROW 1 (that goes from 1 to 36) under cell "LAST NUMB" & "NEXT TO LAST" (placed under the database) i need to find equal values in 2 different columns written under the cell called "RESULTS" (placed under the database). Also those values have to be highlited in the respective columns.
Example in column B i have the numbers: 6,8,10,15,21,23,25,27,30,31,32 while in column D i have the numbers: 5,6,10,13,17,19,21,23,27,34. I would like to be able to find the numbers in common in the 2 columns ( in this case B and D) which are:6,10,21,23,27,. It's logic that i will provide the excel file to work on it.
I hope I've been able to make it clear. Please let me know if you aare available now so I can send you the file. Need to be completed asap prolly (4 to 5 hours)
Thanks
Hina
Hina A.
100% (5)Projects Completed
5
Freelancers worked with
3
Projects awarded
36%
Last project
12 Sep 2023
Australia
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