LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Find criteria based data and display next to a count in another wk

I am having difficulty determining a formula. I have a worksheet with a page
of details where the first column is a data validation list. The second
worksheet is a count of each of the items in the data list. I am trying to
include a cell from the first worksheet for each instance of the resulting
count.

Example of first worksheet titled Details
Incident Category Initials ID # Date Summary description

Minimal Harm CR 10004844 4-Nov-09 Slip & fall due to weather
Serious Harm AN 90032323 3-Dec-09 Medication was incorrectly
Minimal Harm PL 49809292 5-Dec-09 Client dropped box
Minimal Harm AA 50001212 10-Dec-09 Slip & fall during exercise
No Harm CR 10004844 12-Dec-09 Behaviour outbreak

2nd Worksheet

Serious Harm 1 Medication was incorrectly
Potential Harm 0
Minimal Harm 3 Slip & fall due to weather Client dropped box Slip & fall
No Harm 1 Behavioural outbreak when

What formula do I use to copy the comments from sheet one to sheet 2. If
there are 3 counts of an item then I need comment from each of the instances.
I have the count formula already - just can't figure out how to bring the
comments over.

Any help would be greatly appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count based on two criteria. MJKelly Excel Worksheet Functions 2 May 16th 09 02:41 PM
Count based on two different criteria dabnat Excel Worksheet Functions 3 May 14th 09 09:21 PM
Count based on criteria ba374 Excel Discussion (Misc queries) 1 December 20th 07 11:19 PM
Display contents of cell based on criteria Carlee Excel Worksheet Functions 2 October 12th 07 02:28 PM
Count or Sum based on more than 1 criteria Andrew C Excel Worksheet Functions 1 December 29th 05 09:46 PM


All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"