G
Guest
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/com...dg=microsoft.public.excel.worksheet.functions
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/com...dg=microsoft.public.excel.worksheet.functions