Look for data

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

I have a query which I hope someone will be able to assist me with as I am finding it quite complex.

I have the following problem:

Column Column Column Column

X1111
-A 34 2790500 34
-B 11 1415999 11
Total 45 4206499 45
X1110
-A 9 1342875 9
-B 4 306000 4
Total 13 1648875 13
X1101
-A 12 1567560 12
-B 4 506595 4
Total 16 2074155 16
X1010
-A 33 5138350 33
Total 33 5138350 33
X0101
-A 2 182000 2
Total 2 182000 2

What I now require is for another column (or a different spreadsheet) to list the X code and the following column after that to list the value of the first A letter that comes after the above X code. The same for B and total.

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