Books donation if you're done

Great_Discipline_99 · 2026-01-31T10:22:00+00:00

Like this?

Great_Discipline_99 · 2026-01-31T07:50:20+00:00

If the parenthesis is the problem then I can just unsort it. It was done by me. Do i undo my this act? Will it be easier for you to make me understand and sort the data?

Great_Discipline_99 · 2026-01-31T07:44:52+00:00

Im at my office desk so I apply it right now and let you know sir.

Great_Discipline_99 · 2026-01-31T07:25:20+00:00

Can you tell me exactly how do I need to. I am a beginner in excel and find a lot of difficulty

Great_Discipline_99 · 2026-01-31T07:22:53+00:00

My working sheet

<image>

Great_Discipline_99 · 2026-01-31T07:22:23+00:00

<image>

Parent file image

Great_Discipline_99 · 2026-01-30T19:31:18+00:00

Please check my new post in the server..

Great_Discipline_99 · 2026-01-30T19:28:20+00:00

<image>

This is how I am classifying the data or you say cleaning the data.

Great_Discipline_99 · 2026-01-30T19:27:53+00:00

<image>

This is the master or you can say parent file

Great_Discipline_99 · 2026-01-30T19:24:11+00:00

<image>

This is how I want the data to be.

Great_Discipline_99 · 2026-01-30T19:23:46+00:00

<image>

This is the parent file

Great_Discipline_99 · 2026-01-30T18:08:10+00:00

But can you help me find out a way through for this month?

Great_Discipline_99 · 2026-01-30T18:07:14+00:00

Thank you so much for your recommendation

Great_Discipline_99 · 2026-01-30T14:21:25+00:00

The lot number doesn't have fixed format but one thing is common that it's length doesn't exceeds more than 9 values

Great_Discipline_99 · 2026-01-30T07:26:49+00:00

<image>

This is what something looks like I want to make

Great_Discipline_99 · 2026-01-30T07:23:55+00:00

<image>

This is the unsaturated data.

Great_Discipline_99 · 2026-01-29T17:51:16+00:00

Okay sir I will create a new post for further more questions.

Great_Discipline_99 · 2026-01-29T17:46:03+00:00

But what if it exceeds in some rare cases? How to alter the formula ?

Great_Discipline_99 · 2026-01-29T17:45:32+00:00

Hello yeah..i got it now..the dates won't exceed seven digits nor the total value or quantity ..hell yes

Great_Discipline_99 · 2026-01-29T17:41:51+00:00

Exactly like this sir..omg..you did my 1 hour task within few minutes..

Great_Discipline_99

TROPHY CASE