View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GSnyder GSnyder is offline
external usenet poster
 
Posts: 33
Default Can I get criteria from columns to populate down?

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?


--
Happy calculating!

If you like this answer, please click ''Yes.''




"Charles Stover" wrote:

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 | % |