Victtor
Board Regular
- Joined
- Jan 4, 2007
- Messages
- 170
- Office Version
- 365
- Platform
- Windows
for the purpose of this spreadsheet, I have created some arbitrary groups:
these are located in column a.
cars
fast food
video games
beans
In column X, is a database of items that include these:
taurus
xj6
altima
sebring
taco bell
popeyes
mcdonalds
captain d's
halo
civilization
words with friends
donkey kong
pinto
blackeye peas
lima
northern
column W identifies what heading each item goes under (i.e. video games, beans, etc)
In column c, as the result of a formula, are these items again:
taurus
xj6
altima
sebring
taco bell
popeyes
mcdonalds
captain d's
halo
civilization
words with friends
donkey kong
pinto
blackeye peas
lima
northern
I need a formula that will automatically insert a group heading ABOVE the group in column C. In this example there are 4 items in each category. There could any number of items in any category. If there are no items for that category, that category is omitted. the categories always appear in this order (i.e. all fast food items, if any, will always come before any video game items)
here is an example of the ideal result in column C: <b></b>
<b>cars</b>
gremlin
xj6
altima
sebring
<b>fast food</b>
taco bell
popeyes
mcdonalds
captain d's
<b>video games</b>
halo
civilization
words with friends
donkey kong
<b>beans</b>
pinto
blackeye peas
lima
northern
can anyone help me?
these are located in column a.
cars
fast food
video games
beans
In column X, is a database of items that include these:
taurus
xj6
altima
sebring
taco bell
popeyes
mcdonalds
captain d's
halo
civilization
words with friends
donkey kong
pinto
blackeye peas
lima
northern
column W identifies what heading each item goes under (i.e. video games, beans, etc)
In column c, as the result of a formula, are these items again:
taurus
xj6
altima
sebring
taco bell
popeyes
mcdonalds
captain d's
halo
civilization
words with friends
donkey kong
pinto
blackeye peas
lima
northern
I need a formula that will automatically insert a group heading ABOVE the group in column C. In this example there are 4 items in each category. There could any number of items in any category. If there are no items for that category, that category is omitted. the categories always appear in this order (i.e. all fast food items, if any, will always come before any video game items)
here is an example of the ideal result in column C: <b></b>
<b>cars</b>
gremlin
xj6
altima
sebring
<b>fast food</b>
taco bell
popeyes
mcdonalds
captain d's
<b>video games</b>
halo
civilization
words with friends
donkey kong
<b>beans</b>
pinto
blackeye peas
lima
northern
can anyone help me?