Look for unstructured data - complex

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have what I believe to be a complex query which, I hope, someone will be able to help. The purpose of my exercise is to select data from a particular column to a different sheet. An example is listed below:

Code Units Total
A05251
-pur 16 2005156
-rem 6 810595
Total 22 2815751
A03626
-pur 41 6219082
-rem 2 212250
Total 43 6431332
A02996
-pur 2 182000
Total 2 182000
A09412
-rem 2 190000
Total 2 190000

What happens however is that the results displayed are not consistent. Today I may have "pur" and "rem" under a particular code however tomorrow that may not be the case and I will have only one of the two or none. In this collumn there are hundreds of codes which start with a diferent letter however I am only interested in the codes starting with "A" and the respective pur and rem results. What I am looking into doing is listing the information in a different sheet, preferably by having all the possible "A" codes with the resptive "pur " and "rem" and total for each "A" code and then fill it in daily with whatever comes from the sheet where the above info is.

Any assistance would be most appreciated.

Many Thanks!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too