Need to make a formula with conditional formatting for Excel.

[screadore]

Hello everyone,

I'm trying to make an excel sheet that will automatically populate the correct columns with the information provided.

Here are the rules to our data:

1) We have single cases, duo cases, trio cases, and sometimes quad cases.

2) Each family has different values such as 01-0001-C, 01-0001-M, 01-0001-F for one family. Another family in the list would be like 02-0001-C, and 02-0001-M and this would be a duo.

3) The values are present in column A2-A96.

4) For example I would like to be able to fill in column U2 with the mother (01-0001-M) and column V2 with the father (01-0001-F). Then for the other family fill in U2 with the mother (02-0001-M).

5) I'd like to be able to drag this down vertically to automate the process a bit more.

6) In column D2 I'd also like to be able to count the number of samples in the family for instance in the 01-0001 family there would be 3 samples and in the 02-0001 family there would be 2 samples. Is there a way to do this?

I hope this makes sense and I'd greatly appreciate any help if possible! Thank you!

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you