Home » Blogs » VINOD G's blog

CHEQUES MAPPING IN XL

Submitted by VINOD G on 11 October, 2012 - 12:37

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

Submitted by VINOD G on 12 October, 2012 - 05:03.

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

Submitted by Vishesh on 11 October, 2012 - 16:29.

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

»