filtering info out of a list

  • Thread starter Thread starter bberman
  • Start date Start date
B

bberman

I'm trying to extract only certain columns that meet a requirement and
failing at it miserably. here's what I'm trying to do

Date Customer# Business Name update tag
8/1/04 123456 abc enterprises 9/1/04

this is a sample data set:

I want to then have an updated list on another worksheet inside the
same workgroup where it lists only the business name and customer
number of all the listings where update tag =today()

I'm lost...someone help
 
Hi
for a non dynamic approach: Use 'Data - Filter - Advanced Filter')

If you want a formula approach try something like the following array
formula on your second sheet (entered with CTRL+SHIFT+ENTER):
=INDEX('sheet1'!B$1:B$1000,SMALL(IF('sheet1'!$A$1:$A$1000=TODAY(),ROW('
sheet1'!$A$1:$A$1000)),ROW(1:1)))
and copy this down / to the right
 
Back
Top