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... |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com