Select data range ColA to ColD. DataSort criteria1 ColB Ascending
criteria2 ColC ascending. This will group ColB. Now

1. Select the data range in ColC (say C1:C100).
2. Press F5. From 'Goto window'Special from Options select 'Blanks' and
hit OK
3. This will select all blanks.
4. Now press = (equal sign)
5. Then press Up Arrow to reference the cell just above
6. Now press Ctrl and Enter key together

If this post helps click Yes
---------------
Jacob Skaria


"palups" wrote:

Hello,

Need help, just wondering how to fill colomn C using vlookup,match,index, etc.
suppose colomn B has a value of 54321 and with colomn C value of 1 given, I
want to fill all C colomn with "1" which have a value of 54321 in colomn B,
and so on...


A...............B.............C..................D

ashish 54321 1 suresh
ashish 54321 suresh
ashish 54321 suresh
sanjay 65743 5 sanjay
sanjay 65743 sanjay
pongal 65789 34 rajesh
pongal 65789 rajesh
pongal 65789 rajesh
ashish 54321 pongal
rajesh 43567 456 ashish
rajesh 43567 ashish
rajesh 43567 ashish
rajesh 43567 ashish
suresh 54672 321 ashish
suresh 54672 ashish
suresh 54672 ashish
suresh 54672 ashish
ashish 54321 ashish


thanks in advance.