how to place an item in different cells matching two criterias

D

devdutt_dev

hi,
i need another help....

col A col B col C col D
laptop h/w laptop
Ms Office s/w Ms Office
Adobe s/w Adobe
HDD h/w HDD

col C contains H/W and col D cointains S/W

i need a formulae that would categorise col A based on col B and fee
the data accordingly into col C and col D

thanks,

Devdut
 
D

Debra Dalgleish

In cell C2, enter the formula:

=IF(B2="h/w",A2,"")

In cell D2, enter the formula:

=IF(B2="s/w",A2,"")

Copy the formulas down to the last row of data.
 
Top