Google sheet - get unique invoice rows as per conditions

₹600-1500 INR

Suljettu

Julkaistu

lähes 3 vuotta sitten

₹600-1500 INR

Maksettu toimituksen yhteydessä

I have a Google sheet with about 10000 rows . It's has invoices which are marked as paid and open. Many of them are marked as paid in one row and open on another row (same invoice number). I want to extract only the paid invoices , which also have an open entry and the open invoices which have no paid entry. Also select where paid only is there. There are rows which are duplicates, these duplicates also need to be removed. Sample google sheet - [login to view URL] Partial solution on stack overflow [login to view URL]

Projektin tunnus (ID): 30864086

Tietoa projektista

12 ehdotukset

Etäprojekti

Aktiivinen 3 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

12 freelancerit tarjoavat keskimäärin ₹2 429 INR tätä projektia

@Mokshith30

Hi I'm Sai Kumar from India. I've read all your requirements in this project. I am very good VBA expert.. so basically you're trying to Write google apps script? i will write a vba macro to do this job. So, i will finish this task in a day only. Please share the details with me.. Thanks SAI

₹1 500 INR 1 päivässä

4,9

(49 arvostelua)

5,1

@tushchak0716

Hi greetings from Tushar!! I am interested in taking up your google sheet project of grouping your invoices based on the requirement of status provided in the description . I have hands on experience of working with google app script, google sheet and google forms and have done few projects previously using google app scripts and google sheet functions. Let's connect over chat to discuss further on this. Looking forward to hear from you. Thank you.

₹1 250 INR 2 päivässä

5,0

(13 arvostelua)

4,8

@youssefahmed99

Hello, i can finish all your requirements in a few hours from the time i start working, i've already worked on multiple similar projects and i'd like to help in this one as well so please message me, you'll see some of my experience on my profile if you want too, i request payment after finishing 100% of the project and i'd like to build a long term relationship if you'd have me on future projects, thank you.

₹1 500 INR 1 päivässä

5,0

(4 arvostelua)

2,6

@alirazadehalvi49

hi sir/mam I am here to help you with data entry article writing and some more work I'll do my best for the job which is given to me you can trust me for a good work

₹1 000 INR 7 päivässä

0,0

(0 arvostelua)

0,0

@divyaguptas130

My typing speed is very fast,I am free for full time work so I can complete it quickly.I have already did this kind of project successfully.

₹1 050 INR 3 päivässä

0,0

(0 arvostelua)

0,0

@shubham875500

Hello Dear Sir/Ma'am, My understanding of the work is what makes me an excellent candidate for your project. I have worked on a project very similar to this before, and I am sure that I can replicate its success while working on the project that you assign to me. Waiting for positive reply. Thank you.

₹1 050 INR 7 päivässä

0,0

(0 arvostelua)

0,0

@GurdeepMehra

I am web designer. I am working with google sheets so I know all functionality of google sheets. I am on working on this if you give me a chance

₹1 050 INR 7 päivässä

0,0

(0 arvostelua)

0,0

@EJMR

I believe I can help you with this project. I would love to hear more details about this and apply my knowledge in Google Sheets and past experiences.

₹1 050 INR 7 päivässä

0,0

(0 arvostelua)

0,0

@AhmadBilalB

Hello, I have read your requirements and realize that I am fit for your project. I have rich experience in this particular topic, therefore, I am confident enough to bid this project. If you want any clarity related to my skills then feel free to contact me before finalizing the deal.

₹600 INR 2 päivässä