I am working with text files dumped from AutoCAD, the files in this case have
all the data for each special piping item. Each type of these items has a
unique identifier but may be used many times throughout the process plant. I
am compiling a list of these items showing how many of each is used using the
countif function, but what I would like to include is all the drawing numbers
and line numbers each one has been used on. This data is in the text files
but spread throughout the list of approximately 4000 items, I would like a
concatenateif function to string all the drawing numbers together and display
then in a single cell. I know this sort of filtering is possible with pivot
tables but that doesn't really help in this case. If anyone can help let me
know as I am sure I am not the first person to wants to do this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

is it possible for you to show us the type of data you get and what/how you
want to organise it
--
paul

remove nospam for email addy!



"John the Engineer" wrote:

I am working with text files dumped from AutoCAD, the files in this case have
all the data for each special piping item. Each type of these items has a
unique identifier but may be used many times throughout the process plant. I
am compiling a list of these items showing how many of each is used using the
countif function, but what I would like to include is all the drawing numbers
and line numbers each one has been used on. This data is in the text files
but spread throughout the list of approximately 4000 items, I would like a
concatenateif function to string all the drawing numbers together and display
then in a single cell. I know this sort of filtering is possible with pivot
tables but that doesn't really help in this case. If anyone can help let me
know as I am sure I am not the first person to wants to do this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I can show you the data I will email the work book and explanation to your
email address.

"paul" wrote:

is it possible for you to show us the type of data you get and what/how you
want to organise it
--
paul

remove nospam for email addy!



"John the Engineer" wrote:

I am working with text files dumped from AutoCAD, the files in this case have
all the data for each special piping item. Each type of these items has a
unique identifier but may be used many times throughout the process plant. I
am compiling a list of these items showing how many of each is used using the
countif function, but what I would like to include is all the drawing numbers
and line numbers each one has been used on. This data is in the text files
but spread throughout the list of approximately 4000 items, I would like a
concatenateif function to string all the drawing numbers together and display
then in a single cell. I know this sort of filtering is possible with pivot
tables but that doesn't really help in this case. If anyone can help let me
know as I am sure I am not the first person to wants to do this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions