I need a specific excel
- or -
Post a project like this2798
$$$
- Posted:
- Proposals: 20
- Remote
- #1243554
- Completed
technical writing, article writing, data entry, office work ,electronics work, technical design
Mianwali
✪Software Developer ✪Web Developer (Java,Python, Android, jee, JSP, JSF, Java Fx,Vue, Blue J, Nuxt) ✪ Processing ✪ Elastic Search ✪ Database
Saitama
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
Islamabad
4437201083058133972313395911332396132226512671401244165123738312280501114128270269
Description
Experience Level: Expert
I have 2 seperate Excel files.
On sheet 1;
B column: Plate number
H column: there is conditional formatting "paid, not paid, partial"
K column: amount of payment done
L column: remaining amount if partial payment (zero if fully paid)
On sheet 2:
B column: plate number
E column: debt type 1
F column: debt type 2
G column: debt type 3
H column: debt type 4
I column: debt type 5
What i need is:
if there is debt marked as "paid" or "partially paid" on sheet one, take that
take all 5 types of debt in sheet 2
and give me all of them in same sheet
Please tell me if this is possible, if yes tell me the cost :)
"Senet sistemi" is the excel i track peoples debts. I update it whenever i receive a payment. Conditional formatting is:
Eski: outdated, not to be considered
Evet: paid, not to be considered
Kısmi: partially paid, L column states the remaining amount so it will be taken
Hayır: not paid, L column will be taken
It has around 4500 rows, but plate numbers are repetitive it will be filtered into 200-300'ish.
Borc sistemi is the sheet i track peoples debt, updated every 15 days
We are trying to make a risk table stating me "this plate number has this much debt from senet, etc etc in total of this amount"
On sheet 1;
B column: Plate number
H column: there is conditional formatting "paid, not paid, partial"
K column: amount of payment done
L column: remaining amount if partial payment (zero if fully paid)
On sheet 2:
B column: plate number
E column: debt type 1
F column: debt type 2
G column: debt type 3
H column: debt type 4
I column: debt type 5
What i need is:
if there is debt marked as "paid" or "partially paid" on sheet one, take that
take all 5 types of debt in sheet 2
and give me all of them in same sheet
Please tell me if this is possible, if yes tell me the cost :)
"Senet sistemi" is the excel i track peoples debts. I update it whenever i receive a payment. Conditional formatting is:
Eski: outdated, not to be considered
Evet: paid, not to be considered
Kısmi: partially paid, L column states the remaining amount so it will be taken
Hayır: not paid, L column will be taken
It has around 4500 rows, but plate numbers are repetitive it will be filtered into 200-300'ish.
Borc sistemi is the sheet i track peoples debt, updated every 15 days
We are trying to make a risk table stating me "this plate number has this much debt from senet, etc etc in total of this amount"
HARUN D.
100% (4)Projects Completed
5
Freelancers worked with
5
Projects awarded
56%
Last project
1 Jul 2020
Turkey
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Harun, Can I see both excel file
HARUN D.08 Aug 2016both excel files are submitted to job list
-
Hi , Harun
let me know you need data as said format in excel sheet or macro excel sheet for performing operation for data? -
Hi ahrun
ive read your description about the job ...
do you want to make the 2 sheets in 1 sheet ?
or do you want to marge the 2 sheets together and thier culems ?
i can handle Excel.jobs easly but pleaee explain :-)
and when do you want.the job ? deadline?
thanks and in advance
966169657996565
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