1

**General discussion / Re: Excel Questions**

« **on:**February 20, 2015, 11:16:51 AM »

Will the total in B always equal the total in D?I have quick question for the excel experts. I have some information I want sort quickly.

A B C D

1 alg 55 alg 55

2 als 45 als 45

3 avd 33 aox 47

4 aox 47 rst 35

Products are in A and C amounts in B & D

I need it to kick out a gap where the product isn't in both A&C

A B C D

1 alg 55 alg 55

2 als 45 als 45

3 avd 33

4 aox 47 aox 47

5 rst 35

Anyone?

Where do you need the gap, in row 3 you have it in column C, in row 5 you have it in column A

I need the gap where ever the product is not in both A&C. My first table is how my data looks now. My second table is the result of a sort I need to do. Product avd is not in C&D thats why I need a gap to appear. Product aox was not lined up in the first table is is in the second.