
Excel / openoffice, trying to merge 2 sets of data to form a telecoms rate sheet
5280
£45(approx. $60)
- Posted:
- Proposals: 1
- Remote
- #115520
- Archived
Description
Experience Level: Intermediate
Not a massive job but I do have more to follow. Basically trying to create a rate sheet merging two sets of data to create the following columns.
a = Telephone Prefix
b = Area name
c = Zone
D = Call rate
I'll post the current data I have.
The answer is the following equation, I just don't know how to create the function.
Where c=k, then insert n into d
I have shown an example for the first 19 entries.
a = Telephone Prefix
b = Area name
c = Zone
D = Call rate
I'll post the current data I have.
The answer is the following equation, I just don't know how to create the function.
Where c=k, then insert n into d
I have shown an example for the first 19 entries.
Kim R.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
30 Jan 2012
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