Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A kind of auto-filter question...
Hello all, I have a chart with all kinds of data on but on a different
sheet I want to compile a list of information by looking at another sheet and saying within a range is there a matching text string "CAUG 2" and if so print a string to the left providing it hasn't been printed before. So for the data below... A B 1839/3/4SL POLY COTTON/CERISE CAUG 1 1839/3/4SL POLY COTTON/BLACK CAUG 2 1839/3/4SL POLY COTTON/LIPSTICK CAUG 2 1839/3/4SL POLY COTTON/BLUE CAUG 2 1839/3/4SL POLY COTTON/WHITE 1839/3/4SL POLY COTTON/LIGHT PINK 1839/3/4SL POLY COTTON/PALE LILAC ....this would apear which I can then vlookup the rest of the information and compile another chart... 1839/3/4SL POLY COTTON/BLACK 1839/3/4SL POLY COTTON/LIPSTICK 1839/3/4SL POLY COTTON/BLUE and just by changing the tags in column B the list in sheet2 would change. Anyone have an idea if Excel can handle this? So in plainer english, a column of formulas that say look through a range and if it contains a tag print a text string from another column providing it hasn't been printed before. I hope that's clear... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter Question? | Excel Discussion (Misc queries) | |||
URGENT !! Auto Filter | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions |