Can I get criteria from columns to populate down?

  • Thread starter Thread starter Charles Stover
  • Start date Start date
C

Charles Stover

I would like to have results populate the cells below each heading.
For example, instead of manually putting the names (Too Many), I would like
it to auto populate the "Assigned To" going down. All the info would be
pulled from existing columns in the spreadsheet.

Ticket Count by Age(Days)
| Assigned To | <=2 | 3 to 7 |>=8 | Total | % |
 
Hi, Charles.

I'm not 100% sure I understand the question, but I'll give it a shot. Are
folks entering data on the sheet and you want it to automatically create some
formulas or do you already have all of the data and you just want to recreate
some additional information from it. In other words, do you have Last name
in one column and First name in another and you just want to put them
together, or is it more complicated than that?
 
Hi,

Its not clear on what you want. Why don't you want to show us a sample.
 
I apologize.

I have a spreadsheet with alot of populated columns.
1 column has "Assigned to" names in it.

| Assigned to |
AV HDSUPPORT T2
Jason Quattrone
AV HDSUPPORT T1
Leonard Bolton
Andrey Lubimtsev
Daniel Giampietro
Jason Applebaum

I would like to be able to auto populate the names with no dups in another
column.

I have another column with days in it (1,2,4,7,34,etc.) This reflects how
many days each person above has been working on an issue.

| AGE |
5
1
6
3
7
18
7
11
7

I would like to populate the columns to the right of the new column above
with the total of tickets for that particular person.

EX:

New Columns= | Assigned To | <=2 | 3 to 7 |>=8 | Total | % |
Auto Populate= |Jason Applebaum| 3 | 2 | 6 | 11 | 25% |

I would need this to populate down repeating this for all the names without
any duplicates.

I hope this is a better explanation.

Thanks.
Charles
 
Back
Top