CHEQUES MAPPING IN XL

Sir / Madam's

I have data which contains cheques numbers and amounts from A1 to A41000 and B1 to B41000 (doubled).

now i have to map the same chq no. and same amounts i.e., EX:

chqno. amount

335664 1,00,000
335664 1,00,000
335664 1,00,000

110001 2,00,000
110001 2,00,000
110001 2,00,000

how do i do this. Kindly advice sir / Madam

VINOD

SUBTOTAL RELATED

sir,

I have data which contains cheques numbers and amounts from A1 to A41000 and B1 to B41000 (doubled).

I have applied Subtotals now i have to remove singles and keep doubles.

how do i do this activity

Vishesh's picture

Vlookup seems to be the

Vlookup seems to be the solution but need more info to be able to answer anything substantially.