Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to generate the no against the lot no. since i have a common commision no. but in a commision no there are n no of lots so i want to generate no agaist lot no.
ex.
Commision no | Lot no. | reuired output |
---|---|---|
201282591201 | 10 | 1 |
201282591201 | 11 | 2 |
201282591201 | 12 | 3 |
201282591201 | 13 | 4 |
201282591201 | 14 | 5 |
201282591201 | 15 | 6 |
201282591201 | 16 | 7 |
201282591201 | 17 | 8 |
so every commision wise there are n no of lot no so i awnt those no based on lot no.
please find the attached sample data.
looking for help
Regards
Rohit
Hey Rohit
please see the working example
Please mark answer as correct if you get the output
Dear Sumaya,
one more help i want is
if the lot no is same then count no should also same.
i have attached sample file please help me out to sort that problem.
Regards
Rohit
Dude but above answer was correct right?
yes Sir, above answer is correct but now i am facing another problem please help me.
Regards
Rohit
Hi,
Try with AutoNumber function
LOAD Comm_No,
LOT_No,
AutoNumber(LOT_No, Comm_No) AS Output
FROM
dATA.xlsx
(ooxml, embedded labels, table is Sheet1);
Hope that helps
Celambarasan
Dude i have a question for this
i.e you should not have repetitive data .
Dear Sir,
Please use this file.
Regards
Rohit
Dear Sir,
I am not able to get you.
Regards
Rohit
Please check this for your use.
mark Correct if it is Correct
PFA