This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Daniel Frisano Italy Local time: 03:42 Member (2008) English to Italian + ...
Mar 21, 2021
I must be really dumb. Why use a grand total of TWO functions when you can nest them into one?
Hans Lenting
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
mikhailo Local time: 04:42 English to Russian + ...
re
Mar 22, 2021
1. Add column (A) to list and add numeration (to restore original order) 2, Sort list by colums with segments (B) 3. In the next column (C) in 2 row (C2 cell) (A - numeration, B - segments) add formula "=OR(B2=B1;B2=B3)". Replicate formula to row. (using small square in a bottom right corner of the cell) 4. Copy C column and paste as values 5. Sort list by C column and remove all TRUE. 6. Sort list by A column 7. Remove A column
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Tjasa Kuerpick Slovenia Local time: 03:42 Member (2006) Slovenian to German + ...
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.