RE: [ExcelVBA] Pivot type problem

 

Hi Jim

Seems you email got garbled on being translated to plain text. Could you
try again an put, say, pipe characters between the columns, so we can
understand the data. Then you need to make sure we can understand how the
output is derived from the data. It looks as though the output is

The first 5 characters of the data
The seventh character of the data
A space
A numeral (where does this come from?)
A character (Is this the seventh character again?)
2 spaces
Another numeral (Where does this come from?)

Of course the required output and the way it is derived could be quite
different. Without an explanation we cannot help you.

What is an "Instance" of Noml? Is there one on each row? Or are there
particular characters which have to match (like extracting all the amounts
coded to a particular account code?)

I hope you can help us to help you.
It might help us to understand if you tell us what you are doing!

Best Regards
David Grugeon
Excel VBA Group Moderator

-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of Jim Fraser
Sent: Friday, 1 June 2012 8:30 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Pivot type problem

dear all

I have 3 columns of data: NOML: FR: G. I wish to scroll down the NOML
column and for each incidence of NOML record the incidence of the G column
against the f reference. eg:

Data

NOMLFRG
6001A1A
6002A1A
6001A38
6002A38
6073A38
6074A38
6075A38
6001A10A
6002A10A
6001A117
6003A21G
6001A230


Result:

FR
NOML123101120212223
6001AA 8A 0

There are thousands of rows and I want to select each incidence of noml. A
pivot table will almost do it but it sums or avg etc the result, I just want
to return whats in col g.

Thanks in advance.

Jim

[Non-text portions of this message have been removed]

------------------------------------

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------Yahoo! Groups Links

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (51)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___