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
»
- VINOD G's blog
- Login or register to post comments
- 2605 reads
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
Vlookup seems to be the
Vlookup seems to be the solution but need more info to be able to answer anything substantially.