Google sheet - get unique invoice rows as per conditions

₹600-1500 INR

Closed

Posted

almost 3 years ago

₹600-1500 INR

Paid on delivery

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]

Project ID: 30864086

About the project

12 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

12 freelancers are bidding on average ₹2,429 INR for this job

@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 in 1 day

4.9

(49 reviews)

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 in 2 days

5.0

(13 reviews)

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 in 1 day

5.0

(4 reviews)

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 in 7 days

0.0

(0 reviews)

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 in 3 days

0.0

(0 reviews)

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 in 7 days

0.0

(0 reviews)

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 in 7 days

0.0

(0 reviews)

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 in 7 days

0.0

(0 reviews)

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 in 2 days