Creating a formula to return data based on conditions

  • Thread starter Thread starter Susie Reid
  • Start date Start date
S

Susie Reid

I need to know how to write a formula that will reference
a range (i.e., A1:B50) that includes columns of dates,
and rows of names, in oder to return a list. I probably
need to use the IF function, to basically say, "if there
is a number in a cell within a1:b50 range, then return
the name listed in column A of the same row, and place it
here." Make sense?

sr
 
Are you suggesting the following?

With data:
A1: Joe
B1:
A2: Jack
B2: 123
A3: Jane
B3: 456
A4: Jill
B4:

Return:
C1: Jack
C2: Jane

If so, how many records are you looking at? Have you considered using the
advanced filter/autofilter?

Could you be more precise? Maybe give some examples of what you have now
and what you want to see?

/i.
 
Yes, thank you.

Here is our goal:
We have a spreadsheet with a list of about 40 defects in
rows in column a. We have named columns b through af as
days of the month (1 - 31). We enter the number of
occurrences of a specific defect on the row of the defect
and in the column of the day of the month it occurs. We
want to generate daily reports by capturing all the
occurrences listed in a day. (Rows 1 - 40 of column b,
for example). We want the formula to go to the column,
find the numbers, and return the name of the defect from
column a and make a list. From the list we will create a
chart to refresh daily for quality control, i.e.,
locating problem areas, etc.
 
Back
Top