T
terryc
I have a large table of data, containing several rows and columns. Some
of the data is "assumed", and to indicate this it appears in a red font
colour. All "real" data is of black font colour.
On a separate worksheet, I want to "pull out" all the assumed data.
e.g. below (in this example, "assumed" data is shown in square
brackets):
Age Height (cm) Weight (kg)
Jane 21 [89] 70
Tom 37 [90] [60]
Brian [45] 78 [72]
Paul [25] [86] [80]
So, on my second worksheet, it would display something along the lines
of:
Assumed data:
Age Height (cm) Weight (kg)
Jane 89
Tom 90 60
Brian 45 72
Paul 25 86 80
Is there any way of "pulling" data out in this way, i.e. based on font
colour, perhaps using and IF statement?
of the data is "assumed", and to indicate this it appears in a red font
colour. All "real" data is of black font colour.
On a separate worksheet, I want to "pull out" all the assumed data.
e.g. below (in this example, "assumed" data is shown in square
brackets):
Age Height (cm) Weight (kg)
Jane 21 [89] 70
Tom 37 [90] [60]
Brian [45] 78 [72]
Paul [25] [86] [80]
So, on my second worksheet, it would display something along the lines
of:
Assumed data:
Age Height (cm) Weight (kg)
Jane 89
Tom 90 60
Brian 45 72
Paul 25 86 80
Is there any way of "pulling" data out in this way, i.e. based on font
colour, perhaps using and IF statement?