grouping rows?

**hmm321** · 07-01-2012, 05:19 PM

a little confusing how to explain what i need. should make sense if you can view file attached.

thanks for any help. forexcelhelp2.xlsx

main product numbers are in Column B.
how can I highlight each group of more than 1 main product number (Column B)
AND that has at least 1 empty cell in Column C AND where at least one of these rows (col h) is In Stock?

**hmm321** · 07-01-2012, 07:01 PM

anyone? doing this manually for too long. any help would be appreciated.

**FDibbins** · 07-01-2012, 07:08 PM

im trying to figure out something for you, but having a blank in col C either above OR below is proving troublesome. is there a way to ensure that the duplicate with nothing in C is the 2nd entry?

also, i noticed that the 2nd example you highlighted doesnt have the same main item number...is this correct?

**hmm321** · 07-01-2012, 07:48 PM

yep, that's correct. It'd help a lot if I could even highlight any rows where col B appears more than 1 time. that would even cut down on a lot. One step better would be highlight only IF at least one in col H is In Stock. Either would help tremendously. and we can forget about C entirely

THANK YOU for any help.

**FDibbins** · 07-01-2012, 08:58 PM

Highligh all the data in col B, and use this in CF as a "use a formula" option...

=AND(B2=B3,H2="In Stock")

This will highlight those rows that have duplicates and are in stock

**hmm321** · 07-01-2012, 10:11 PM

ahh, sorry, I tried to not bug you again, but I'm not even the level of a noob. Don't use Excel much and don't have a need usually. I Googled and googled and still don't know how to add this Circular Function. thank you