LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
Posts: 55
Default Check of related records in a column have data filled in in the next colum


Another question,

In Column A several identical data is registered.

Run all records of column A;
For each group of identical data in column A all fields related in column B should be filled in if at least one of them has filled data.
If there are empty ones (the others of the group have data in it), then those in column B should be marked with filled color red.

Clm.A Clm.B
aaa xx
aaa xx
aaa <- color field B3
aaa xx
bbb xx
bbb xx
ddd xx
ddd xx
ddd xx
fff xx
fff <- color field B14
fff <- color field B15
fff xx

Any help, Thanks!

regards, Johan
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
Excel formula for counting nr records with data and related empty fields johan Excel Programming 3 April 2nd 12 07:06 PM
how can i bring a colum related to another colum? me Excel Worksheet Functions 1 October 6th 09 09:01 AM
Using vb to paste records from 1 sheet, to related records in another chrisnichols87 Excel Programming 0 January 10th 07 11:59 AM
Search for data in a column bring all related items in other colum sk New Users to Excel 2 September 2nd 06 10:39 PM
Check data on colum A and find match on colum b Chris(new user) Excel Discussion (Misc queries) 3 March 20th 05 05:45 PM

All times are GMT +1. The time now is 08:34 AM.

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

About Us

"It's about Microsoft Excel"