Apache OpenOffice 4.1.0 Spreadsheet Sort

Good day,

I have an automatically created spreadsheet (from separate software) that is generated weekly. I require the ability to re-sort based on certain text contained in Column-C and carry forward related info in Columns A and B. I'm hoping this can be done automatically with a custom sort command or?

See spreadsheet [login to view URL]

- Sheet "EWP" shows raw data

- Sheet "Sorted EWP" is how I would like to see the result of sorted data from "EWP"

Sort Criteria:

1. Data is sorted from text within Column-C (note: the text only has to be present and does not have to match exactly)

- Text grouped by name: Similar common text within Column-C

NJH10, NJM10, NJH12, NJM12, NJH14, NJM14, NJH16, NJM16, NJM18

1 3/4" x 9-1/2", 1 3/4" x 11 7/8", 1 3/4" x 14", etc

3 1/2" x 9-1/2", 3 1/2" x 11 7/8", 3 1/2" x 14", etc

Glulam, Columns, etc

2. Give me the lability to add additional sort names

3. Secondary sort condition is by length Column-B

4. All data not sorted shows at bottom of sheet.

5. Sum of Columns AxB provided and Sum of each Name (see columns I and J)

6. Original columns I through Q not required


Compétences : Excel, Traitement de Données, Programmation C++, Programmation C, Architecture Logicielle

En voir plus : 127.0 0.1 apache 2.4 17 win32 openssl 1.0 2d php 5.5 30, build php did_dest 84768&r1 1&r2 2&r3 3&r4 4&hour 0&repeat 3&gid 17&t 0&option 256, build php did_dest 84768&r1 1&r2 2&r3 3&r4 4&hour 0&repeat 3&gid 17&t 0&option 256did_dest, 0,1,0,2,2,2,3,4,5,6,6, ppm data entry setup 1.0 4, .net core 1.0 4, celery 4.1 0 documentation, apache hbase 1.0 api, silverstripe 4.1 0, openoffice 4.0 1, apache james server 3.1 0, wilcity 1.0 4.1 directory listing wordpress theme, glassfish server 4.1.0 download, npm err! sqlite3@4.1.0 install: `node-pre-gyp install --fallback-to-build`, sqlite3@4.1.0 install: `node-pre-gyp install --fallback-to-build`, failed at the sqlite3@4.1.0 install script, solve the following by using bitonic sort algorithm 2 6 3 7 5 1 0 4, open office 4.1 0 free download, openoffice 4.1 3 user guide pdf, woocommerce 4.1.0 download

Concernant l'employeur :
( 6 commentaires ) Canada

Nº du projet : #30561258

Décerné à:


Hi There, I understand the criteria for sorting and summing the lengths of material in your list. I can create a tool that will do this work for you and I have done similar projects. regards Reuben

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(20 Commentaires)

4 freelances font une offre moyenne de 130 $ pour ce travail

(308 Commentaires)

MASTERS SOFTWARE ARCHITECTURE DATA PROCESSING EXPERT HELLO, I have read the instructions keenly and understood your specifications for the task. I have over 7 years’ experience in this field and have adverse experie Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(3 Commentaires)

Hello, I would love to assist you. I have the required experience for this project and would love to work on it. Thank you for your consideration. ;)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)