Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewise

**paradise2sr** · 03-29-2023, 04:58 AM

Hi,

I am trying to prepare a report that will keep only the positive value after removing/adjusting/adding negative values to positive value either full or partial or more than one or only one.

The logic behind is that any negative values must be setoff with every positive value on FIFO basis i.e taken datewise ascending order or ID in ascending order.

Sample Raw data with expected result two visible worksheet is attached for your kind reference.

I want the result of F column which is highlighted with yellow.

Macro or some VBA if possible would speedup the task as this is of one customer. However,I have many say more than 1 k.

**karedog** · 03-29-2023, 12:47 PM

Not too sure, but your data already sorted in ascending mode, both for date and ID, so the statement :

Originally Posted by paradise2sr

... on FIFO basis i.e taken datewise ascending order or ID in ascending order. ...

is meaningless here.

Please Login or Register  to view this content.

**paradise2sr** · 03-30-2023, 02:58 AM

Thanx for your kind response.It seems to work in those stated columns presented as expected.

Since the demo data was infact was the reduced version of unnecessary columns of real data and was not sure would arrive at the solution.

I have added my original structure of data.I have hidden certain columns in order to avoid confusion. You may unhide for your kind reference.

Can you kindly restate the # Post 2 code in the enclosed data structure.

I want the result in J column which currently as per your code displaying in H column subject to slight change in structure of #Post1 attachment.

**karedog** · 03-30-2023, 04:25 AM

You are welcome.

The adjusted code should be like this :

Please Login or Register  to view this content.

**paradise2sr** · 03-30-2023, 05:19 AM

Thanx a lot. Wonderfully worked for a single customer.

Indeed a great respect to you.

One last things, this structure was of a single customer. How the same things can be achieved in K column if I have multiple customers.
With the tweaks is that a customer name is assigned manually in H column now and I & J columns are similar to the earlier posts.

So,I want H,I,J columns through vba code (which is currently mentioned manually & by formula) and of course K column expected result of previous post.

Since change in customer indicates change in adjustment as well as highlighted in H column are the unique data to the left hand side.

I hope,you will sort out the issue in case multiple customer case.I have simply presented for 4 customers only.There are infact more than 1k customers and data lies just below.

**paradise2sr** · 03-30-2023, 09:49 PM

Hi,karedog,Is there any updates to the Post #5.
Basically, I am trying to build agewise report say for each customer for eg.<=30, 30 to 60 days,60 to 90 days,90 to 120 days,120 to 150 and above 150 days,etc.

For single case you have already helped me which is highly appreciated .

Now,I stumbled into multiple case as stated in Post#5.
I cannot post in separately becoz it would be a duplicate post and is inter related to this post.

If u require any further information regarding post 5.Kindly let me know.

**karedog** · 03-31-2023, 09:32 AM

Please Login or Register  to view this content.

**paradise2sr** · 03-31-2023, 01:13 PM

Thanks 👍. Perfectly worked as expected.I have tested more than 10k data.Thanx a lot.

**paradise2sr** · 03-31-2023, 10:05 PM

Hi,can you change the line of code of 5th line"Sheet1" .I want to use in any worksheet and not specific one i.e to be more flexible in any sheet working.Simply run the macro and remaining process that I can do at my end.

**karedog** · 04-01-2023, 04:01 AM

You are welcome, thanks for marking the thread as solved and rep.points given.

The adjusment is :

Please Login or Register  to view this content.

Regards

**paradise2sr** · 04-01-2023, 07:39 AM

Thanx with your kind help,I am able to proceed to final step.

Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewise

LinkBack

Thread Tools

Rate This Thread

Display

Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewise

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Re: Remaining positive value after adjustment of negative value on 1st come 1st i.e Agewis

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Random selection from remaining items, volatile manual adjustment

Calculate cost basis of remaining shares of stock

Convert negative to positive in sheet containing both positive/negative numbers

Excel 2007 : Extracting positive value from mixture of positive and negative value in Excell

Calculating The Largest Negative Number within a Range of Positive & Negative Numbers

Showing a negative as a positive and a positive as a negative number

Formula to make Negative Values Positive & Positive Values Negative?

Bookmarks

Bookmarks

Posting Permissions