Complicated problem, hopeful answer?

  • Thread starter Thread starter Sam Weber
  • Start date Start date
S

Sam Weber

Greetings,

I need to find a way to search through a big file of
information, and do something like the following:

If previous cell is equal to "Total Patients", then bring
number in the cell after it *up* (there is info in
between) to the closest statement "Diagnosis Codes", in
the following cell after that statement.

Here is a URL to an image explaining what I would like:
http://www.blacktonic.com/images/excel.jpg

So basically I'm just trying to move a number to the top
of the section header and getting rid of all the other
information, only keeping the header information because
I need to find the top 50 numbers to it's corrisponding
description.

Thanks in advance,
Sam
 
This formula in D1 will give you the count you're looking for.........adjust
the range as needed..........

=COUNTA(A2:A12)


Vaya con Dios,
Chuck, CABGx3
 
Back
Top